Introduction to the SQL API

The SQL API is a collection of SQL Server stored procedures that can read Process+ data.

This API can be used as a data source to build your own Process+ specific reports using a different visualization tool. Note that the visualization tool must support SQL Server stored procedures as a data source. It can also be used to extend the existing reports shipped with CSense 8.0 in the Control Loop Performance application on Operations Hub. See Deploying Control Loop Performance application on Operations Hub on how to setup the application on Operations Hub.

The API provides access to following types of Process+ data

• The interim tag data for TagPV, TagSP, TagMV, TagControlMode, DeltaLowerLimit and DeltaUpperLimit. This interim data can be used to populate trends for the specified tags up to the last 30 days of calculated Process+ data.

• Histogram data for Error distribution (PV - SP) and TagMV distribution in the form of bin indexes and their paired bin values. A simple vertical bar graph with bin index as the x value and bin value as the y value can make use of this data.

• Grouped Process+ KPI data.

• Process+ Shift performance data.

Note that the stored procedures require SQL Authentication. Remember to setup access to the API by following the steps on Getting started with the SQL API.

All available stored procedures can be found on SQL API Stored Procedures.