The How to: Create an External Content Type Based on a SQL Server Table topic explains the basic way to work with Business Connectivity Services to show external data from a SQL Server database.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help