Configuring Trusted Data Providers


Office Data Connections can connect to virtually any data source for which a data driver is configured on the machine making the query. In the case of ODC files stored in Data Connection Libraries, these drivers must be installed and configured on the Excel Calculation Server. In addition, Excel Calculation Services must be configured to explicitly trust the driver by entering it into the list of Trusted Data Providers. Excel Calculation Services is configured to trust a set of data providers that includes SQL Server 2000, SQL Server 2005, Oracle 9.2, and IBM DB2. If your organization uses any database systems not on this list and you want to access them through Excel Calculation Services then you need to configure the drivers as trusted. Once the drivers have been installed on the server and trusted, they should be available through any ODC that has authenticated access to the data. To configure a Trusted Data Provider, first install the driver for the data source and then take the following steps.

Adding a Trusted Data Provider
  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 Providers.

  4. Click Add Trusted Data Provider.

  5. In the Provider ID section, as shown in Figure 11-8, type the identifier of the driver you want to add as a Trusted Data Provider.

  6. Select one of the following provider types:

    • OLE DB: Use for most Microsoft and many third-party drivers that have been written to use the current OLE DB interface.

    • ODBC: Use for drivers that confirm to the Open Database Connectivity standard used by most database manufacturers.

    • ODBC DSN: Use to identify a reference to a Data Source Name on the local server that contains connection string information for an ODBC driver.

  7. Click OK.

image from book
Figure 11-8: Adding a Trusted Data Provider.



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