Phoenix ODBC Driver

Enable users to access, analyze and report on their Phoenix data with the SQL-based tool of their choice

Current Versions 1.0.7

OEM & Distribution
  • Big Data & Cloud Data Warehouse
  • Excel
  • Microstrategy
  • Other ODBC
  • PowerBI
  • SAP
  • Sisense
  • Tableau

The Magnitude 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

Documentation

User Guides, Release Notes, and FAQs.

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.