Configuring USG - Johnson Controls - LIT-12012431 - Software Application - OpenBlue Enterprise Manager - 4.0

OpenBlue Enterprise Manager Data Collector Installation Guide

Product
Building Automation Systems > Building Automation Systems > OpenBlue Enterprise Manager
Document type
Installation Guide
Document number
LIT-12012431
Version
4.0
Revision date
2021-11-29

Procedure

To configure SQL for ADX, complete the following steps:

  1. From the Destination Database list, select the appropriate database name.
  2. In the Datasource Name field, enter a name.
  3. In the Username field, enter your user name.
  4. In the Password field, enter your password.
  5. In the Server IP field, enter the SQL instance server IP.
  6. In the DB Polling field, enter the polling time the framework checks with the Generic SQL database from new device or points added after initial discovery.
  7. In the Event Start Date, select the current date.
  8. Uncheck the Get Events check box for Enterprise Manager.
  9. To read timeseries data select the Get Timeseries check box.
  10. Select the Post Entries check box to enable USG to post entries to the cloud.
  11. In the Device Points section, in the Point Polling Time, select the time interval the present value for selected points is pulled in.
  12. In the Metadata Query tab, enter the query to read the metadata from the connected system and output column is to be the same as the parameter list.
  13. In the Time Series Sample Query tab, enter the query to read the timeseries from the connected system and output column to be the same as the parameter list.
  14. In the Events Query tab, enter the query to read the events from the connected system and output column is to be the same as the parameter list.