Manage Excel Services trusted data providers

  • 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 providers are data providers from which Excel Calculation Services accesses data. A data provider is a database type combined with a protocol for accessing data (for example, SQL Server combined with ODBC).

  • Excel Calculation Services does not access data that does not come from a trusted data provider.

  • Excel Calculation Services contains entries for common data providers. Add additional safe data providers as needed.

To manage Excel Services trusted data providers, open the Excel Services Trusted Data Providers 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 2007 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 whose administration page you want to open.

  2. On the Shared Services Provider Home page, in the Excel Services Settings section, click Trusted data providers.

What do you want to do?

  • Add a trusted data provider

  • Edit a trusted data provider

  • Delete a trusted data provider

Add a trusted data provider

  1. On the Excel Services Trusted Data Providers page, click Add Trusted Data Provider.

  2. On the Excel Services Add Trusted Data Provider page, in the Provider section, type the provider ID of the trusted data provider in the Provider ID box (for example, type SQL Server).

  3. Under Provider Type, select one of the following:

    • OLE DB   Select this option to access data by using Object Linking and Embedding (OLE).

    • ODBC   Select this option to access data by using Object Linking and Embedding (ODBC).

    • ODBC DSN   Select this option to access data by using Object Linking and Embedding with Data Source Name (ODBC DSN).

  4. In the Description box, you can optionally type a description of the purpose for this trusted data provider.

  5. Click OK.

Edit a trusted data provider

  • On the Excel Services Trusted Data Providers page, click Edit on the menu of the data provider that you want to edit.

Delete a trusted data provider

  1. On the Excel Services Trusted Data Providers page, click Delete on the menu of the data provider that you want to delete.

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