Use SharePoint designer to create a business data connectivity service for external data connection

You can customize external data connections in Sharepoint. There are two methods:CodeCreate, and implement code through.ArticleThis section describes the simplest code-free creation process, and connects to the SQL server data source using Sharepoint.

Step 1: Create a database and the database tables used in SQL Server

1): Create an ericsundb database in SQL Server and a corresponding table product [primary key: productid is int type and auto-increment. Both productname and productdescription are nvarchar ]. The creation process is described as follows.

Step 2:Create a secure Store service application in Ca (this step can be omitted)

1): Manage service applications in Ca --> secure Store service --> generete new key

2): in the secure Store service in the previous step, a corresponding new application (I .e., click the new button)

3): click "Next" to enter the corresponding data. The created data can be viewed as follows:

Step 3: create a connection to the SQL database in SharePoint designer

1): Open SharePoint designer and select external content types --> click external content types in the above line of ribbon, as shown in

2): Click Connect external system (Click here to discover external data sources and define operations .) create a connection, that is, click Add connection, select SQL Server for type in data source, enter the correct information, and create a connection named ericsunsqlconnection.

3): indicates the effect after the connection is created.

3): Expand the created SQL connection, locate the product table in the database, right-click and choose create all options, configure the table, and save the overall settings.

--- Configure

Step 4: Configure business data connectivity service in CA

1): view external content types

 

2): Set object permission

 

3): Set metadata store permission

 

4): Create Update (then the default action has a value)

 

 Step 5: Create an external list in SharePoint

1): Create an external list.

2): select the corresponding external content type

3): Check the results in the list. items correspond to records in the database and are updated in real time in two directions.