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

Your comment:

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