Getting Started with BCS
1. Create an External Content Type Based on a SQL Server Table http://msdn.microsoft.com/en-us/library/ee557243.aspx 2. Create External Lists in SharePoint http://msdn.microsoft.com/en-us/library/ee558778.aspx 3. After that you will couple of issues such as 3.1 Access denied by business data connectivity. Correlation id. Follow steps from here http://blogs.msdn.com/b/ericwhite/archive/2010/06/11/access-denied-by-business-data-connectivity.aspx 3.2 BCS External List Error: Unable to display this webpart. Solution is easy, Start -> All Programs -> Microsoft SharePoint 2010 Products -> SharePoint 2010 Management Shell Then adjust your throttling Default and Maximum parameters, here is an example : PS Y:\> $proxy=Get-SPServiceApplicationProxy | where {$_ -match "Business data Connectivity Service"} PS Y:\> Get-SP...