BCS Team Channel: Creating an External Content Type in SharePoint Designer 2010

The BCS Team Channel has a new video in which we show you how in just a few minutes you can create an External Content Type using SharePoint Designer. In this video we use the database connector so be sure to subscribe to the channel to be the first to view the follow up videos which demonstrate how to work with other connectors such as Web Services and .Net Assemblies.

If you are new to the channel you can watch other videos such as:

• Introduction to Business Connectivity Services (BCS) and External Lists
• BCS - Synchronizing an External List into Outlook
• BCS - External Data In SharePoint Workspace 2010
• BCS - Associations and Web Parts (Part 1)
• BCS - Associations and Web Parts (Part 2)

- Lionel Robinson, Program Manager

Comments

• Anonymous
  February 16, 2010
  Hi LionelExcellent video. I like and very help full.I tried conect my SQLserver but when I created new external contect type I recieve meseggeAccess denied by business Data Connectivity.I don't what more I need to do for this work.thanks for your help.Roberto Londonoroberto.londono@riverpointfarms.com
• Anonymous
  February 16, 2010
  Hi Roberto, Do you get this message when you want to save the external content type or when you are trying to view the list. In either case from the message you receive it looks like the user you are using to complete the task does not have the proper permissions in the BDC service. For more information on this check out Rob Silver's permissions post: http://blogs.msdn.com/bcs/archive/2009/11/24/permissions-in-business-connectivity-services.aspx Hope this helps.