Oracle

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).