Salesforce Connector Guide > Salesforce Connections > Salesforce Connection Properties
  

Salesforce Connection Properties

When you set up a Salesforce connection, you can select Standard or OAuth connection types.
The following table lists the 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.
Use one of the following service URLs based on the Salesforce version:
  • - https://login.salesforce.com/services/Soap/u/31.0
  • - https://login.salesforce.com/services/Soap/u/33.0
  • - https://login.salesforce.com/services/Soap/u/34.0
  • - https://login.salesforce.com/services/Soap/u/35.0
  • - https://login.salesforce.com/services/Soap/u/36.0
  • - https://login.salesforce.com/services/Soap/u/37.0
  • - https://login.salesforce.com/services/Soap/u/38.0
  • - https://login.salesforce.com/services/Soap/u/39.0
Default is https://login.salesforce.com/services/Soap/u/31.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
Service Endpoint
URL of the Salesforce service endpoint. Maximum length is 100 characters. For example: https://login.salesforce.com/services/Soap/u/31.0
OAuth Access Token
OAuth token generated using the OAuth utility.
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 Data 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 Data 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.