Partager via


Set-ecsexternaldata : opération Stsadm (Office SharePoint Server)

Mise à jour : 2008-02-14

Operation name: Set-ecsexternaldata

Lets an administrator configure an external data connection to Excel Calculation Services.

This operation is equivalent to the External Data user interface setting that is located on the Excel Services Settings page of the Shared Services Administration Web site.

For additional information about external data and Microsoft Excel Calculation Server, see Planifier des connexions de données externes pour Excel Services

Syntax

stsadm -o set-ecsexternaldata

**   –ssp <SSP name>**

[-ConnectionLifetime <time in seconds>]

[-UnattendedServiceAccountName <account name>]

-UnattendedServiceAccountPassword <account password>]

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.

connectionlifetime

One of the following values:

  • -1: Never recycle

  • 0 to 2073600 (24 days)

No

Maximum time, in seconds, for a connection to remain open. Older connections are closed and reopened (that is, "recycled") for the next query.

The default value is 1800 seconds.

unattendedserviceaccountname

A valid string value

No

Name for a default Windows account that Excel Calculation Services uses for connecting to data sources that require username and password strings for authentication.

The maximum character length is 4096.

unattendedserviceaccountpassword

A valid string value

No

Password for a default Windows account that Excel Calculation Services uses for connecting to data sources that require user name and password strings for authentication.

The maximum character length is 4096.