Page History

false

Info

Built with v10.

This solution demonstrates the functionality of the TagProvider with the SQL Database.

icon

Download the Solution Examples Example here:

Solution Name: SQL Database TagProvider Example

Software Version: v10

Keywords: SQL Database, TagProvider Connections, TrendChart

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.