The Simba Hive ODBC Driver with SQL Connector is the most advanced ODBC driver available for direct SQL and HiveQL access to Apache™ Hadoop™ / Hive™ distributions. It’s used by market leaders such as Alteryx®, DataStax®, MapR® and others to enable Business Intelligence (BI), analytics and reporting on Hadoop / Hive-based data.
The Simba Hive ODBC Driver with SQL Connector uniquely leverages Simba’s deep ODBC and SQL expertise to efficiently map SQL to HiveQL, enabling standard SQL-92 access directly to Apache Hadoop distributions. It delivers full SQL application functionality and real-time analytic and reporting capabilities to users. The driver is backed by Simba’s reputation as the world’s leading independent expert in ODBC development.
Built upon the SimbaEngine SDK driver development framework—the industry’s leading ODBC toolkit for high-performance ODBC driver development—the Simba Hive ODBC Driver with SQL Connector complies with the latest ODBC 3.52 data standard and adds important functionality such as Unicode and 32- and 64-bit support for high-performance computing environments on all platforms.
The Simba Hive ODBC Driver with SQL Connector is the only readily available, direct, universal ODBC data access solution for Apache Hadoop / Hive that works. No other Big Data ODBC driver is as advanced or BI ready.
Initially co-developed by Microsoft and Simba Technologies in 1992, ODBC is the flagship SQL Application Programming Interface (API). It is the standard API used by popular applications like Alteryx, Microsoft Excel®, MicroStrategy®, SAP Crystal Reports® and Tableau®.
The Simba Hive ODBC Driver with SQL Connector adds standard SQL-92 to Hadoop so any traditional BI or analytics tool can easily connect and quickly add value without any extra development effort.
The Simba Hive ODBC Driver efficiently transforms an application’s SQL query into the equivalent form in HiveQL. The Hive Query Language is effectively a subset of SQL-92. If an application is Hive-aware, the Simba Hive ODBC Driver is configurable to pass the query through.
The Simba Hive ODBC Driver with SQL Connector interrogates Hive to obtain schema information to present to a SQL-based application. Queries, including joins, are translated from SQL to HiveQL.
The Simba Hive ODBC Driver with SQL Connector is the market’s premier solution for direct, SQL BI connectivity to Hadoop. It delivers extreme performance, provides broad compatibility and ensures full functionality for users analyzing and reporting on Big Data.
Contact us for more information or an evaluation.