SharePoint 2013 BDC Configuration and Creating External Content Type and External List Part Two

set up business data connectivity service sharepoint 2013
InfoPath alternatives for form designing SharePoint

In Part One of the same article we have configured the Secure Store Service, here in this part we will continue exploring BDC Service with the Creation of External Content Type and External List in SharePoint 2013.

Create External Content Type  SharePoint 2013

1. Start the SharePoint Designer, click on Open Site in SharePoint Designer, then give the URL of the site in the browse window.

2. Your site is opened in SP Designer in the Left Navigation click on External content Type

sharepoint 2013 bdc model
sharepoint 2013 bdc model

3. In the New External Content Type window give a desired Name, Display Name, Namespace and External System for external Content Type. To select the External System click on the link “click here to discover external data sources.”


business data connectivity model sharepoint 2013
business data connectivity model sharepoint 2013

4. Initially no Data Source will be present in the Data Source Explorer, So click on Add Connection, In the External data Source Type Selection window select SQL Server.

set up business data connectivity service sharepoint 2013
set up business data connectivity service sharepoint 2013

5. For SQL Server Connection give the Database Server, Database Name, Name of the connection, select the connection mode as windows Identity and give the correct Secure Store Application ID.



sharepoint 2013 external content type
sharepoint 2013 external content type

6. Give the credentials for BCS Secure Store Target Application ID.

sharepoint 2013 external list
sharepoint 2013 external list

7. Now the Data Source you created connection with will be displayed in the Data Source Explorer. We explore the database to get the Table or View or Routine on which we need to create operations for the External Content Type.

8. Here we perform only read operation, for that Right Click on the Table or View or Routine you want to create operation and from the list select New Read Item Operation.



create external list sharepoint 2013
create external list sharepoint 2013

9. For Read Item Set the Operation Properties: The Operation Name, DisplayName, Type will be populated automatically. The initial two values can be edited to their desired values. Click Next to proceed.

how to create external content type in sharepoint 2013
how to create external content type in sharepoint 2013

10. For Read Item Set the Input Parameters Configuration: Here you select a particular Data Source Element, and Check the Map to Identifier. Click Next to proceed.

business data connectivity model sharepoint 2013
business data connectivity model sharepoint 2013

11. For Read Item Set the Return Parameters Configuration: Here you again select a Data Source Element and make sure you Check all the elements you want to display, and in the Properties Check the Map to Identifier. Click Finish to proceed.

sharepoint 2013 external list rest api
sharepoint 2013 external list rest api

12. Once you have created the New Read Item Operation, It is advisable to go for Read List Operation as well. Right Click on the same Table or View you want to create operation and from the list select New Read List Operation.

sharepoint online external list
sharepoint online external list

13. For Read List Set the Operation Properties: The Operation Name, Display Name, Type will be populated automatically. The initial two values can be edited to their desired values. Click Next to proceed.

create external content type sharepoint online
create external content type sharepoint online

14. For Read List Set the Filter Parameters Configuration: Here we can Add Filter to the list if required any or else click Next to proceed.

external content types are not available sharepoint 2013
external content types are not available sharepoint 2013

15. For Read List Set the Return Parameters Configuration: Here you again select a Data Source Element and make sure you Check all the elements the way we did in Read Item Return Parameters Configuration Click Finish to proceed.

sharepoint online external content types are not available
sharepoint online external content types are not available

16. The above steps will create the External Content Type and then to give Permissions to the same Go to Central Administration > Application Management > Manage service applications > Click Business Data Connectivity Service,

sharepoint 2013 bcs tutorial
sharepoint 2013 bcs tutorial

17. Select the created External Content Type and click Set Object Permissions.

sharepoint 2013 bcs step by step
sharepoint 2013 bcs step by step

18. Click Add and give the Object Permission to All Users (windows), and select the Level of Permissions to be given to them below and click OK.

bcs sharepoint 2013 example
bcs sharepoint 2013 example

19. Select the created External Content Type and click Set Metadata Store Permissions.

bcs in sharepoint 2013 using visual studio
bcs in sharepoint 2013 using visual studio

20. Click Add and give the Metadata Store Permissions to All Users (windows), and select the Level of Permissions to be given to them below and click OK.

sharepoint 2013 bcs tutorial
sharepoint 2013 bcs tutorial

Read some SharePoint 2013 tutorials below:

Create External List using SharePoint 2013 designer:

1. In SP Designer on the Left Navigation click on External content Type, Select the Recently created External Content Type, and in the Ribbon click External List.

business connectivity services sharepoint 2010
business connectivity services sharepoint 2010

2. Give a Name and Description to your External List and click OK,

business connectivity services sharepoint 2013
business connectivity services sharepoint 2013

3. Now on the Left Navigation click on Lists and Libraries to see your External List in the External List section.

set up business data connectivity service sharepoint 2013
set up business data connectivity service sharepoint 2013

4. Open the External List in the browser. PEACE.

business data connectivity service sharepoint 2016
business data connectivity service sharepoint 2016

Summary:
In this part we have explored the BDC with establishing SQL Server Connection, Creation of External Content Type, Setting Permissions and Creation of External List.

Similar SharePoint 2013 Tutorials


About Akash Kumhar

I am Akash Kumhar a SharePoint Consultant.

View all posts by Akash Kumhar →

Leave a Reply