Manage Excel Services trusted data connection libraries

  • Article

Applies To: Office SharePoint Server 2007

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Trusted data connection libraries are Microsoft Office SharePoint Server 2007 document libraries containing data connection files that Excel Calculation Services will trust to use to connect to databases. Excel Calculation Services does not use data connection files that are not stored in a trusted data connection library. However, data connection information can be embedded directly in a workbook that is attempting to make a connection.

You can create different trusted data connection libraries for different purposes or projects, and you can tailor the settings and permissions to the libraries accordingly.

Data connections connect worksheets to data providers. One common use for data connection files stored in data connection libraries is to transfer a worksheet or a set of worksheets from a staging database to a production database. For worksheets that use the same data connection, changing the data connection file is all that is necessary to switch from one database to another; changing the individual worksheets is not necessary.

Initially, there are Excel Services has trusted data connection libraries (with the exception of Report Center sites, which create their own trusted data connection file). To store data connection files, you must create at least one trusted data connection library.

To manage Excel Services trusted data connection libraries, open the Excel Services Trusted Data Connection Libraries page:

  1. Open the administration page for the Shared Services Provider (SSP).

    To open the administration page for the SSP, do the following:

    1. On the top navigation bar, click Application Management.

    2. On the Application Management page, in the Office SharePoint Server Shared Services section, click Create or configure this farm’s shared services.

    3. On the Manage this Farm’s Shared Services page, click the SSP for which you want to open the administration page.

  2. On the Shared Services Administration Home page, in the Excel Services Settings section, click Trusted data connection libraries.

What do you want to do?

  • Add a trusted data connection library

  • Edit a trusted data connection library

  • Delete a trusted data connection library

Add a trusted data connection library

  1. On the Excel Services Trusted Data Connection Libraries page, click Add Trusted Data Connection Library.

  2. On the Excel Services Add Trusted Data Connection Library page, in the Location section, type the address of the trusted data connection library in the Address box.

  3. In the Description box, you can optionally type a description of the purpose for this trusted data connection library.

  4. Click OK.

Edit a trusted data connection library

  • On the Excel Services Trusted Data Connection Libraries page, point to the data connection library that you want to edit, click the arrow that appears, and then click Edit.

Delete a trusted data connection library

  1. On the Excel Services Trusted Data Connection Libraries page, point to the data connection library that you want to delete, click the arrow that appears, and then click Delete.

  2. Click OK in the message box that asks whether you want to proceed with the deletion.