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
The copied driver will be utilized within the next section.
Adding the driver within Assure
The jdbc connection can be made from either the Assure server or the Assure client.
Adding the driver into Assure client
Add the driver into
Adding the driver into Assure server
The standard custom JDBC instructions apply:
Follow the instructions within Installing a Data Source on WebSphere Application Server.
Follow the instructions within External Datasources Configuration for Wildfly Deployments.
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.