Data query tools: Accessing your data
- Last UpdatedMar 10, 2025
- 2 minute read
|
To report on the data you have stored in AVEVA Historian, you can use:
AVEVA Historian is part of a client/server architecture that supports desktop client applications, while ensuring the integrity and security of data on the server. This architecture provides common access to time-series data and associated configuration, event, and business data. |
|
The computing power of both the client and the server is exploited by optimizing processor intensive operations on the server and minimizing data to be transmitted on the network to improve system performance.
|
Microsoft SQL Server acts as the gateway for accessing any type of information in the historian. Historian uses Microsoft linked server technology to plug in its own OLE DB provider. Because of this, any client application that can connect to Microsoft SQL Server can also connect to AVEVA Historian. For users with client applications, it seems that queries are made to the Runtime database. That database is, in fact, the logical interface to the data. When it receives a request for data, the Retrieval subsystem retrieves the historized data from history blocks. |
|
Querying with AVEVA Insight
AVEVA Insight (included with AVEVA Historian) is a search-based tool that lets you quickly turn your data into easy-to-read charts.
With Insight, you can type the name -- or even a part of a name -- for the tags you want to analyze. Then you can choose the chart type and timeframe to report on. Insight also lets you save and share your data.
For more information on using Insight, see the online help.
Querying with Transact-SQL
Historian can handle traditional SQL queries. For example:
|
SQL Query |
Result |
|
|
|
