External System - Connecting to Oracle with TNS hostname

Li He · January 14

Hi all,

Is it possible to connect an Oracle database to Aperture without a hostname?

We would like to connect to a database with the TNS hostname but I’m not sure if this is possible.

Henry Simms · January 14

Yes, this should be possible. The bundled Oracle JDBC driver is from DataDirect, and it can be configured to use TNS name and tnsnames.ora (rather than Service Name or SID) by following these instructions: https://docs.progress.com/bundle/datadirect-oracle-jdbc-60/page/Using-tnsnames.ora-files.html.

Example connection string in Aperture Data Studio:

jdbc:experian:oracle:TNSNamesFile=c:\\oracle\\NETWORK\\ADMIN\\tnsnames.ora;TNSServerName=FITZGERALD.SALE

Best Answer