Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Labels (2)
Contributor

Using Ignition version 7.8.4 (b2016082217) | 64-bit

Copy dependencies needed to make a connection to the Apache Phoneix Server werecopied into Ignition\lib

13962-newlibfolder.png

Edit Igntion\data\ignition.conf to register the dependacy with Ignition's boot strap process

13961-newconfdeps.png

Restart Nifi and then begin the process of configuring JDBC drivers by selecting the drivers link in the Databases section of Ignition management console

9289-select-drivers.png

Select create new JDBC Driver on the Drivers Home Page

9282-create-new-jdbc-driver.png

Complete and submit the driver properties page using the following as a guide

9291-configure-apache-phoenix-driver.png

Now select connections from the data bases menu

9284-create-connection.png

and create new database connection from the connections home page

9283-create-connection-2.png

Complete and submit the connection properties dialog

9292-configure-connection.png

After successfully submitting the configuration the connection should appear on the connections home page

9290-check-status.png

If there are any issues with the driver or connection they can be found in the log of the system console

9288-check-logs.png

With the connection configured we can now added data to the HMI application from queries of the phoenix server

Select new query tag

9293-select-new-query-tag.png

define and the SQL statement

9281-add-sql-to-tag.png


edit-igntionconf.pngcopy-deps-into-ignition-lib-folder.png
309 Views
Comments

Nice writeup @wsalazar. I think you can simplify your classpath setup by only including the /usr/hdp/current/phoenix-client/phoenix-client.jar and the XML configuration files (core-site, hdfs-site, hbase-site). The phoenix-client.jar will contain all of the classes necessary to connect to HBase using the Phoenix (thick) JDBC driver.

Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
2 of 2
Last update:
‎08-17-2019 08:14 AM
Updated by:
 
Contributors
Top Kudoed Authors