External System - Connecting to Oracle with TNS hostname
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.
Tagged:
0
Best Answer
-
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
1
