Supported functions

The following prerequisites apply to the use of Historical Access:

The runtime system whose symbols are to be stored for Historical Access must be configured for Data Access (and the respective variables must be enabled).
In order to use an SQL Compact database as a storage medium, SQL Compact Runtime 3.5 SP2 must be installed on the computer on which the OPC UA Server is running.
SQL Compact databases are also supported under Windows CE.
SQL Server databases are not supported under Windows CE.
The following MS SQL Server versions are supported: 2017, 2019
The following recommendations apply when using the respective memory type:
Main memory: number of entries < 5000
File system: number of entries < 10000
Database: number of entries >= 10000

Memory types

The following memory types are supported:

Memory type	TF6100 Server Setup version	Operating systems	Description
Main memory	4.x and 5.x	Windows, Windows CE, TwinCAT/BSD	Saves the values in the RAM of the device on which the OPC UA Server is running. No further parameters are required. After restarting the device, the stored values are no longer available. The storage medium is therefore not persistent. The above requirements and recommendations apply.
File system	4.x	Windows, Windows CE	Saves the values in several files, the location of which can be specified. Each symbol configured for this storage medium is assigned its own file in this directory. In addition, there is a backup copy of the file for each symbol, which is created when the buffer size is reached. The contents of the data file are then saved as a backup copy, and a new file is created. The above requirements and recommendations apply.
SQL Compact database	4.x	Windows, Windows CE	Saves the values to an SQL Compact database, the location of which can be specified. The above requirements and recommendations apply.
MS SQL Server database	4.x	Windows	Saves the values in an SQL Server database that is referenced with various parameters. The above requirements and recommendations apply.
TwinCAT Analytics	5.x	Windows, TwinCAT/BSD	Saves the values in a file format that corresponds to the TwinCAT Analytics storage format. The data can therefore be used further with the TwinCAT Analytics Toolchain. This format has replaced the old file-based storage format since TF6100 version 5.x (see above).