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

create external content type sharepoint 2016
InfoPath alternatives for form designing SharePoint

In this article we will explore BDC Configuration in SharePoint 2013 with Secure Store Services, which involves Start of the Secure Store Service, Creation of Secure Store Service Application, External Content Type and External List.

Here we go step by step:

Start a secure store service in SharePoint 2013:

1. In the Central Administration > System Settings > Manage Services on server.

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

2. In the Services List, Click Start next to the Business Data connectivity Service and Secure Store Service.


sharepoint 2013 bcs tutorial
sharepoint 2013 bcs tutorial

Generate New Key:

1. In the Central Administration > Application Management > Manage service applications.

sharepoint 2013 bdc tutorial
sharepoint 2013 bdc tutorial

2. Click the Secure Store service application.



sharepoint 2013 bdc visual studio
sharepoint 2013 bdc visual studio

3. In the Key Management section, click Generate New Key.

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

4. On the Generate New Key page, type the Pass Phrase, and type the same string in the Confirm Pass Phrase and click OK. This pass phrase is used to encrypt the Secure Store database.

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

Read some SharePoint 2013 tutorials below:

Create a new secure store service application in SharePoint 2013:

1. In the Central Administration > Application Management > Manage service applications > Secure Store Service.

2. In the Manage Target Application section, click on New

create external content type sharepoint 2013
create external content type sharepoint 2013

3. On creating a new page Enter your Target Application ID, Display Name, Contact E-mail, select your Target Application Type, Target Application Page URL and click Next.

create external content type sharepoint 2016
create external content type sharepoint 2016

4. Select Field Type: Windows User Name for Field Name: Windows User Name & Field Type: Windows Password for Field Name: Windows Password and click Next.



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

5. Now give the appropriate users for Target Application Administrators and Members and click OK.

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

6. The newly created Secure Store Application ID will be displayed on the page select the Secure Store Service Application ID and click “Set” in the Credentials Section.

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

7. To Set the Credentials Give the Windows Username, Windows Password, Confirm Your Entered Password and click OK

Note: In the Windows Username and Windows Password use the credentials of the user who has access to SQL Server Database you want to use.

business connectivity services in sharepoint 2013 step by step
business connectivity services in sharepoint 2013 step by step

Summary:
In this Part we have explored the configuration of Secure Store Service. In Part-2 of this article we will explore BDC with Creation of External Content Type and 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