Create a Salesforce Data 360 connection to load data to Salesforce Data 360.
Connect to Salesforce Data 360
Let's configure the Salesforce Data 360 connection properties to connect to Salesforce Data 360.
Before you begin
Before you get started, make sure to complete certain prerequisites.
•Create an external client app for the Data 360 Ingestion API in Salesforce Data 360 with the required scopes. You need at a minimum the Manage user data via APIs (api) and Manage Data 360 Ingestion API data (cdp_ingest_api) scopes for Salesforce Data 360.
•Get the consumer key and consumer secret from the external client app to generate the access token.
•Create an Ingestion API data stream to load data to the target.
For more information about Ingestion API data stream, see Ingestion API.
Connection details
The following table describes the basic connection properties:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Description
Description of the connection. Maximum length is 4000 characters.
Use Secret Vault
This property appears only if secrets manager is set up for your organization. However, this property doesn't apply to a Salesforce Data 360 connection.
Runtime Environment
The name of the runtime environment where you want to run tasks.
Select a Secure Agent, Hosted Agent, or elastic runtime environment.
You cannot run an ingestion and replication task on a Hosted Agent or in a serverless runtime environment.
Authentication Type
The authentication method to connect to Salesforce Data 360.
Default is OAuth 2.0 client credentials.
Access Token URL
The endpoint where OAuth 2.0 requests are sent to obtain an access token to connect to the Salesforce Data 360 instance.
Specify the URL in the following format:
https://<Salesforce Data 360 organization ID>.salesforce.com/services/oauth2/token
Client ID
Client ID of your application to connect to Salesforce Data 360.
Client Secret
The client secret associated with the client ID.
Access Token
The access token value.
Click Generate Access Token to populate the access token value.
Advanced settings
The following table describes the advanced connection properties:
Property
Description
Retry Count
The total number of retries to get the response from the Salesforce Data 360 endpoint based on the HTTP status codes.
Enter a positive integer.
Default is 3.
Retry Interval
The wait time in milliseconds before the Salesforce Data 360 connection makes another attempt to receive a response.
Enter a positive integer.
Default is 5000 milliseconds.
Additional Properties
Additional properties that you can configure in the Salesforce Data 360 connection, such as specifying a custom data space, defining properties for connections and data streams.
You can specify multiple properties, separated by an ampersand and colon (&:), in the following format:
<key1>=<value>&:<key2>=<value>&:<key3>=<value>
For example, you can specify a custom data space when you choose query as your source object:
You can use the additional properties field in the advanced settings to customize and set any additional properties in a Salesforce Data 360 connection.
Specify a custom data space.
•customQueryDataSpace. A custom data space that you can use when you choose query as your source object.
For example, customQueryDataSpace=My_Dataspace
If you do not specify a data space, the default data space of your organization is considered.
Configure status codes and timeout properties.
•okhttp.retryStatusCodes. A list of HTTP status codes that indicate transient errors for which a request should be retried.
Default codes are 429,500,502,503,504.
•okhttp.connectTimeout. The maximum wait time in seconds that the Salesforce Data 360 connection waits for a response from the server.
Default is 30 seconds.
•okhttp.readTimeout. The maximum wait time in seconds when an attempt is made to read a file from the server.
Default is 30 seconds.
•okhttp.writeTimeout. The maximum wait time in seconds when an attempt is made to write a file to the server.
Default is 30 seconds.
Configure data stream ingestion properties.
•dataStreamIngestReadyInitialPollIntervalSeconds. The initial poll interval duration in seconds that the Salesforce Data 360 Connector waits before making the first attempt to fetch the refresh date and time for the data stream.
Default is 120 seconds.
•dataStreamIngestReadyMaxWaitTimeSeconds. The maximum wait time in seconds that the Salesforce Data 360 Connector will wait for the data stream to become ready to accept incoming data during the initial data load into the data lake object.
Default is 1200 seconds.
Configure data stream active time properties.
•dataStreamActiveInitialPollIntervalSeconds.The initial poll interval duration in seconds that the Connector waits before making the first attempt to fetch the data stream status.
Default is 1 second.
•dataStreamActiveMaxWaitTimeSeconds.The maximum wait time in seconds for the data stream status to transition to Active after successful creation.
Default is 60 seconds.
For example, okhttp.retryStatusCodes=429,500,502,503,504&:okhttp.connectTimeout=30&:dataStreamActiveMaxWaitTimeSeconds=60&:dataStreamActiveInitialPollIntervalSeconds=1