Impala ODBC and JDBC Driver

Transform application SQL into Impala SQL

Current Versions ODBC 2.6.8 | JDBC 2.6.3

OEM & Distribution
  • Big Data & Cloud Data Warehouse
  • DB Visualizer
  • Excel
  • Looker
  • Microstrategy
  • Other JDBC
  • Other ODBC
  • PowerBI
  • SAP
  • Sisense
  • Tableau

Magnitude Simba ODBC and JDBC connectors for Impala are the official Cloudera-endorsed ODBC and JDBC interfaces for Impala. Simba connectors efficiently transform any application’s SQL queries into the equivalent form in Impala SQL.

Impala SQL provides a high degree of compatibility with the Hive Query Language, and is a subset of SQL-92. The Simba ODBC and JDBC connectors are fully aware of the capabilities of Impala and can take any standard ODBC, JDBC, and SQL queries and ensure full compatibility with Impala. Queries, including joins, are translated from ANSI SQL to Impala SQL.

Apache Impala is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible file systems. Impala is based on Hive, and developed by Cloudera to deliver fast performance. Simba’s ODBC and JDBC connectors efficiently map ANSI SQL to Impala SQL delivering full SQL application functionality and real-time analytic and reporting capabilities to users.

Features

  • Direct BI connectivity to data without extraction
  • Supports on-premise and cloud deployments
  • Only direct, universal ODBC 3.8 data access solution for Apache Impala
  • Powerful SQL Connector allows users to define schemas on the fly on schema-less data
  • Full compatibility with leading analytic/reporting apps, including Alteryx, Microsoft Excel & Access, SAP Crystal Reports, Tableau and more
  • Maps ANSI SQL to Impala SQL
  • Impala SQL pass-through query option
  • Provides full connector and query metadata

Specifications

Supports on-premise and cloud deployments
Supports 32- and 64-bit applications
Complies with latest ODBC 3.8 specification
Supports Unicode
Support for Impala versions 2.7. through 3.3.
Supports ANSI SQL-92 DDL and DML
Supports multiple platforms, including Windows, RedHat Linux, SUSE Linux, Solaris, AIX, HP-UX and Mac OS X
Supports Impala SQL: SELECT, INSERT [OVERWRITE] SELECT, LOAD, and CREATE/DROP statements
Supports ANSI SQL-92: SELECT/ORDER BY/GROUP BY/HAVING/CROSSJOIN/INNER JOIN/(LEFT|RIGHT|FULL) OUTER JOIN|UNION ALL
Supports data types: TinyInt, SmallInt, Int, BigInt, Float, Double, Boolean, String and TimeStamp

Documentation

User Guides, Release Notes, and FAQs.

Ready to buy? We're here to help!

If you are evaluating our drivers or our Simba SDK, our Sales Engineers would be happy to assist you.