Custom JDBC Data Sources
Starting from 2.1.0, Okera provides the ability to specify custom JDBC drivers. Users can specify the
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.
This does not guarantee that Okera would support arbitrary JDBC drivers. The data type mapping can be undefined due to Okera not certifying those JDBC drivers. For example, Okera has certified that Oracle JDBC driver used as a custom driver is fully supported and documented for limitations and data type mapping.
Example To add a custom driver (Oracle JDBC driver in this example)
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> fetchSize=10000