Page History

Summary

This solution demonstrates the functionality of the TagProvider with the SQL Database, enabling runtime data querying without the need for local Tags. This allows queried data to be displayed on TrendCharts and other areas of the application, streamlining real-time access and utilization of database information within the Unified Namespace.

First Solution:

Second Solution:

Image RemovedImage Added

Technical Information

In the

first solution,

which works as a publisher, each tag corresponds to a data point of interest

and is configured to store

its values

in a SQLite database. This setup

ensures essential information is captured and logged from various sources,

with each tag mapped to a specific table

for organized and easily queried storage.

In the second solution, real-time monitoring of tag values is achieved by

using a TrendChart, enabled through the use of a Tag Provider connection to the SQLite database from the first solution.

Additional Information

After downloading the files, move them to C:\Documents\FrameworX\Solutions. Then, open the TrendChart Solution, navigate to Datasets

/ DBs, and edit the Data Source for Provider 1 by specifying the path to the TrendChartPenValues.dbHistorian file.

Reference Information

→ SQL Database TagProvider

→ Historian Tags

→ TrendChart

Control

→ UNS TagProvider Connections

→ AssetsTree Control

In this section: