Create an external content type (BCS) using SharePoint Designer 2010

In an implemented environment if you have a ready-made SQL database, how can you quickly convert to SharePoint list with SharePoint's BCS capabilities, using external content types to quickly and easily implement your requirements.

1. First open your site with SharePoint Designer-the external content type.

2. Click External Content Type

3. Click here to discover external data sources and define actions

4, add the connection (I'm using ADVENTUREWORDSDW here to do an example), the data source type Select SQL Server.

5, here I choose to use the user ID for continuous.

6, here I choose DimProduct table, right click Create all actions

7. We will create it here.

8, so far only completed a part, if now direct browsing will prompt a user login failed or user ' NT authority \ ANONYMOUS LOGON ', in the above error occurs, because by default, when we create the BDC 2010 SPD definition, The authentication mode is set to "user identity". The "Connect with user identity" is the "Passthrough" authentication mode of our moss. BDC. The other 2 involve SSO. Now that we have a secure storage service application, we can use "Connect with emulated Windows Authentication" or if we use a claims token, we can use "Connect with impersonation Custom identity" in the sequence to access data from an external data connection, one of the ways to solve the above problem is to change the authentication mode from " User identity "to" BDC identity ". So now we're going to open the SPD2010 external content type and change the authentication mode.

9. Edit the connection properties to change the user ID to the BDC identity

10, now, we will meet the new error prompt, it's OK, we continue to operate down.

Here are the steps we need to follow to get this corrected! We must first enable the BCS model to accept one of the "RevertToSelf" Authentication modes. Yes, it is disabled by default. To do this, we can use the SharePoint 2010 Management Console. The "revertoselfallowed" property is set to the default value of FALSE. Now, we can change it to use the following script:

    "Business Data Connectivity Service"};       $BDC. reverttoselfallowed = $true;       $BDC. Update ();  

11, the last step, to the management Center, business Data Connectivity Service Add the next public limit on the line.

12. Finally, let's take a look at the final effect.

Create an external content type (BCS) using SharePoint Designer 2010