Purpose

Specifies the case-sensitive password that is required for logging into a backend data store, such as SQL Server or Salesforce. For web service data stores such as Salesforce, a security token may be required by the data store instance.

Valid Values

password | password+securitytoken

where:

password
is the password required for logging into the data store.
password+securitytoken
is the password required for logging into the data store plus a valid security token.

Notes

  • The data store user ID and password may be stored in the Hybrid Data Pipeline data source definition. If that is true and you specify the user ID and password using the DataSourceUserID and DataSourcePassword connection properties, the values specified in these connection properties take precedence.
  • When the data store requires a security token but it has not been stored in the Hybrid Data Pipeline data source definition, you must append the security token to the end of the password specified for DataSourcePassword. In the example secretXaBARTsLZReM4Px47qPLOS, secret is the password and the remainder of the value is the security token.
  • All communication between the driver and the Hybrid Data Pipeline service is encrypted using SSL, including the values specified for DataSourceUserID and DataSourcePassword.

Default

empty string

Data Type

String