Issue with JDBC Connection: Port 20005 Redirecting to Port 443

IsaacChavez

Hello Dataiku Community,

I am experiencing an issue while trying to connect Dataiku to a Progress database using the JDBC driver. Despite specifying port 20005 in the JDBC URL, the connection attempt seems to redirect to port 443, resulting in a timeout error. Here are the details:

JDBC URL

jdbc:datadirect:sforce://<IP_ADDRESS>:20005;User=<USERNAME>;Password=<PASSWORD>

Error Message:

Failed to reach database: Failed to connect, caused by:

SQLException: Unable to connect, caused by: SQLException:

[DataDirect][SForce JDBC Driver][SForce]Socket

Error: Connect to <IP_ADDRESS>:443 [/<IP_ADDRESS>]

failed: connect timed out Caused by: com.ddtek.jdbc.sforce.externals.org.apache.http.conn.ConnectTimeoutException:

Connect to <IP_ADDRESS>:443 [/<IP_ADDRESS>] failed: connect timed out Caused by: java.net.SocketTimeoutException:

connect timed out, caused by: ae: Socket Error: Connect to <IP_ADDRESS>:443 [/<IP_ADDRESS>] failed:

connect timed out Caused by: com.ddtek.jdbc.sforce.externals.org.apache.http.conn.ConnectTimeoutException:

Connect to <IP_ADDRESS>:443 [/<IP_ADDRESS>] failed: connect timed out Caused by: java.net.SocketTimeoutException:

connect timed out, caused by: ConnectTimeoutException: Connect to <IP_ADDRESS>:443 [/<IP_ADDRESS>] failed: connect timed out, caused by:

SocketTimeoutException: connect timed out

What I Have Tried:

1. Verified that port 20005 is open and accessible using netcat.
2. Confirmed the server is listening on port 20005.
3. Checked firewall and network settings to ensure there are no blocks on port 20005.
4. Ensured the JDBC driver is correctly uploaded to Dataiku.

Despite these efforts, the connection attempts still seem to default to port 443. Has anyone encountered a similar issue or can provide guidance on why the specified port is being overridden? Any help or suggestions would be greatly appreciated!

Thank you!

Turribeach

There is no mention of port in the Progress documentation showing how to connect to Salesforce using their driver. Why do you think you need to use port 20005? Where is this port coming from?

https://docs.progress.com/bundle/datadirect-salesforce-jdbc-60/page/Connection-URL.html