Salesforce API for DataStage connection

To access your data with the Salesforce API for DataStage connection, create a connection asset for it. This connection works with the Salesforce API for DataStage connector, which has exclusive features for DataStage.

Salesforce.com is a cloud-based software company which provides customer relationship management (CRM). The Salesforce API for DataStage connection supports the standard SQL query language to select, insert, update, and delete data from Salesforce.com products and other supported products that use the Salesforce API.

Supported versions

The latest supported version is API 61.0

Create a connection with Salesforce API for DataStage

To create the connection asset, you need these connection details:

  • URL: a SOAP endpoint URL (https://<SOAP-endpoint-hostname>/services/Soap/u/<SOAP-version-number>)
  • Audience URL: This connection detail appears only when using the OAuth 2.0 JWT Bearer Flow authentication type. The audience identifies the authorization server as an intended audience. The authorization server must verify that it is the intended audience of the authorization token.

Select Proxy server to access the Salesforce.com data source through a proxy server. Depending on its setup, a proxy server can provide load balancing, increased security, and privacy. The proxy server settings are independent of the authentication credentials and the personal or shared credentials selection.

  • Proxy server hostname or IP address: The proxy URL. For example, https://proxy.example.com.
  • Proxy server port: The port number to connect to the proxy server. For example, 8080 or 8443.
  • The Proxy server username and Proxy server password fields are optional.

Credentials

  • Username and password
  • Authentication method: Select the authentication type to be used. The following authentication methods are supported:
    • OAuth 2.0 JWT Bearer Flow
    • OAuth 2.0 Username-Password Flow
    • Username Password

When using the OAuth 2.0 JWT Bearer Flow or the OAuth 2.0 Username-Password Flow authentication types, the following OAuth authentication properties are required:

  • For OAuth 2.0 JWT Bearer Flow:
    • Consumer key
    • Server certificate key
    • Token expiry time
  • For OAuth 2.0 Username-Password Flow:
    • Consumer key
    • Consumer secret key

Certificates

Enable Mutual Authentication: When this option is enabled, you will use a client certificate to authenticate itself to Salesforce , in addition to validating the Salesforce server certificate. When enabled the following fields are required:

  • Client certificate
  • Client private key

Learn more