Installing the Oracle JDBC Driver

Before using the Oracle JDBC Table origin, you must install an Oracle JDBC driver. Install the driver as an external library for the JDBC stage library.

If you install a driver provided by Oracle, the origin automatically detects the JDBC driver class name from the configured JDBC connection string. If you install a third-party driver, you must specify the driver class name on the Advanced tab of the origin.

By default, Transformer bundles a JDBC driver into the launched Spark application so that the driver is available on each node in the cluster. If you prefer to manually install an appropriate JDBC driver on each Spark node, you can configure the stage to skip bundling the driver on the Advanced tab of the stage properties.