Using TNS with Oracle database data sources

This article describes how to configure Funnelback to connect to distributed Oracle databases configured with TNS names.

Oracle distributed databases

Oracle databases have support for distributed databases using their proprietary TNS names configuration.

Funnelback can be configured to use the tnsnames.ora file when crawling.

Configuration steps

The following steps configure Funnelback to use a tnsnames.ora file:

  1. Download the Oracle JDBC drivers (note you must use the Oracle JDBC driver v10. or newer)

  2. Create a database collection as per normal

  3. Copy the tnsnames.ora file to the data source’s configuration folder

  4. Add the following to the data source configuration:

  5. Update the db.jdbc_url to be the following format: jdbc:oracle:thin:@<TNSNAME> (replace <TNSNAME> with the identifier from the tnsnames.ora file).