.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Business Data Catalog Definition Editor

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :SharePoint
Hi folks, I want to add a chart web part to my site getting data directly from a SQL-Server table. Can I add Business Data Catalog using SPD or do I need the Business Data Catalog Definition Editor. Where can i download it for Sharepint 2010 Enterprise Farm. You miss 100% of the shots you do not take!

View Complete Post

More Related Resource Links

Cannot Import application Definition to Business Data Catalog (BDC) -- Error: Access Denied

I want to import an application definition to my Business Data Catalog (BDC).

I log into my Shared Service and select Import application definition.

I am redirected to page that says Error: Access Denied

My account is:

1. An Administrator on the windows server running sharepoint
2  A member of the Farm Administrators
3. Added individually with Full Control to Central Administation
4. Added individually with Full Control to my shared service.

John Bailo

Business Data Catalog Application Definition File with SSO

Does anyone have a working copy of BDC application defintion file with Single-Sign-on?  Please share it with me if you have it?


Regarding Business data catalog in SharePoint


Hi All,

          I am using business data catalog to display the records present in the Active Directory based on the user selection of samAccountName. Since the number of records present in Active Directory are more than 3000 the user has to iterate through each page to get to a particular record. I want to add a kind of filter to my Definition file that user can search for a particular samAccountName from the list of samAccountName displayed in the business data list web part. I am using office server SDK by microsoft to generate the application definition file.

Any help regarding this will be appreciated.



Accessing MySQL Data using ODBC w/ BDC Definition Editor


Hello everyone.

Background: I'm a computer science student doing some work for a non-for-profit, and have minimal experience with SP 2007, ODBC, etc.

Overview: I'm trying to create a BDC definition file using the definition editor (found in the SDK), rather than editing a template XML manually. I found this thread to be fairly helpful in getting me started on what seems to be the right path: http://social.msdn.microsoft.com/Forums/en/sharepointbdc/thread/833a9583-5f4c-4ed9-b9c8-f5834b790375

In order to establish a connection to the remotely hosted MySQL database I must provide an ODBC source for the client user/system, correct?

 My questions are: 

  • How does using ODBC affect things once I upload the ADF to the Shared Services Provider (SSP)? Do I now need to provide a duplicate ODBC Source on the server hosting sharepoint for the BDC to connect to the database? Apologies if I am not understanding this correctly.
  • If the above process is correct, how might I expect this process to change for sharepoint 2010? The organization is looking to roll-out SP2010

Input Validation: Enforcing Complex Business Data Rules with WPF


Windows Presentation Foundation has a rich data binding system that includes flexible support for business data validation. We take a look at implementing some complex data input validation scenarios that include customized data errors for users.

Brian Noyes

MSDN Magazine June 2010

Editor's Note: The Capability-Delivery Business


This month's issue of MSDN Magazine takes a look at some of the new features and tools in Visual Studio 2010 and Microsoft .NET Framework 4 that will continue improving the experience of creating business applications that run on the Microsoft Office platform. This is an area of software development that holds tremendous potential in terms of solving the right problems-those being the business problems. To get to the next step of really transforming the manner in which business is conducted, highly domain-specific functionality must be developed below the metaphorical surface-and thus can only be meaningfully implemented by you.

Howard Dierking

MSDN Magazine October 2009

Editor's Note: I Am The Business


At an open spaces conference in Austin, Texas, Editor-in-Chief Howard Dierking realizes that software development and business goals can both coexist and benefit each other.

Howard Dierking

MSDN Magazine December 2008

Editor's Note: Flex Your Data


Filling in for Editor-in-Chief Howard Dierking, Ted Neward lends some insight into the state of data collection and manipulation.

Ted Neward

MSDN Magazine July 2008

Mine Your Business: AMO Lets You Dig Deeper into Your Data from Your Own Applications


Analysis Management Objects (AMO) for SQL Server 2005 facilitates client-side custom programming as Decision Support Objects (DSO), the object model in SQL Server 2000 Analysis Services. With AMO, a whole range of data mining questions can be answered at the operational level. This means that sales and marketing departments get answers more quickly and thus can make informed decisions.

Liu Tang and Paul Bradley

MSDN Magazine June 2005

Spider in .NET: Crawl Web Sites and Catalog Info to Any Data Store with ADO.NET and Visual Basic .NE


Visual Basic .NET comes loaded with features not available in previous versions, including a new threading model, custom class creation, and data streaming. Learn how to take advantage of these features with an application that is designed to extract information from Web pages for indexing purposes. This article also discusses basic database access, file I/O, extending classes for objects, and the use of opacity and transparency in forms.

Mark Gerlach

MSDN Magazine October 2002

Business Data Error: System.OverFlowException


I have a Business Data Catalog file I've uploaded to connect to our back end Firebird DBMS through ODBC.

The SharePoint server is MOSS 2007 x64. The web front end server(s) all have an x64 Firebird Engine and ODBC driver with verified connectivity to Firebird.

When I use one of the methods, I can see connections being made to our Firebird server and the query being passed. I know the query returns results (it's a stored procedure with no parameters), but I get the following error "An error occurred while retrieving data from MROTest1. Administrators, see the server log for more information" in IE. If I look in the server logs, I see (12\Hive\Logs)

Exception handed to HandleRuntimeException.HandleException System.OverflowException: Arithmetic operation resulted in an overflow.     at System.Data.Odbc.OdbcDataReader.GetData(Int32 i, SQL_C sqlctype, Int32 cb, Int32& cbActualOut)

Business Data Column cascade


Good afternoon, I would like to know if is possible to have two business data columns linked to each other. This is the scenario that I want:

BD Column 1 called State with all US states

BD Column 2 called City with all the cities based on the state selected on BD Column 1

Creating .NET Assemblies That Aggregate Data from Multiple External Systems for Business Connectivit

This article describes a quick, four-step process for creating a .NET assembly that BCS can use to retrieve external data for SharePoint Server 2010 by using Visual Studio 2010.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint Server

Learn how to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Sample: Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint

Download sample code as you learn to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Module 6: Accessing External Data with Business Connectivity Services in SharePoint 2010

SharePoint 2010 provides a new set of technologies known as Business Connectivity Services for retrieving, editing, updating, and deleting data from external systems.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend