Ajouter un fournisseur de données approuvé
Mise à jour : 2009-03-26
In this article:
About trusted data providers
Add a trusted data provider
About trusted data providers
Trusted data providers are external databases that Services de calcul Excel is explicitly configured to trust when processing data connections in workbooks. Services de calcul Excel attempts to process a data connection only if the connection is to a trusted data provider.
You can control access to external data by explicitly defining the data providers that are trusted and recording them in the list of trusted data providers. The list of trusted data providers designates specific external data providers to which workbooks opened in Services de calcul Excel are permitted to connect.
Before instantiating a data provider to enable a workbook to connect to an external data source, Services de calcul Excel checks the connection information to determine whether the provider appears on the list of trusted data providers. If the provider is on the list, a connection is attempted; otherwise, the connection request is ignored.
Add a trusted data provider
Use the following procedure to add a trusted data provider.
Add a trusted data provider
From Administrative Tools, open the SharePoint Central Administration Web application.
On the Central Administration home page, click Application Management.
On the Application Management page, in the Office SharePoint Server 2007 Shared Services section, click Create or Configure this Farm’s Shared Services.
On the Manage this Farm’s Shared Services page, click SharedServices1 (Default). This is the Shared Services Provider (SSP) that you will configure.
On the Shared Services home page, in the Excel Services Settings section, click Trusted data providers.
On the Excel Services Trusted Data Providers page, click Add Trusted Data Provider.
In the Provider ID section, type the identifier of the external database you want to add as a trusted data provider in Services Excel dans Microsoft Office SharePoint Server 2007. Click OK.
For information about how to perform this procedure using the Stsadm command-line tool, see Add-ecssafedataprovider : opération Stsadm (Office SharePoint Server).
Download this book
This topic is included in the following downloadable books for easier reading and printing:
See the full list of available books at Downloadable books for Office SharePoint Server 2007.