Skip to content

Oracle Data Source Connections

To connect to Oracle, you must provide an Oracle JDBC driver and specify the driver.jar.path and properties. Okera tries to download the JAR files on the fly for the first time from the valid driver.jar.path. If in S3, this path/file should have appropriate IAM credentials for Okera to connect and download the file. For any other URI, this file should be downloadable.

Once you've uploaded the custom Oracle driver, you can create a connection to your Oracle database. Here is a programmatic example of a connection to an Oracle database.

  'host'='<Oracle host to connect to>',
  'port'='<Oracle port to connect to, typically 1521',
  ''='<default db>',