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 outlines the data source handlers configuration and lists drivers supported by Immuta. You must enable each data source handler in the web service configuration before users can create an Immuta data source that uses the driver. In most Immuta deployments, you can use the Configuration Builder to install ODBC drivers.

Data Source Handlers Configuration

Use this configuration item to enable and disable data source types in Immuta:

• handlers (array[string]): array of handlers ('Amazon Athena', 'Amazon S3', 'Apache HDFS', 'Azure Blob Storage', 'Azure SQL Data Warehouse', 'Custom', 'Elastic', 'FTP', 'Greenplum', 'Hive', 'Impala', 'Microsoft SQL Server', 'Netezza', 'MariaDB', 'MEMSQL', 'MySQL', 'Oracle', 'Persisted', 'PostgreSQL', 'Presto', 'Redshift', 'Teradata', 'Vertica')

Note: A data source will not function properly until the corresponding ODBC driver has been installed.

Supported Drivers

Amazon Athena

Driver Version: 1.0.3.1004-1

Expected Files:

• simbaathena-1.0.3.1004-1.x86_64.rpm

Download:

• https://docs.aws.amazon.com/athena/latest/ug/connect-with-odbc.html

Azure SQL Data Warehouse

FreeTDS

Hive

Driver Version: 2.5.20.1006

Expected Files:

• ClouderaHiveODBC-2.5.20.1006-1.el7.x86_64.rpm

Download:

• https://www.cloudera.com/downloads/connectors/hive/odbc/2-5-20.html

Notes:

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

Impala

Driver Version: 2.5.39.1020

Expected Files:

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

Download:

• https://www.cloudera.com/downloads/connectors/impala/odbc/2-5-39.html

Notes:

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

MariaDB

Driver Version: 3.0.2

Expected Files:

• mariadb-connector-odbc-3.0.2-ga-rhel7-x86_64.tar.gz

Download:

• https://downloads.mariadb.com/Connectors/odbc/

MemSQL

Driver Version: 5.3.10

Expected Files:

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

Download:

• https://dev.mysql.com/downloads/connector/odbc/

Notes:

• Immuta uses the MySQL ODBC driver to connect to MemSQL.

MySQL

Driver Version: 3.0.2

Expected Files:

• mariadb-connector-odbc-3.0.2-ga-rhel7-x86_64.tar.gz

Download:

• https://downloads.mariadb.com/Connectors/odbc/

Notes:

• Immuta uses the MariaDB driver in place of the MySQL driver.

Netezza

Driver Version: 7.2.0.5-P1

Expected Files:

• npsclient.7.2.0.5-P1.tar.gz

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: 12.1.0.2.0-1

Expected Files:

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

Download:

• http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

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://docs.aws.amazon.com/redshift/latest/mgmt/install-odbc-driver-linux.html
• https://docs.aws.amazon.com/redshift/latest/mgmt/odbc-previous-versions.html

Teradata

Driver Version: 16.10

Expected Files:

• tdicu1610-16.10.00.00-1.noarch.rpm
• tdodbc1610-16.10.00.03-1.noarch.rpm

Download:

• http://downloads.teradata.com/download/connectivity/odbc-driver/linux

Vertica

Driver Version: 9.1.1-0

Expected Files:

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

Download:

• https://my.vertica.com/download/vertica/client-drivers/

Notes:

• Download the 9.1.x RPM for Linux.