Connect to Oracle DB through a vpn

Isaac Emmanuel

Hello everyone

I am trying to connect to an Oracle DB through a VPN, my computer is already connected to the VPN and when I test the connection between my computer and the DB host with ping it works, but when it try in Dataiku it fails:

Failed to reach database: Failed to connect, caused by: SQLException: IO Error: The Network Adapter could not establish the connection, caused by: NetException: The Network Adapter could not establish the connection, caused by: SocketTimeoutException: connect timed out

Is there a way that Dataiku can connect to that VPN? so I can connect to the database

Thank you!

Catalina

Hi @IsaacChavez
,

The error indicates that DSS host cannot connect to the Oracle database server.

Testing the connection between your computer and the DB host would be relevant only in the case if DSS would run locally on your computer. If this is not the case, you need to connect to DSS host and then check if DSS host can connect to the Oracle database server by running a telnet command like below:

telnet <oracle-db-host> <port>

Since this issue is network related you should follow up with your network admins for further assistance investigating this.