How to Configure I/A Series R2 to Read Data from an External SQL Database

[Product_Support]

Issue

Need to import data from a facility management system’s SQL database into an I/A Series R2 station.

Product Line

TAC IA Series

Environment

• I/A Series R2 system
• External SQL database

Cause

The system requires integration of external SQL data for reporting or operational purposes.

Resolution

Use the sqlUtility module, which includes an object called SqlData to perform SQL queries on any SQL database.
Important: The sqlUtility can only be used in an Enterprise Server, not in a UNC.

Steps:

1. Create a SQL query that returns a single column from the target data table.
2. Example query:

   SELECT EnergyIntensity FROM EnergyTable ORDER BY O_Id DESC

   • This query retrieves the EnergyIntensity column from the EnergyTable, sorted by record number (O_Id) in descending order.
   • The returned value will be the first element in the first column of the query results, ensuring the newest value is obtained.