Connections

Back Next

Salesforce connection properties

When you set up a Salesforce connection, configure the connection properties.

The following table describes the Salesforce 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.
Type	The Salesforce connection type.
Runtime Environment	The name of the runtime environment where you want to run the tasks. Specify a Secure Agent, Hosted Agent, or serverless runtime environment.
Salesforce Connection Type	The type of Salesforce connection. You can select Standard or OAuth connection. Informatica recommends you to use OAuth authentication to securely connect to Salesforce. When you use OAuth authentication, use OAuth 2.0.

The following table lists the connection properties for a standard connection type:

Property	Description
User Name	User name for the Salesforce account.
Password	Password for the Salesforce account.
Security Token	Security token generated from the Salesforce application.
Service URL	URL of the Salesforce service. For example: https://login.salesforce.com/services/Soap/u/57.0 When you edit the service URL for an existing standard connection, you must re-enter the password and security token. Maximum length is 100 characters.
Bypass proxy server settings defined for the Secure Agent	Bypass the proxy server settings defined in the Secure Agent Manager for the Secure Agent. When you bypass the proxy server settings, you use a direct connection to Salesforce.

The following table lists the properties for an OAuth connection type:

Property	Description
OAuth Consumer Key	The consumer key that you get from Salesforce, which is required to generate a valid refresh token.
OAuth Consumer Secret	The consumer secret that you get from Salesforce, which is required to generate a valid refresh token.
OAuth Refresh Token	The refresh token generated in Salesforce using the consumer key and consumer secret.
Service URL	URL of the Salesforce service endpoint. For example: https://login.salesforce.com/services/Soap/u/57.0 When you edit the service URL for an existing OAuth connection, you must re-enter the consumer key, consumer secret, and refresh token. Maximum length is 100 characters.

You can configure the following Salesforce-specific properties under the Secure Agent configuration properties:

Property	Type	Description
SalesForceConnectionTimeout	DTM	Number of seconds that the Salesforce web service requests to wait before it times out.
AutoAlterColumnType	Custom	For replication tasks, set the AutoAlterColumnType custom configuration property so the database target column adjusts when the data type, precision, or scale of a Salesforce source field changes. Set this property for the Secure Agent that runs the replication task. Enter the following values: For Type, select Tomcat. For Sub-type, select INFO. For Name, enter AutoAlterColumnType. For Value, enter yes to turn on this property.