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>) - Username and password
- if using OAuth authentication, appropriate keys are required
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,
8080or8443. - The Proxy server username and Proxy server password fields are optional.
Choose the method for creating a connection based on where you are in the platform
- In a project
- Click Assets > New asset > Connect to a data source. See Adding a connection to a project.
- In the Platform assets catalog
- Click New connection. See Adding platform connections.
- In a deployment space
- Click Import assets > Data access > Connection. See Adding data assets to a deployment space.
Next step: Add data assets from the connection
Where you can use this connection
You can use the Salesforce API for DataStage connection in the following workspaces and tools:
Projects
- DataStage (DataStage service). See Connecting to a data source in DataStage.
Catalogs
- Platform assets catalog
Learn more
Parent topic: Supported connections