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.

  1. In Cloudera Manager, navigate to the Configuration tab of the Analytic Server service.
  2. Specify the path of the shared directory of JDBC drivers in jdbc.drivers.location.
  3. Click Save Changes.
  4. Select Stop from the Actions dropdown to stop the Analytic Server service.
  5. Select Refresh Analytic Server Binaries from the Actions dropdown.
  6. Select Start from the Actions dropdown to start the Analytic Server service.
Table 1. Supported databases
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.
    1. In the Analytic Server console, open the Redshift data source.
    2. Select the Redshift database data source.
    3. Enter the Redshift server address.
    4. Enter the database name and username. The password should automatically populate.
    5. Select the database table.