FAQ - frequently asked questions and answers

How can I manage the table schema of MS SQL with ASP?

You don't have to worry about the table schema. This is done completely by the Analytics Storage Provider. You only have to specify on which database server the data should be stored. If you want to see data in your own table structure, you have to stream the data into a TwinCAT Analytics Runtime and have the TwinCAT Database Server write the data in your structure.

Can I control the Storage Provider in a programmable way?

Yes, via the PLC interface for the TwinCAT Storage Provider. You can start/stop recordings or retrieve historical data (raw data or result data).

Is it also possible to save results from the Analytics Runtime?

Yes, this is possible. For this purpose, you can choose to send the results to an MQTT Message Broker when generating the Analytics Runtime from the Analytics Workbench configurator. This data stream can be captured by the Storage Provider.

Are open source software components used in TwinCAT Measurement products?

Yes, various open source components are used.

Please see the information on the page Third-party components.

What factors influence the data throughput of the storage provider?

The data throughput depends on many influencing variables. Primarily of system and network resources. An overview:

• System properties (CPU, RAM)
• Writing speed and quality of the storage medium (SSD)
• Network properties
• Complexity of symbolism (data type, structures, arrays, etc.)
• Mode of historization (total symbolism allows higher throughput, a subset may be more costly depending on its size)
• Compression level of the stream (the stronger the compression, the higher the system load)
• The size of a sample
• Total size of a data packet (number of samples per packet)
• The number of parallel recordings that the storage provider manages