Infogix Assure has the ability to add custom JDBC drivers to connect to databases. The instructions below cover how to connect to HBase via Phoenix.
Downloading the Phoenix driver
- Download the Phoenix package from Phoenix Downloads
- Unpack the download
- Copy the driver. For example, in the Phoenix 5.0.0 download, the driver is
Adding the driver within Assure
Follow the instructions within Adding JDBC drivers in Assure.
Setting up the Assure layout
The standard Assure database setup is performed. If the driver is installed within Assure server, you will be able to use the generate fields feature and test the layout via the Assure UI. If the driver is installed within Assure client, then the fields will need to be created manually and a control will need to be run via Assure client with local capture enabled.
The syntax for the Phoenix connection string for Phoenix is:
The Phoenix driver class is:
If you are uncertain what your driver class is, you can check the driver class of a jdbc driver.