Enabling relational database sources
If the database type is present in the Database drop
down list, please use it directly. If the database is not listed, put the appropriate JDBC drivers
into a shared directory on each Analytic Server
host. By default, this directory is /usr/share/jdbc.
To change the shared directory, follow these steps.
- In Cloudera Manager, navigate to the Configuration tab of the Analytic Server service.
- Specify the path of the shared directory of JDBC drivers in jdbc.drivers.location.
- Click Save Changes.
- Select Stop from the Actions dropdown to stop the Analytic Server service.
- Select Refresh Analytic Server Binaries from the Actions dropdown.
- Select Start from the Actions dropdown to start the Analytic Server service.
Database | Supported versions | JDBC driver jars | Vendor |
---|---|---|---|
Amazon Redshift | 8.0.2 or later | RedshiftJDBC41-1.1.6.1006.jar or later | Amazon |
Apache Impala | JDBC 4 with 2.5.5 or later | ImpalaJDBC4.jar, commons-codec-*.jar, commons-logging-*.jar, httpclient-*.jar, httpcore-*.jar, log4j-*.jar, libthrift-*.jar, libfb303-*.jar, slf4j-api-*.jar, ql.jar, zookeeper-*.jar, TCLIServiceClient.jar | Apache |
DashDB | Bluemix Service | db2jcc.jar | IBM |
Db2 for Linux, UNIX, and Windows | 11.1, 10.5, 10.1, 9.7 | db2jcc.jar | IBM |
Db2 z/OS | 11, 10 | db2jcc.jar, db2_license_cisuz.jar | IBM |
Greenplum | 5.x | postgresql.jar | Greenplum |
Hive | 2.1, 1.1 | hive-jdbc-*-standalone.jar | Apache |
MySQL | 5.6, 5.7 | mysql-connector-java-commercial-5.1.25-bin.jar | MySQL |
Netezza | 7, 6.x | nzjdbc.jar | IBM |
Oracle | 12c, 11g R2 (11.2) | ojdbc6.jar, orai18n.jar | Oracle |
SQL Server | 2014, 2012, 2008 R2 | sqljdbc4.jar | Microsoft |
Teradata | 15, 15.1 | tdgssconfig.jar, terajdbc4.jar | Teradata |
Notes
- If you created a Redshift data source prior to installing Analytic Server, you
need perform the following steps in order to use the Redshift data source.
- In the Analytic Server console, open the Redshift data source.
- Select the Redshift database data source.
- Enter the Redshift server address.
- Enter the database name and username. The password should automatically populate.
- Select the database table.