Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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).


Create external content types

Running time: 8:25

Play video Watch the "Create external content types" video

Download video 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

  • 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 (http://go.microsoft.com/fwlink/p/?LinkId=187074)

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft