/
/
ODBC
Read, write, and update HBase through ODBC
New
CData Drivers now work with AI Coding tools
The HBase ODBC Driver is a powerful tool that allows you to connect with live data from HBase, directly from any applications that support ODBC connectivity. Access HBase data like you would a database - read, write, and update HBase data through a standard ODBC Driver interface.
HBase
See what you can do with HBase ODBC Driver
Server
SQL Server Linked-Server
Connect to HBase from SQL Server as Linked-Server. You can query HBase from familiar Transact-SQL without need of setting up another application.
Data Integration & ETL
Integrate HBase to your system through popular ETL / EAI tools such as Informatica PowerCenter. Standard SQL and Stored Procedures enable fast delivery of your integration projects.
HBase ODBC Connectivity Features
- Accepts application SQL queries and generates execution plans
- Connects to HBase REST Server 0.0.3, available in HBase version 0.98 and above
- Maps ANSI SQL-92 to HBase REST API calls
- Includes Apache Knox Gateway support
- Connect to live Apache HBase data, for real-time data access with the Apache HBase JDBC Driver
- Full support for data aggregation and complex JOINs in SQL queries
- Secure connectivity through modern cryptography, including TLS 1.2, SHA-256, ECC, etc.
- Seamless integration with leading BI, reporting, and ETL tools and with custom applications via the HBase Connector.
Target Service, API
The driver connects to Apache HBase via REST API or Thrift. Provides SQL interface to HBase tables.
Schema, Data Model
Models HBase tables with column families as relational tables. Handles sparse data model.
Key Objects
Tables, Column Families, and Rows. Access to all HBase data with appropriate permissions.
Operations
CRUD operations on HBase data. Scan and filter operations. Limited JOIN support.
Authentication
Kerberos authentication for secure clusters. Simple authentication for unsecured clusters.
AI-assisted development with CData CLI
Build HBase integrations faster with AI that understands your schema
Schema-aware AI
CData CLI gives AI coding tools access to your HBase schema. No more guessing table names or column types—AI sees the same metadata in your ODBC Drivers.
Your AI Knows SQL
How to find table names, column names, and how to generate SQL syntax are things that AI knows well from millions of training data. No need for customization, no hallucinations. Your AI acts like a domain specialist to HBase.
More Accurate, More Token-Efficient
With CData CLI's queryable schema detection and highly efficient queries with filters, aggregation, joins with correct pushdown, your AI will achieve more accuracy with less token usage.
FAQs
Frequently asked HBase ODBC driver questions
Learn more about HBase ODBC drivers for data and analytics integration
Download the HBase ODBC Driver today!
Get the latest HBase ODBC Drivers for Windows, Linux, and macOS. Install in minutes and connect your HBase data to Power BI, Tableau, and more.
Download HBase ODBC Driver
Please select from the following download options:
Windows