Phoenix ODBC Driver
Enable users to access, analyze and report on their Phoenix data with the SQL-based tool of their choice
The Simba Phoenix ODBC connector provides direct access to any ODBC application like Excel, PowerBI, Tableau, and more to HBase via Apache Phoenix in real-time with a familiar SQL interface.
The Simba Phoenix ODBC connector enables you to use familiar business intelligence tools to run analysis on big datasets and allows you to use a standard interface with a Phoenix data store, while improving performance by using double-buffering during SELECT operations.
Phoenix does not natively support catalogs. However, the Simba Phoenix ODBC connector implements catalog support by providing a synthetic catalog with the name PHOENIX#. The Simba Phoenix ODBC connector also implements schema support for tables that do not belong to a schema by providing a synthetic schema with the name PHOENIX#.
Features
Direct BI Tool connectivity to data without extraction |
Universal ODBC 3.8 data access solution for Phoenix database |
Supports Data Manipulation Languages (DML) statements such as INSERT, UPDATE, and DELETE |
Supports two-way mapping between Phoenix types and many common SQL data types |
Use SQL to access data via Apache Phoenix from analytic applications such as Microsoft Excel, Power BI, SAP Cloud for Analytics, QlikView, Tableau and more |
Unicode enabled 32- and 64-bit ODBC 3.8 compliant connectors for Windows, Mac OS X, and Linux |
Supports Kerberos authentication and SSL |
Support connecting to Phoenix running as a Azure HDInsight service |
Specifications
Supports 32- and 64-bit applications |
Complies with latest ODBC 3.8 specification |
Supports Unicode |
Supports Windows, Linux and Mac OS X platforms |
Support for hint syntax |
Use Windows Trust Store to verify connection |
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.