In order to connect to Oracle, you will need to provide a custom licensed Oracle JDBC driver.
You can specify the
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>