ODI 12c Salesforce Dataserver Connection Test Timed Out Using a Standalone Agent (Doc ID 2313634.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

Symptoms

In an Oracle Data Integrator (ODI) 12.1.3 environment, testing a Salesforce Data Server connection using a Standalone Collocated Agent results in the below error message.

However, testing the connection through the Local (No Agent) is successful.

Environment configuration:

• Salesforce Data Server is created under Oracle Technology as below:
  Driver: com.ddtek.jdbc.sforce.SForceDriver
  Driver JDBC URL: jdbc:datadirect:sforce://login.salesforce.com;ConfigOptions=(AuditColumns=auditOnly;MapSystemColumnNames=0;UppercaseIdentifiers=false;deletedRowsBehavior=include;CustomSuffix=Include);;CreateDB=forceNew;StmtCallLimit=0;WSTimeout=0;WSFetchSize=0;WSRetryCount=3;LoginTimeout=0;
• The driver jar file (sforce.jar) is set in the userlib folder, also in the variable ODI_POST_CLASSPATH =/path_to_file/sforce.jar from the instance.cmd file.
• ODI Studio is using the browser proxy, ODI -> Preferences are set as below:
  Web Browsers Tab -> Internet Explorer
  Proxy Settings Tab -> Use System Default Proxy Settings

Changes

Cause