Zoomdata Version

Adding a JDBC Driver

For certain data sources, the JDBC drivers needed are no longer included in to the installation package of Zoomdata. You need to provide your own JDBC driver for the following data sources:

The following Zoomdata connectors are distributed with a JDBC driver, but you can download and install newer versions using the information in this topic: Snowflake and Vertica.

This approach allows you the flexibility to add a specific JDBC driver that meets your licensing, support policies or operational needs. As a result, in order to connect to and visualize data from Zoomdata, you first need to download and install a JDBC driver.

Caveats

If the JDBC driver for the Zoomdata connector is not configured, the connector server will not start and the connector cannot be enabled within Zoomdata. See Managing Connectors.

In you are upgrading from a version prior to Zoomdata 2.5.3, this also means that any dashboards created using associated data sources will no longer be available until the JDBC driver is installed and the connector is enabled.

Install a JDBC Driver

To use any of the connectors listed above, perform the following steps to install the required JDBC driver after successful installation of Zoomdata services:

  1. Download the required driver from the vendor’s site to the corresponding Zoomdata instance. Place the required driver in the following folder: /usr/local/share/java/zoomdata.

    If this folder does not exist, you need to create it in the location mentioned above.
    See the following table for resources for vendor’s JDBC drivers. Make sure that the Zoomdata administrator has read-level access rights to the JDBC driver (JAR) file.

    Connector Link to JDBC Driver License Type Supported Version
    Amazon Redshift* http://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html#download-jdbc-driver Commercial 1.2.1.1001
    MemSQL https://dev.mysql.com/downloads/connector/j/ LGPL 8.0.13
    MySQL https://dev.mysql.com/downloads/connector/j/ LGPL 8.0.13
    Oracle https://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html Commercial 12.1.0.2
    SAP Hana https://www.sap.com/developer/trials-downloads/additional-downloads/sap-hana-client-software-packages-12950.html Commercial 2.0
    SAP IQ http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect Commercial 16
    Snowflake https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc/ LGPL  
    Teradata http://downloads.teradata.com/download/connectivity/jdbc-driver Commercial 15.00.00.30
    Vertica https://www.vertica.com/client-drivers/ Commercial All
  2. Use the following command to access and open the property file:

    vi /etc/zoomdata/edc-<connector_name>.properties

    If you are not logged in as a root user, enter sudo vi /etc/zoomdata/edc-<connector_name>.properties to create the desired file. If the properties file does not exist, this command creates it.

    Replace <connector_name> with the name of the connector you are configuring:

    Connector Connector Property File Name
    Amazon Redshift* edc-redshift.properties
    MemSQL edc-memsql.properties
    Microsoft SQL Server edc-mssql.properties
    MySQL edc-mysql.properties
    Oracle edc-oracle.properties
    SAP Hana edc-saphana.properties
    SAP IQ edc-sapiq.properties
    Snowflake edc-snowflake.properties
    Teradata edc-teradata.propertie
    Vertica edc-vertica.properties
  3. In the edc-<connector_name>.properties file, add the following property:

    datasource.driver-config.jar-path=<JDBC_driver_filepath>

    If you need to add multiple paths, use a comma-separated list:

    datasource.driver-config.jar-path=<JDBC_driver_filepath1>,<JDBC_driver_filepath2>
    Amazon Redshift connectors require more than one JAR file for the JDBC Driver. Be sure to place these JAR files together in the same location.
  4. For MemSQL and MySQL connectors, add the following property to the property files:

    datasource.driver-config.class-name=com.mysql.cj.jdbc.Driver
  5. Save your changes to the properties file.

  6. Restart the corresponding connector by running the appropriate command:

    • For CentOS 7 and Ubuntu 16: systemctl restart zoomdata-edc-<connector_name>
    • For CentOS 6 and Ubuntu 14: service zoomdata-edc-<connector_name> restart
  7. Log in as the Supervisor, access the Connectors page, and verify that the connector is enabled so it appears in the data source list. After the JDBC driver has been configured and the connector has been enabled, users with the correct access privileges can use the connector to connect to the data store in a data source configuration.

Was this topic helpful?