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.