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.
Note: 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.