Skip to main content
wsalazar
wsalazar
Gold ⭐️
November 10, 2016

Connect Phoenix to Ignition HMI

  • October 5, 2026 at 9:34 AM
  • 1 reply
  • 1872 views
  • Translate All

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

    1 reply

    elserj
    Gold ⭐️
    elserj
    Gold ⭐️
    November 11, 2016

    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.

    Translate
    Terms & ConditionsAccessibility statement