Custom JDBC Data Sources
Starting from 2.1.0, Okera provides the ability to specify custom JDBC drivers. Users 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.
Note
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