Connections > Connection properties > Salesforce connection properties
  

Salesforce connection properties

When you set up a Salesforce connection, you must configure the connection properties.
The following table describes the Salesforce connection properties:
Connection property
Description
Connection Name
Name of the Salesforce connection.
Description
Description of the connection.
Type
Type of connection. Select Salesforce.
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.
Important: Informatica recommends you to use OAuth authentication to securely connect to Salesforce. When you use OAuth authentication, use OAuth 2.0. Informatica no longer supports the earlier version of OAuth.
Note: When you use a serverless runtime environment, you cannot use a proxy server to connect to Informatica Intelligent Cloud Services.
The following table lists the connection properties for a standard connection type:
Connection 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. Maximum length is 100 characters. For example: https://login.salesforce.com/services/Soap/u/52.0
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:
Connection 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. Maximum length is 100 characters. For example: https://login.salesforce.com/services/Soap/u/52.0
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.