SharePoint Tools Updated

An updated SDK for SharePoint Server 2007 delivers two important improvements: A tool to help connect the Business Data Catalog (BDC) to internal applications and databases, and updated but still incomplete documentation for developers. The new BDC tool could make one of SharePoint Server’s most important developer features more practical to use, although it has limitations.

The BDC allows SharePoint to present data from back-end systems, such as databases and Web services, through a number of prebuilt Web Parts. Configuring the BDC requires developers to create metadata, a complex combination of XML and the SQL query language, to describe the source database or Web service. However, the initial BDC release provided no tools for developers to create metadata.

The Aug. 2007 release of the SharePoint SDK remedies this by including a new tool, formally known by the absurdly long name of Microsoft Business Data Catalog Definition Editor for Microsoft Office SharePoint Server 2007 (MBDCDEMOSS). The tool provides a graphical tree view and property pages that enable a developer to write metadata without directly writing XML. However, the tool is not integrated with Visual Studio and lacks some seemingly obvious features. For example, while nearly every other database tool from Microsoft presents a list of available servers and databases to connect to, this tool requires the developer to enter the connection string manually.