How to create External Data Column in SharePoint 2010

In this article we will be seeing how to create external data column in SharePoint 2010. MOSS 2007 provided the Business Data List Column type,  in SharePoint 2010 Business Data List Column is renamed as External Data Column which enables users to add data from the external content types to standard SharePoint lists.

Creating an External Content Type:

Before we integrate external data to the SharePoint, we need to create an external content type.  You can use the SharePoint designer to create an external content type. In this example, we will be using  SharePoint Designer 2010. Following are the steps involved to create an External Content Type in SharePoint Designer 2010.