Prepare Database Drivers for Write-Back Server

Owned by Ricardo Pires
Last updated: Mar 01, 2024 by Bruno Gomes
2 min read

Summary

If you want to have Write-Back writing datasets to your database you will have to provide a database driver. Write-Back works using JDBC drivers thus, it is necessary to have a jar that includes the driver.

Write-Back runs on Java 17 so select the driver accordingly. Besides that, you should check your database version to find the correct driver.

How to Obtain the Driver

You can use links \ instructions below to download the drivers.

 MySQL
  1. Go to Link: https://dev.mysql.com/downloads/connector/j/
  2. Check the MySQL version you are using if it is not the latest version click on Archives
    1. Select the correct version 
  3. On the drop-down Select Operating System select platform independent. 
  4. Download the zip file and unzip anywhere
  5. Locate the jar file inside the folder, typically called mysql-connector...
 PostgreSQL
  1. Go to Link: https://jdbc.postgresql.org/download
  2. Write-Back runs on Java 8 so you should choose the highest JDBC version available.
  3. Check the PostgreSQL version you are using and click the corresponding link, with JDBC 4.2 or 4.
  4. Download the jar
 Oracle
  1. Go to Link: https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html
  2. Click on the suitable version for your instance.
  3. On the new page, download the ojdbc8.jar
 SQL Server
  1. Go to Link: https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15
  2. Click to download the latest zip
    1. Download the latest zip
  3. Extract the zip and inside you will find mssql-jdbc-X.X.X.jre8.jar and this is the JDBC driver that you will need for Write-Back
 Snowflake
  1. Go to Link: https://docs.snowflake.com/en/user-guide/jdbc-download.html#downloading-the-driver
  2. Click the link to the maven repository.
  3. Click the suitable version of snowflake.
  4. Look for a file with the following naming scheme:
    1. snowflake-jdbc-X.X.X.jar
    2. Example with version 3.9.0:snowflake-jdbc-3.9.0.jar
 Redshift
  1. Go to Link: https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-download-driver.html
  2. Click the second link
    1. Example: Redshift download

 Vertica
  1. Go to Link: https://www.vertica.com/download/vertica/client-drivers/
  2. Download the file under (All Operating Systems)
    1. Example: Vertica download

 SAP Hana
  1. Go to Link: https://repo1.maven.org/maven2/com/sap/cloud/db/jdbc/ngdbc/
  2. Choose the appropriate version.
  3. Download jar file (ngdbc-x.x.xx.jar)
    1. Example for version 2.8.11
 Exasol
  1. Go to Link: https://maven.exasol.com/artifactory/exasol-releases/com/exasol/exasol-jdbc/
  2. Click on the version of your Exasol instance.
  3. Download exasol-jdbc-{VERSION}.jar
 BigQuery
  1. Go to Link: https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers
  2. Scroll down to "JDBC Driver" section
  3. Click on "JDBC 4.2-compatible" link
  4. Make sure you are aware of limitations when dealing with BigQuery. You can find all know limitations here: Setup & Configure with Write-Back Manager