Share via


Add-ecssafedataprovider: Stsadm operation (Office SharePoint Server)

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.

 

Topic Last Modified: 2015-03-09

Operation name: Add-ecssafedataprovider

Description

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.

Syntax

stsadm -o add-ecssafedataprovider

**   -ssp <SSP name>**

**   -type {Oledb | Odbc | OdbcDsn}**

**\[-description \<descriptive text\>\]**

Parameters

Parameter

Value

Required?

Description

ssp

A valid SSP name, such as "SharedServices1"

Yes

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

id

A valid string value

Yes

Unique identifier for the safe data provider.

Maximum length is 255 characters.

type

One of the following values:

  • Oledb

  • Odbc

  • OdbcDsn

Yes

Specifies one of the supported data types.

description

A valid string value

No

Optional description for a data provider.

Maximum length is 255 characters.

Remarks

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

Concepts

Add a trusted data provider
Remove-ecssafedataprovider