Subscribe:      
 

Accessing External Data Using SharePoint Designer 2010 and Business Connectivity Services

Written By: Additional Articles -- 1/13/2011 -- join -- contribute -- (6) comments -- printer friendly version

Rating: Rate --

Categories: Business Connectivity Services, Configurations, Features, SharePoint 2010, SharePoint Designer 2010

Problem

Have you ever wanted to provide the ability to display and edit SQL data right from SharePoint? SharePoint 2010 has improved its Business Connectivity Service just for this purpose.

Solution

A video from Microsoft called Business Connectivity Services - Authentication from the browser offers a great overview of getting started with this technology. It walks through setting up a data connection, setting authentication, and creating a SharePoint list that connects to the SQL data, while keeping most of the typical SharePoint list functions (edit, sort, group, filter, etc). The demo touches and handling the 'double hop' authentication issue using a new SharePoint feature called the Secure Store Service. You can do all this using SharePoint 2010 and SharePoint Designer 2010.

The video is about 30 minutes, but well worth the time investment. Let's take a look...

Business Connectivity Services - Authentication from the browser

 

Next Steps




Learn more about SharePoint



Sponsor Information




Copyright (c) 2010-2017 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | contribute | feedback | about
Some names and products listed are the registered trademarks of their respective owners.


MSSharePointTips.com | MSSQLTips.com