Create external content types using SharePoint Designer 2010
Applies to: SharePoint Server 2010
Topic Last Modified: 2012-02-17
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 http://www.Sharepoint-Videos.com ( http://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).
Running time: 8:25
For an optimal viewing experience, download the "Create external content types" video.
Right-click the link, and then click Save Target As to download a copy. Clicking the link will open a .wmv file in the default video viewer for full-resolution viewing.
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
Asif is very active in the Chicago SharePoint community. He is the co-founder and an active leader of the Chicago SharePoint User Group.
Procedures illustrate how to complete typical tasks, such as setting permissions on external content types, delete external content types, and so on.
Find more videos from Asif Rehmani.
SharePoint Products Tech Center (http://go.microsoft.com/fwlink/p/?LinkID=177939)
Find details about related technologies, downloads, and additional resources.