Attribute

DataSourcePassword (DSP)

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 DataSourceUser and DataSourcePassword connection attributes, the values specified in these connection attributes 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 connectivity service is encrypted using SSL, including the values specified for DataSourceUser and DataSourcePassword.

Default

None

GUI Tab

Security tab