Create external content types using SharePoint Designer 2010
Applies to: SharePoint Server 2010
**Summary:**This video by Asif Rehmani illustrates how to use SharePoint Designer to create connections to a database table and display the data in a SharePoint site.
Asif Rehmani, SharePoint MVP, MCT, is president of SharePoint-Videos.com. For more videos from Asif, see https://www.Sharepoint-Videos.com ( https://go.microsoft.com/fwlink/p/?LinkId=187074).
The External Content Types section within Microsoft SharePoint Designer 2010 enables you to define connections to line-of-business data that developers, designers, or administrators of a site can access. After the connection is defined, business analysts can use that connection to create what’s called External Lists which show the content of what the connection is attached to (for example a table in a database).
Video: Create external content types
About the author
Asif is an independent SharePoint Trainer and Consultant who is a SharePoint Server MVP and a Microsoft Certified Trainer (MCT). He is the co-author of the Wrox publication “Professional SharePoint Designer 2007.“ Over the years, Asif has provided SharePoint consulting and training to many large clients including: Department of Defense, NASA, Hersheys, Toshiba, State Farm, Federal Home Loan Bank, US Army and many more. Here are some conferences at which Asif has been a speaker:
Microsoft’s SharePoint Conference
Microsoft’s TechEd Conference
SharePoint Connections
Advisor Live
Asif is very active in the Chicago SharePoint community. He is the co-founder and an active leader of the Chicago SharePoint User Group.
Related resources
| Resource | Description |
|---|---|
Procedures illustrate how to complete typical tasks, such as setting permissions on external content types, delete external content types, and so on. |
|
SharePoint-Videos.com (https://go.microsoft.com/fwlink/p/?LinkId=187074) |
Find more videos from Asif Rehmani. |
SharePoint Products Tech Center (https://go.microsoft.com/fwlink/p/?LinkID=177939) |
Find details about related technologies, downloads, and additional resources. |
See Also
Concepts
Video demos and training for SharePoint Server 2010
Other Resources
Resource Center: Operations and Manageability for SharePoint Server 2010