Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Add-ecssafedataprovider: Stsadm operation (Office SharePoint Server)

PerformancePoint Server 2007

Updated: February 14, 2008

Applies To: Office SharePoint Server 2007

Updated: 2008-02-14

Operation name: Add-ecssafedataprovider

Lets an administrator add a supported provider type to the safe provider list.

This operation is equivalent to the Provider user interface setting that is located on the Excel Services Add Trusted Data Provider page of the SharePoint Shared Services Administration Web site.


stsadm -o add-ecssafedataprovider

   -ssp <SSP name>

   -type {Oledb | Odbc | OdbcDsn}

   [-description <descriptive text>]







A valid SSP name, such as "SharedServices1"


The name of the SSP that provides the resources for the Excel Calculation Services you want to configure.


A valid string value


Unique identifier for the safe data provider.

Maximum length is 255 characters.


One of the following values:

  • Oledb

  • Odbc

  • OdbcDsn


Specifies one of the supported data types.


A valid string value


Optional description for a data provider.

Maximum length is 255 characters.


Excel Calculation Services works with any provider that meets all of the following conditions:

  • It is one of the supported provider types.

  • It is installed on the same machine that is running SharePoint Products and Technologies.

  • The administrator has added it to the trusted data provider list.

Excel Calculation Services only retrieves external data from providers that have been included in the list of safe providers on the server. In order to determine if a provider is in the trusted data provider list, the Excel Calculation Services parses the connection string of the external data object in order to match the appropriate fields with the trusted data provider list.

A safe provider list allows Excel Calculation Services to only execute queries using drivers and data sources that are deemed safe by the administrator. It allows a set of drivers to be tested and guarantees that they work with Excel Calculation Services, but also allows customers to add additional providers needed in their organization.

See Also

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