Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Can an I/A Series R2 station be configured to read data directly from an external SQL database?

Issue

Import data from the SQL database of a facility management system into the I/A Series R2 system.

Environment

I/A Series R2 system

External SQL database

Cause

Import data from the SQL database of a facility management system into the I/A Series R2 system.

Resolution

This module sqlUtility contains an object called "SqlData" that can be used to perform a SQL query on any SQL database.

The sqlUtility can be used only in an Enterprise Server, not in a UNC.

Using this object, you need to create a SQL query to return a single column in the data table.
Here is a sample query that returns the column EnergyIntensity from the EnergyTable

SELECT EnergyIntensity FROM EnergyTable ORDER BY O_Id DESC

This query returns the EnergyIntensity column of the table "EnergyTable" after sorting the record number (O_Id) in descending order.  The data value returned by the SqlData query will be the first element in the first column of the query results.  Since the query uses the ORDER BY data qualifier, specifying descending order of the record numbers (O_Id), the newest value will be returned.

Tags (1)
Labels (1)
Version history
Revision #:
1 of 1
Last update:
2 weeks ago
Updated by: