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:
Azure SQL Data Warehouse
This driver is included in all docker-based Immuta deployments.
FreeTDS
This driver is included in all docker-based Immuta deployments.
Hive
Driver Version: 2.5.20.1006
Expected Files:
ClouderaHiveODBC-2.5.20.1006-1.el7.x86_64.rpm
Download:
Notes:
- Select
Linux
for the Operating System andRhel 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:
Notes:
- Select
Linux
for the Operating System andRhel 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:
Now included in Immuta docker images
From Immuta release v2.2.4 this driver is included in Immuta docker images, and does not need to be installed separately.
MemSQL
Driver Version: 5.3.10
Expected Files:
mysql-connector-odbc-5.3.10-1.el7.x86_64.rpm
Download:
Notes:
- Immuta uses the MySQL ODBC driver to connect to MemSQL.
Now included in Immuta docker images
From Immuta release v2.2.4 this driver is included in Immuta docker images, and does not need to be installed separately.
MySQL
Driver Version: 3.0.2
Expected Files:
mariadb-connector-odbc-3.0.2-ga-rhel7-x86_64.tar.gz
Download:
Notes:
- Immuta uses the MariaDB driver in place of the MySQL driver.
Now included in Immuta docker images
From Immuta release v2.2.4 this driver is included in Immuta docker images, and does not need to be installed separately.
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:
PostgreSQL
This driver is included in all docker-based Immuta deployments.
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:
Vertica
Driver Version: 9.1.1-0
Expected Files:
vertica-client-fips-9.1.1-0.x86_64.rpm
Download:
Notes:
- Download the
9.1.x RPM
for Linux.