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.
The following steps configure Funnelback to use a
Download the Oracle JDBC drivers (note you must use the Oracle JDBC driver v10.2.0.1.0 or newer)
Create a database collection as per normal
tnsnames.orafile to the data source’s configuration folder
Add the following to the data source configuration:
db.jdbc_urlto be the following format:
<TNSNAME>with the identifier from the