BCS Using SQL Server in SharePoint 2013

Now we can see all the tables and views from the selected database.



Step 12

Now we have options to create various types of operations against the selected table. In our scenario since we need to perform all the operations. Select “create all operations”.



Step 13

Click Next.



Step 14

Select parameters configuration and other settings as in the following.



Step 15

Click the Next button.

Step 16

Do the filter parameter configuration and click the Finish button.



Step 17

Now we need to add the new external list. So, click LIST AND LIBRARIES and select External List as in the following.



Step 18

Select the site, external content type and click the button “OK”.



Step 19

Enter the list name, description and click the button ”OK”.



Step 20

Go to the site and select all the site contents. The External list will be visible there.



Step 21

Open the list and make a new entry.



Step 22

Verify the entry in the back end (SQL Server).



Note

You may encounter permission issues after the completion of the preceding procedure. In this case you need to set the permission for the external list. Go to the SharePoint Central Admin -> Manage Service Application -> Business Data Connectivity Services and select the newly created external content type from the list to set permission.