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

Azure SQL Data Warehouse

Google BigQuery

Driver Version: 2.1.19.1024

Expected Files:

• SimbaODBCDriverforGoogleBigQuery64_2.1.19.1024.tar.gz

Download:

• https://storage.googleapis.com/simba-bq-release/odbc/SimbaODBCDriverforGoogleBigQuery64_2.1.19.1024.tar.gz

Hive

Driver Version:

• Cloudera: 2.5.25.1020
• EMR: 1.2.2.1018

Expected Files:

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

Download:

• Hive for Cloudera
• Hive for EMR

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.5.43.1032

Expected Files:

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

Download:

• Impala

Notes:

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

MariaDB

MemSQL

Microsoft SQL Server

MySQL

Netezza

Driver Version: 7.2.0.5-P1

Expected Files:

• npsclient.7.2.0.5-P1.tar.gz

Download:

• Netezza

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.3.0.0.0-1

Expected Files:

• oracle-instantclient12.1-basic-19.3.0.0.0-1.x86_64.rpm
• oracle-instantclient12.1-odbc-19.3.0.0.0-1.x86_64.rpm

Download:

• Oracle

PostgreSQL

Presto

Driver Version: 1.1.16.1026

Expected Files:

• PrestoODBC-64bit-1.1.16.1026.rpm

Notes:

• You must obtain this ODBC driver from Starburst Data.

Redshift

Driver Version: 1.3.7.1000-1

Expected Files:

• AmazonRedshiftODBC-64bit-1.3.7.1000-1.x86_64.rpm

Download:

• https://s3.amazonaws.com/redshift-downloads/drivers/AmazonRedshiftODBC-64bit-1.3.7.1000-1.x86_64.rpm

Snowflake

Teradata

Driver Version: 16.20.00.65

Expected Files:

• tdodbc1620__linux_indep.16.20.00.68-1.tar.gz

Download:

• Teradata

Vertica

Driver Version: 9.2.x

Expected Files:

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

Download:

• Vertica