Adding JDBC drivers

You can configure support for JDBC drivers beyond those supported by default.

A default installation of the Provisioning Service includes drivers to support the following relational database management systems:

Oracle 11g
Oracle Business Intelligence Server is also supported.
MySQL

To support additional third party databases:

Copy the JDBC driver file to $DOMAIN_HOME/config/jdbc.
Add the driver class name to the value of the jdbc-driver-classnames configuration property.
The value of this property is a colon-separated list of third-part JDBC driver classpaths.

For example, the default value of the jdbc-driver-classnames property is:

com.mysql.jdbc.Driver:oracle.bi.jdbc.AnaJdbcDriver:oracle.jdbc.OracleDriver

If you want to add support for Hadoop Hive clusters, copy the Hadoop Hive JDBC driver to $DOMAIN_HOME/config/jdbc and update the value of the jdbc-driver-classnames configuration parameter to:

com.mysql.jdbc.Driver:oracle.bi.jdbc.AnaJdbcDriver:oracle.jdbc.OracleDriver:org.apache.hadoop.hive.jdbc.HiveDriver