MOSS BDC and Business Data List Web Part

Business Data Catalog is a Microsoft Office SharePoint Server feature that allows users to access external data from within SharePoint. In order to use the BDC features, you need to setup a Business Data Catalog Definition file (XML) that defines the structure of the external system that you want to conect to Sharepoint.

Microsoft has released a tool called Business Data Catalog Definition Editor (available in the Sharepoint SDK) that helps you to create the XML file that must be imported via the Sharepoint Central Administration. Unfortunately, this tool is really far from what could be called a great tool! :)

The Business Data Catalog Definition Editor has a main "bug"... Try to load a definition file in Sharepoint and then use a Business Data List Web Part. When you select the Business Data Type, you'll receive an error: there are no Business data Types Loaded in the Catalog.

Why this? Because the Microsoft tool does not generate the "Finder" method (the method used by the Business Data List Web Part for retrieving data). It creates only a "SpecificFinder" and a "IdEnumerator" methods.

The only way I've found in order to solve this problem is to manually create the "Finder" method. The easy way is to change the MethodInstanceType property of the "IdEnumerator" method to "Finder":

BDC_Bug

Now your Business Data List Web Part is ready to show your data.

Whe we'll have a new and "less buggy" Business Data Catalog Definition Editor from Microsoft?

Technorati Tag:

Print | posted on Monday, July 14, 2008 2:37 PM

Comments on this post

# re: MOSS BDC and Business Data List Web Part

Requesting Gravatar...
Thanks a lot man!

Have a look at forums.technet.microsoft.com/.../#page:1 where discussions are still ongoing
Left by Daniel on Aug 14, 2008 5:31 PM

# re: MOSS BDC and Business Data List Web Part

Requesting Gravatar...
this sharepoint stuff is so boring... no wonder consultants asks for a lot of cash when dealing with this cow...

Can't wait for open source solutions to replace this sharepoint cr*p..
Left by AlexanderN on Aug 15, 2008 3:37 PM

# re: MOSS BDC and Business Data List Web Part

Requesting Gravatar...
This is your opinion... I think that Sharepoint is a great framework for building line of business applications. Open source solutions to replace it? Welcome...
Left by Stefano Demiliani on Aug 15, 2008 5:32 PM

# re: not open source - but simple: BDLC

Requesting Gravatar...

A more simple approach even for Windows SharePoint Services: The SharePoint Business Data List Connector (BDLC) provides the complete read-

only features of a common SharePoint list for almost any external data sources in 3 simple steps only:

- enter connection string
- enter select statement
- choose primary key(s)

Then your data are in a real SharePoint list. Updates are done in backround very fast (batch update, changed data only). So you have all list

features available, e.g. notifications and workflows to takr business actions, if external data records are changed.

www.layer2.de/.../...ness-Data-List-Connector.aspx
Left by Frank on Jul 26, 2009 1:24 PM

# re: MOSS BDC and Business Data List Web Part

Requesting Gravatar...
Thanks a lot. It made my bdc work :-)
Left by Tiji on Feb 02, 2010 12:12 PM

# replica watches

Requesting Gravatar...
:P good!
Left by watches replicas on Apr 29, 2010 2:45 AM

# re: MOSS BDC and Business Data List Web Part

Requesting Gravatar...
e Microsoft tool does not generate the "Finder" method (the method used by the Business Data List Web Part for retrieving data). It creates only a "SpecificFinder" and a "IdEnumerator" methods.

The only way I've found in order to solve this prowholesale laptop battery and wholesale laptop adapter.
Left by wholesale laptop adapter on May 23, 2010 2:26 PM

# clothing manufacturerart

Requesting Gravatar...
A more simple approach even for Windows SharePoint Services: The SharePoint Business Data List Connector (BDLC) provides the complete read-
Left by clothing manufacturer on Mar 06, 2011 3:37 PM

Your comment:

 (will show your gravatar)
 
Please add 2 and 7 and type the answer here: