Table of Contents

Search

  1. Preface
  2. Connectors and connections
  3. Connection configuration
  4. Connection properties
  5. Swagger file generation for REST V2 connections

Connections

Connections

Salesforce connection properties

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.
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:
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/56.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/56.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.

0 COMMENTS

We’d like to hear from you!