Create external content types using SharePoint Designer 2010

  • Article

 

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.

Resource Description

Manage external content types (SharePoint Server 2010)

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