Create an External Content Type via SharePoint Designer

In this hint, I will elaborate How to

Create an external content type via SharePoint Designer In SharePoint


Steps:

  • Open SharePoint designer > Connect to your site.
  • In the Navigation area select “External Content Type.

Create an external content type via SharePoint Designer In SharePoint

  • From the top menu select “External Content Type” to create a new one.
  • In External Content Type information, specify the needed information.

Create an external content type via SharePoint Designer In SharePoint

  • Click on “Click here to discover external data sources.
  • Click “Add connection” and select “SQL Server”.

  • Set the “Database Server” Name and the “Database Name” then click “Ok”.

SQL-Server-Connection in external content type in SharePoint

  • In Data Source Explorer, you should see your database.

Data-Source-Explorer In External Content Type

  • Select an object from your database that you want to use it as an external source.
  • Right click on the table and select “Create All Operations”.
  • In the wizard page, select your table identifier > click Next > finish
  • Now you are done and you need to create your external list,
    • Click on “Create Lists & Forms” in the top ribbon
    • Click yes to save your external content type
    • Type List Name, select “Create InfoPath Form” checkbox and click “Ok”
    • And the SharePoint designer will create your list with full operations.

Applies To
  • SharePoint 2016.
  • SharePoint 2013.
  • SharePoint 2010.
See Also

Access Denied by Business Data Connectivity in SharePoint.

Advertisements

One thought on “Create an External Content Type via SharePoint Designer

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s