Add a JDBC Driver

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

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

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 Composer, you first need to download and install a JDBC driver.


If the JDBC driver for the Composer connector is not configured, the connector server will not start and the connector cannot be enabled within Composer. See Manage Connectors and Connector Servers.

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 Composer microservices:

  1. Download the required driver from the vendor’s site to the corresponding Composer 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 Composer administrator has read-level access rights to the JDBC driver (JAR) file.

    Connector Link to JDBC Driver License Type Supported Version
    Amazon Redshift Commercial
    Dremio LGPL 4.1
    MemSQL LGPL 8.0.13
    MySQL LGPL 8.0.13
    Oracle Commercial
    SAP Hana Commercial 2.0
    SAP IQ Commercial 16
    Snowflake LGPL  
    Teradata Commercial
    Vertica 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
    Microsoft SQL Server
    SAP Hana
    SAP IQ
  3. In the edc-<connector_name>.properties file, add the following property:


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

  4. For MemSQL and MySQL connectors, add the following property to the property files:

  5. Save your changes to the properties file.

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

    • For CentOS 7 or 8 and Ubuntu 16 or 18: systemctl restart zoomdata-edc-<connector_name>
  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.