Apache 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
Overview
Features
Specifications
Documentation

Provide standard SQL-92 interface to enable your BI tools using HBase.

Apache HBase ODBC Driver with SQL Connector HBaseHbase_smThe Simba Apache HBase ODBC driver delivers and provides broad compatibility and ensures full functionality for users analyzing and reporting on Big Data. 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.52 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.52 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

Product Features

  • Direct BI connectivity to data without extraction
  • Complies with latest ODBC 3.52 specification
  • 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

Product Specifications

  • Supports 32- and 64-bit applications
  • Complies with latest ODBC 3.52 specification
  • Supports Unicode
  • Supports Windows, Redhat, and SUSE.
  • 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

Product FAQ

FREE Trial

A password will be emailed to you.

Contact Sales

+1.604.633.0008 ext. 2
solutions@simba.com

Webinar

How to Build an ODBC Driver in Just 5 Days!

Play Webinar