Configuring Trusted Data Connection Libraries


An Office Data Connection (ODC) is a persistent set of data connection settings that can be stored in an Office Excel 2007 workbook or in SharePoint Server for use in multiple workbooks. ODCs allow users to create their own queries into databases in the organization and to extract data and display it in their Office Excel 2007 workbooks. Although it is possible to query any database table and display the results in a workbook using an ODC, dynamic tables derived from standard databases are not supported by Excel Calculation Services. Excel Calculation Services can only refresh and display data derived from an Analysis Services query.

Because access to organizational data should be protected at all times, it is recommended that those ODCs that are approved for use by users be stored in a Data Connection Library. A Data Connection Library is a list that can store ODC files and can be referenced by users who need to use those ODCs to access data. The advantage of using a centralized library for ODC files is that, if any of the connection information related to the data source changes, then only one file needs to be updated. As a security control over ODC files, you must explicitly trust a Data Connection Library for Excel Calculation Services to be able to refresh the connection.

Configuring a Data Connection Library as Trusted
  1. Open Central Administration from the Start menu.

  2. Click the link for the Shared Services Provider.

  3. Under Excel Services Settings, click Trusted Data Connection Libraries.

  4. Click Add Trusted Data Connection Library.

  5. Type in the URL address of the Data Connection Library you want to add and, optionally, add a description.



Microsoft SharePoint Products and Technologies Administrator's Pocket Consultant
Microsoft SharePoint Products and Technologies Administrators Pocket Consultant
ISBN: 0735623821
EAN: 2147483647
Year: 2004
Pages: 110
Authors: Ben Curry

Similar book on Amazon
Microsoft SharePoint 2010 Administrator's Pocket Consultant
Microsoft SharePoint 2010 Administrator's Pocket Consultant
Microsoftu00ae Office SharePointu00ae Server 2007 Administrator's Companion
Microsoftu00ae Office SharePointu00ae Server 2007 Administrator's Companion
Microsoft Office SharePoint Server 2007 Best Practices
Microsoft Office SharePoint Server 2007 Best Practices
Microsoft SharePoint 2010 Administrator's Companion
Microsoft SharePoint 2010 Administrator's Companion

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net