Sample: Map Business Data Catalog Properties to User Profile Properties 

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

The MapBusinessDataPropertiesToUserProfiles code sample available in the Microsoft Office SharePoint Server 2007 SDK code samples download in the Microsoft Download Center demonstrates a programmatic way of mapping properties from a business application that uses Business Data Catalog to the user profile properties. The sample demonstrates the following subtasks:

  1. Importing an application definition file into Business Data Catalog.

  2. Creating a Business Data Catalog connection by passing the application definition file location.

  3. Creating a profile import connection mapped to the Business Data Catalog connection.

  4. Creating profile properties.

  5. Mapping the newly created profile properties to the properties available from the Business Data Catalog application.


A server computer on which you have administrative privileges and containing the following:

  • Microsoft Visual Studio 2005

  • Microsoft Office SharePoint Server 2007

  • Microsoft SQL Server 2000 or later


To execute the sample, do the following:

  1. Open SQL Query Analyzer and execute the CreateDB.sql script. This creates a database called EmpManagement with a table called EDS with the correct schema for the sample.

  2. In the EDS table, enter some rows so you can test the sample.

  3. In Visual Studio.NET 2005, open the ProfilePropertiesSetup solution, and edit the three constants at the beginning of the code, as appropriate.

  4. Using your administrative privileges on the server, execute the code sample.