How to: Create and Export a BDC Model Using SharePoint Designer
Microsoft® SharePoint® Designer 2010 enables you to quickly and easily create external content types (ECTs) for any external data source. However, there are limitations in the tooling that SharePoint Designer 2010 provides.
This how-to topic assumes that your external line-of-business (LOB) system uses a Microsoft SQL Server® database and is connected as a SQL Server data store.
This document models the many-to-many relationship shown in the following illustration.
To create your initial BDC model file
Create a new empty SQL Server database, and name it PartsManagement.
Create new SQL Server tables as shown in the preceding illustration (Machines, MachineParts, and Parts).
Start SharePoint Designer 2010 and connect to your SharePoint site.
Select External Content Types from the left pane.
Click the new External Content Type button located in the New group of the Ribbon.
Type the ECT name in the Name and Display Name text boxes.
Select the Click here to discover external data sources and define operations link.
Select the Add Connection button.
Select SQL Server for the data source type, and click OK. The following SQL Server dialog box will appear.
Type the connection information to connect to the SQL Server database, and then click OK. The data source explorer will now contain the database you specified.
For simplicity, select Connect with User’s Identity to use pass-through authentication.
Click the Data Source Explorer tab, and find the Parts table. Select the table, right-click, and then select Create All Operations.
Complete the wizard by accepting all default settings.
Save the ECT.
Repeat Step 4 to create external content types for the Machines and MachineParts tables.
After you configure all of the ECTs, select External Content Types from the left pane. A list of all ECTs will appear.
Select all the ECTs by pressing the Ctrl key while you click each ECT name. Right-click the selection, and select Export BDC Model.
Enter the model name and location, and then click OK.
Select the save location, and then click Save.