Zoomdata Version

Adding a JDBC Driver

Overview

Starting in Zoomdata v2.5.3, a change has been made to how JDBC drivers for certain connectors are made available. Specifically, for the following list of Zoomdata connectors, the JDBC drivers will no longer be included into the installation package:

This approach allows you the flexibility to add a specific JDBC driver that meets your support policies or operational needs. As a result, in order to connect to and visualize data from Zoomdata v2.5.3 to these particular sources, you first must install the JDBC driver. This should be done immediately after installing or upgrading to Zoomdata v2.5.3.

Caveats

If the JDBC driver for the Zoomdata connector is not configured, that particular connector server will not start up. And the corresponding connector cannot be enabled by the Zoomdata Administrator.

Refer to the article Managing Connectors in Zoomdata for additional information.

In the case where Zoomdata was upgraded to v2.5.3, this also means that charts and dashboards created for that data source will no longer be available until the JDBC driver is installed and the connector enabled.

Install a JDBC Driver

If the JDBC driver for the Zoomdata connector is not configured, that particular connector server will not start up. And the corresponding connector cannot be enabled by the Zoomdata Administrator.

Refer to the article Managing Connectors in Zoomdata for additional information.

Install JDBC driver

In order to use any of the data sources listed above, perform the following steps to install the needed 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 Table 1 for resources for vendor’s JDBC drivers.
Table 1
Connector Link to JDBC Driver License Type Supported Version
Aurora http://central.maven.org/maven2/org/mariadb/jdbc/mariadb-java-client/1.3.2/mariadb-java-client-1.3.2.jar LGPL 1.3.2
Microsoft SQL Server   Commercial 4.0.0
MemSQL http://central.maven.org/maven2/org/mariadb/jdbc/mariadb-java-client/1.3.2/mariadb-java-client-1.3.2.jar LGPL 1.3.2
MySQL http://central.maven.org/maven2/org/mariadb/jdbc/mariadb-java-client/1.3.2/mariadb-java-client-1.3.2.jar LGPL 1.3.2
Redshift   Commercial 1.2.1.1001
Oracle   Commercial 12.1.0.2
Teradata   Commercial 15.00.00.30

Keep in mind that the Zoomdata Administrator must have read-level access rights to the JDBC driver (*.jar) file.

  1. Use the following command to access and open the configuration file:

vi /etc/zoomdata/edc-connector_name.properties

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

  • Replace connector_name with the name of the data source driver you are configuring:
  • Table 2
    Connector Connector Property File Name
    Aurora edc-aurora.properties
    Microsoft SQL Server edc-mssql.properties
    MemSQL edc-memsql.properties
    MySQL edc-mysql.properties
    Redshift edc-redshift.properties
    Oracle edc-oracle.properties
    Teradata edc-teradata.properties

     

    For guidance on editing property files in Zoomdata, refer to the article Managing Configurations in Zoomdata.

    1. In the edc-connector_name.properties file, add the following property:

    datasource.driver-config.jar-path=path_to_your_JDBC_driver_file

    1. Save your changes to the properties file.
    2. Restart the corresponding connector by running the following command:

      • For CentOS 7 and Ubuntu v16:

        systemctl restart zoomdata-edc-connector_name

      • For CentOS 6 and Ubuntu v14:

        service zoomdata-edc-connector_name restart

    Once this is done, the Zoomdata Administrator needs to log in as the Supervisor, access the Connectors page and make sure that connector is enabled so that it appears in the Data Sources page.

    Refer to the article Managing Connectors in Zoomdata for guidance on enabling Zoomdata Connectors.

    After the JDBC driver has been configured and the connector enabled, users that have access privileges to connect Zoomdata to their data source will be able to do so from the Data Sources page.