SharePoint 2013 - External Content Types (BCS) - Part 1

This articles will explain you how to configure external content types.

Step 1 : Open any site using SPD(SharePoint Designer)
Step 2 : Click on External Content Types link from left navigation
Step 3 : Click in External Content Type from menu button
Step 4 : Provide Name, Display Name, Namespace etc as per below screenshot.

Step 5: Click on External System Link
Step 6: Click on Add Connection and select Data Source Type as SQL Server.
Step 7 : Provide Database Server Name, Database Name and select "Connect with User's Identity".

Step 8 : Select any Table and right click on it and select  "Create All Operations". Finish the wizards.

Step 9 : Steps to create external content type "BCSDemo" are completed.