SharePoint BCS-Simple Instance (i) Data source additions

This article is based on SharePoint Foundation.

I have a patient information sheet patient in my database, and now I want to put the data in this table in an external list in SharePoint, which is easy to maintain with SharePoint. The first part of this article is to add an external database as a data source for the SharePoint external content type.

The site is a blank site that opens SPD first for external content type creation.

Open SPD, open our website, select the internal content type, click the new External Content Type Ribbon button.

We can make a name for the external content type, and then click on the "click here to find external data source and define action" link in the External System column, we see here the connection is currently empty, click the "Add Connection" button, type select "SQL Server", click "OK" button.

Pop up the SQL Server Connection Configuration box, where you'll fill in the information about the database you want to connect to. I am using this machine here, check the connection using the simulated custom identity. Fill in the following:

The BCS Secure Store window will then pop up, enter the username SA and password, and click the "OK" button.

As shown in the Database Explorer, we see that the database we are connecting to has been added.

This completes the add operation of the data source.

SharePoint BCS-Simple Instance (i) Data source additions