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:
|
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.