Create an External Content Type via SharePoint Designer

In this hint, I will elaborate How to create an external content type via SharePoint Designer by following the mentioned steps below :

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

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

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

  • Fill Database Server Name and the database name then click “Ok”.

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

  • Now 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” check box and click “Ok”
    • And the SharePoint designer will create your list with full operations.

Enjoy 🙂

Check 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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s