- 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:
Technical Information
In the initial solution, a set of tags is defined, each representing a data point of interest. These tags are configured to store their values within a SQLite database. This setup allows the system to capture and log essential information from various sources, ensuring organized and queryable storage of tag data. Each tag is mapped to a specific table within the database, establishing a streamlined approach to data management.
In the second solution, real-time monitoring of tag values is achieved by utilizing 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.
In this section: