Skip to content

ODBC Drivers

Audience: Application Admins

Content Summary: The Immuta Web Service and Query Engine use ODBC drivers to communicate with back end storage technologies. Immuta deployments only include a few ODBC drivers that Immuta is able to distribute. All other drivers that are not redistributable must be obtained and deployed by a System Administrator before Data Owners can use the corresponding data source types in Immuta.

This page lists the ODBC drivers supported by Immuta. You can install ODBC drivers from the App Settings page.

Supported Drivers

Amazon Athena

This driver is included with Immuta.

Azure Synapse Analytics

This driver is included with Immuta.

Databricks

This driver is included with Immuta.

DB2

Driver Version: 11.1

Expected Files:

  • ibm_data_server_driver_for_odbc_cli_linuxx64_v11.1.tar.gz

Download:

Notes:

  • The required file is called IBM Data Server Driver for ODBC and CLI (Linux AMD64 and Intel EM64T) Version 11.1.

Elastic

This driver is included with Immuta.

Google Big Query

Driver Version: 2.4.0.1002

Expected Files:

  • SimbaODBCDriverforGoogleBigQuery64_2.4.0.1002.tar.gz

Download:

Greenplum

This driver is included with Immuta.

Hive

Driver Version:

  • Cloudera: 2.6.9.1009-1
  • EMR: 1.2.2.1018

Expected Files:

  • Cloudera: ClouderaHiveODBC-2.6.9.1009-1.el7.x86_64.rpm
  • EMR: Hive_ODBC_1.2.2.1018.zip

Download:

Notes:

  • Select Linux for the Operating System and Rhel 7 - 64bit for the OS version.
  • When downloading the EMR RPM, extract the zip file and upload the 64-bit RPM in the /Linux/EL7/ directory.

Impala

Driver Version: 2.6.8.1008-1

Expected Files:

  • ClouderaImpalaODBC-2.6.8.1008-1.el7.x86_64.rpm

Download:

Notes:

  • Select Linux for the Operating System and Rhel 7 - 64bit for the OS version.

Jethro

This driver is included with Immuta.

MariaDB

This driver is included with Immuta.

Microsoft SQL Server

This driver is included with Immuta.

Mongo DB

Driver Version: 1.4.2

Downloads:

Expected Files:

  • mongodb-connector-odbc-1.4.2-rhel-7.0-64.tar.gz

Notes:

  • A RHEL 7 64-bit gzipped tar file of binaries is required. In addition, must have BI connector running to connect to MongoDB via ODBC.

MySQL

Driver Version: 8.0.17

Expected Files:

  • mysql-connector-odbc-8.0.17-1.el7.x86_64.rpm

Downloads:

Notes:

  • A RHEL/CentOS 7 x86 64-bit compatible RPM is required.

Netezza

Driver Version: 7.2.1

Expected Files:

  • npsclient.7.2.1.tar.gz

Download:

Notes:

  • You must obtain this ODBC Driver from IBM.
  • You need to have the IBM Netezza SQL Extensions toolkit installed on your Netezza server.

Oracle

Driver Version: 19.13.0.0.0

Expected Files:

  • oracle-instantclient19.13-basic-19.13.0.0.0-1.x86_64.rpm
  • oracle-instantclient19.13-odbc-19.13.0.0.0-1.x86_64.rpm

Download:

PostgreSQL

This driver is included with Immuta.

Presto

Driver Version: 1.2.14.1014-1.el6

Notes:

You may obtain this ODBC driver from Starburst Data with a Starburst contract. Alternatively, you may purchase this ODBC driver from Magnitude.

Redshift

This driver is included with Immuta.

SAP Hana

The SAP Hana ODBC driver is available as part of your SAP Hana installation. Please upload a tar.gz file (i.e. odbc.tar.gz that contains the ODBC driver for Linux x86 64).

SingleStore

Driver Version: 5.3.10

Expected Files:

  • mysql-connector-odbc-5.3.10-1.el7.x86_64.rpm

Download:

Notes:

  • A RHEL/CentOS 7 x86 64-bit compatible RPM is required.

Snowflake

This driver is included with Immuta.

Driver Version: 2.22.4

Sybase ASE

This driver is included with Immuta.

Teradata

Driver Version: 17.10.00.10

Download:

Trino

Driver Version: 1.2.14

Notes:

You may obtain this ODBC driver from Starburst Data with a Starburst contract. Alternatively, you may purchase this ODBC driver from Magnitude.

Vertica

Driver Version: 9.2.1-0

Expected Files:

  • vertica-client-9.2.1-0.x86_64.rpm

Download:

Yellowbrick

This driver is included with Immuta.