The Simba Apache HBase ODBC driver provides the On Ramp to Big Data for HBase users: It delivers and provides broad compatibility and ensures full functionality for users analyzing and reporting on Big Data.

Simba HBase ODBC Driver Connectivity diagram
The HBase ODBC driver accepts an application’s SQL queries which generates execution plans and transforms them into calls to HBase’s REST API. Light up features in BI clients by connecting to your HBase data in a powerful, effective way to access, analyze and report. Apache HBase is an open-source, distributed, versioned, column-oriented store which hosts very large tables, with billions of rows by millions of columns, atop clusters of commodity hardware. Apache HBase also provides you random, realtime read/write access to your Big Data. Simba delivers full functionality for users analyzing and reporting on Big Data with the latest ODBC 3.8 data standard, including important functionality such as Unicode and 32- and 64-bit support for high-performance computing environments on all platforms.

Product Highlights

  • Only direct, universal ODBC 3.8 data access solution for Apache HBase
  • Direct BI connectivity to data without extraction
  • Accepts application SQL queries and generates execution plans
  • Supports dynamic schema generation via intelligent data sampling

Features

  • Direct BI connectivity to data without extraction
  • Full compatibility with leading analytic/reporting apps, including Alteryx, Microsoft Excel & Access, SAP Crystal Reports, Tableau and more
  • Maps ANSI SQL-92 to HBase REST API calls
  • Provides full driver and query metadata
  • Supports dynamic schema generation via intelligent data sampling
  • Adds aggregation and join capabilities for queries

Specifications

  • Supports 32- and 64-bit applications
  • Complies with latest ODBC 3.8 specification
  • Supports Unicode
  • Supports Windows, Redhat, SUSE, Debian and Ubuntu.
  • Apache Knox Gateway support
  • Supports ANSI SQL-92: SELECT, JOIN, WHERE, HAVING, GROUP BY, ORDER BY, TOP, UNION [ALL] and most SQL-92 scalar and aggregate functions
  • Supported data types: SQL_VARCHAR, SQL_WVARCHAR, SQL_DECIMAL, SQL_SMALLINT, SQL_INTEGER, SQL_REAL, SQL_FLOAT, SQL_DOUBLE, SQL_BIT, SQL_TINYINT, SQL_BIGINT, SQL_VARBINARY, SQL_TYPE_DATE, SQL_TYPE_TIME, SQL_TYPE_TIMESTAMP

Get HBase ODBC Driver with SQL Connector

SQL has come to Apache HBase. Enable your users to access, analyze and report on their Hadoop data with the SQL-based tool of their choice.

Download Now 30 Days Free Trial

Contact us

Questions? Ready to Buy?
Let's talk.

We'll get back to you within the next business day.

Evaluation and Sales Support
If you are evaluating our drivers or our SimbaEngine X SDK, our Sales Engineers would be happy to assist you. If you are ready to buy or you require licensing information, please complete the form provided, or contact us by email or phone:
+1-604-633-0008 x2 or connectivity@magnitude.com

Customer Technical Support

If you are a customer, please use our Magnitude Customer Support Portal