So, based upon this document I found from Johnson about FX Server, it can spool out the telemetry data to an external database like db2, SQL, Oracle with the correct drivers installed to the FX Server. Also, FX does have an API/JSON/webservices support, but you will see it requires a "license" and installation to do so.
1. https://docs.johnsoncontrols.com/bas/v/u/Facility-Explorer/en-US/FX-Server-Product-Bulletin
2. https://docs.johnsoncontrols.com/bas/r/Facility-Explorer/en-US/FX-Server-Release-14.x-Product-Bulletin/14.x/Ordering-codes
(Search for API and you will find the ordering codes)
I have not personally done a JC-FX integration, but given their support for rel-databases and JSON/REST/API, it does not seem too mysterious.
------------------------------
John Q. Todd
Sr. Business Consultant
Total Resource Management
------------------------------
Original Message:
Sent: Thu April 11, 2024 04:59 PM
From: Timothy Dilbert
Subject: How to pull/stream data from Johnson Explorer
Hi Everyone,
I have a customer with Johnson Control Facilities Explorer (FX) installed. They want to stream data from that platform into Kafka. As I'd imagine there are MAS customers doing the same, I am posting this message on here to see if there is anyone with knowledge on how to pull data from FX?
Can FX be a MQTT Broker? Can FX write to an external database (perhaps we can then stream readings using Debezium)? Any other ideas on how we can get this data out?
------------------------------
Timothy
------------------------------