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, ...
Get Microsoft® SharePoint® Products and Technologies Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
