Demo: Excel Services and Secure Store: Authentication using an ODC file


Applies to: SharePoint Server 2010, Excel Services

This demonstration shows the sequence of events that occurs when Excel Services in Microsoft SharePoint Server 2010 refreshes the data in a data-connected Microsoft Excel workbook that is linked to the data source by using an Office Data Connection (ODC) file and Secure Store. The video shows the following events:

  • Excel Services determining which authentication method to use

  • Excel Services passing user information to Secure Store

  • Secure Store verifying credentials and granting Excel Services access to the data source

  • Excel Services displaying the workbook

Screenshot of video

Running time: 3:54

Play video Watch the video (

Download video For an optimal viewing experience, Download the video (

Right-click the link, and then click Save Target As to download a copy. Clicking the link opens a .wmv file in the default video viewer for full-resolution viewing.

See Also


Video demos and training for SharePoint Server 2010
Secure Store for Business Intelligence service applications (SharePoint Server 2010)