Page History

Create SQL-based tag providers.

How-to → Examples → Feature → UNS → TagProvider SQL

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:

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

...