Enabling relational database sources
Analytic Server can
use relational database sources if you supply the JDBC drivers in 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 the Ambari Services tab, navigate to the Configs tab of the Analytic Server service.
- Open the Advanced analytics.cfg section.
- Specify the path of the shared directory of JDBC drivers in jdbc.drivers.location.
- Click Save.
- Stop the Analytic Server service.
- Click Refresh.
- 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 |
| BigSQL | 4.1.0.0 or later | db2jcc.jar | IBM |
| 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 | postgresql.jar | Greenplum |
| Hive | 1.1, 1.2 | hive-jdbc-*.jar | Apache |
| MySQL | 5.1, 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.
- BigSQL is the IBM SQL interface for the Apache Hadoop environment. BigSQL is not a relational
database, but Analytic Server
support access to it via JDBC (the JDBC jar file is the same as what is used for DB2).
BigSQL is a BigInsights value-add service. As such its version is identical to the BigInsights version. A common usage for BigSQL with Analytic Server is accessing BigSQL Hadoop/HBase tables via an HCatalog data source.