Enterprise Information Collection Web Aspect in SharePoint 2010 is used to present the Range of Enterprise data within a metered perspective structure. The Enterprise Information Collection web part is the most widely used web part for showing LOB data.
I have created a database in SQL which has a table with some data.
"Sample" table has the following items.
External Content Type:
I have created an external content type named "New External Content Type" to integrate the external data to SharePoint using SharePoint Designer.