Oracle

In order to connect to Oracle, you will need to provide a custom licensed Oracle JDBC driver. You can specify the driver.jar.path and driver.class.name properties. Okera will try to download the jars on the fly for the first time from the valid driver.jar.path. This path/file, if in s3, should have appropriate IAM credentials for Okera to connect and download the file. For any other https:// path this file should be downloadable.

Once you've uploaded the custom Oracle driver, you can create a connection to your Oracle DB.

A sample properties file for Oracle would be:

driver=oracle:thin
driver.jar.path=<s3://path-to-driver/oracle.jar>
driver.class.name=oracle.jdbc.driver.OracleDriver
host=<host>
port=1521
defaultdb=<default db>
user=<username>
password=<pwd>