Export (0) Print
Expand All

Manage Excel Services trusted data providers (SharePoint Server 2013)

SharePoint 2013

Published: July 16, 2012

Summary: Add, configure, or delete Excel Services trusted data providers by using the SharePoint Central Administration website.

Applies to:  SharePoint Server 2013 

Important Important:

The steps in this article apply to SharePoint Server 2013 Enterprise.

Trusted data providers are data providers from which Excel 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 Services does not access data that does not come from a trusted data provider.

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

In this article:

Before you begin

Before you begin this operation, review the following information about prerequisites:

  • To perform these procedures, you must be member of the Farm Administrators group or an Administrator for the Excel Services service application that you are configuring.

note Note:

Because SharePoint 2013 runs as websites in Internet Information Services (IIS), administrators and users depend on the accessibility features that browsers provide. SharePoint 2013 supports the accessibility features of supported browsers. For more information, see the following resources:

Add a trusted data provider

Use the following procedure to add a trusted data provider in Excel Services.

To add a trusted data provider

  1. In the Central Administration page, in the Application Management section, click Manage service applications.

  2. On the Manage Service Applications page, click the Excel Services service application that you want to configure.

  3. On the Manage Excel Services page, click Trusted Data Providers.

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

  5. On the Excel Services Application 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). Look in a valid connection string to find the provider ID.

  6. 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 Open Database Connectivity (ODBC).

    • ODBC DSN   Select this option to access data by using Open Database Connectivity with Data Source Name (ODBC DSN).

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

  8. Click OK.

Configure a trusted data provider

Use the following procedure to configure a trusted data provider in Excel Services.

To configure a trusted data provider

  1. In the Central Administration page, in the Application Management section, click Manage service applications.

  2. On the Manage Service Applications page, click the Excel Services service application that you want to configure.

  3. On the Manage Excel Services page, click Trusted Data Providers.

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

Delete a trusted data provider

Use the following procedure to delete a trusted data provider from Excel Services.

To delete a trusted data provider

  1. In the Central Administration page, in the Application Management section, click Manage service applications.

  2. On the Manage Service Applications page, click the Excel Services service application that you want to configure.

  3. On the Manage Excel Services page, click Trusted Data Providers.

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

  5. Click OK in the message box that asks whether you want to continue with the deletion.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft