Oracle

Option Info

Type

Relational

Driver

Driver Link

Version Included

None

Hop Dependencies

None

Documentation

Documentation Link

JDBC Url

jdbc:oracle:thin:@hostname:port Number:databaseName

Driver folder

<Hop Installation>/lib/jdbc
Starting with Oracle Database 11g Release 1 (11.1), data type Date will be mapped to Timestamp by default. Set JDBC property oracle.jdbc.mapDateToTimestamp=false to avoid data type Date being converted to data type Timestamp.
Check Options in the Relational Database Connection docs for more information.

Creating connections

There are 4 ways to create a connection to an Oracle database in Apache Hop:

  • If you have a SID, use this (old) format: jdbc:oracle:thin:@hostname:PORT:SID.
    Put the SID with : prefix in the database name

  • If you have a service name, use this (newer) format: jdbc:oracle:thin:@//HOSTNAME:PORT/SERVICENAME.
    Put the service name with / prefix in the database name

  • If you want to use TNS format: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host) (PORT=port)) (CONNECT_DATA=(SERVICE_NAME=service_name)).
    Put the TNS description in the database name and leave the hostname and port empty.

  • If you want to use a specific TNS_ADMIN, you providing the path for tnsnames.ora through TNS_ADMIN property: jdbc:oracle:thin:@mydb.mydomain?TNS_ADMIN=C:\\Temp\\tns
    Use manual connection url (not the options tab because Apache Hop does not pass options in the url for Oracle).