SAP Hana JDBC driver installation for Matillion ETL

Overview

This article details how to install the SAP HANA JDBC driver for Matillion ETL.

The driver name we are looking for is: ngdbc.jar (from the Linux 64 tar download).

For reference, the SAP article Connect Using the SAP HANA JDBC Driver gives detailed information on installing and connecting the SAP HANA JDBC driver.

Method

1. The SAP customer must download the SAP HANA express edition package. You can download the SAP HANA client software package from the SAP Store. Download the driver for Linux 64.

2. Once the package is downloaded, follow the instructions from the SAP HANA Client on UNIX, macOS, or Linux section of the SAP HANA Client Installation and Update Guide. Perform just the ./hdbsetup step—there is no need to set up environment variables.

Please Note

You can install the driver on the Matillion ETL server or any other Linux server of your choosing. The ONLY reason for installing the driver is to expose the ngdbc.jar file.

3. Once the driver is installed on the Matillion ETL (or other) server, find the the ngdbc.jar file in the install directory.

4. From your client laptop or PC, SFTP (get) the ngdbc.jar file from the server. You will then upload this file to Matillion ETL via the Matillion ETL GUI in step 6 below.

5. Follow the directions in Adding A 3rd Party JDBC Driver to add an "SAP HANA" section to the jdbc-providers.properties file. The section for HANA should look like this:

{
"name" : "SAPHana",
"driver" : "com.sap.db.jdbc.Driver",
"url" : "jdbc:sap:// : /?databaseName= ",
"fetchSize" : "500",
"limit" : "top-n",
"allowUpload" : true
}

6. Follow the first few steps in Manage Database Drivers to upload the SAP HANA driver back to Matillion ETL.

7. Create a new orchestration job and use the Database Query component to access SAP HANA.