Service
The Windows service of the Analytics Storage Provider requires at least a TwinCAT 3 ADS as a basis. The setup automatically detects whether a TwinCAT 3 XAE is present or not. If available, also install the PLC library, otherwise only the Windows service.
After the installation you will find everything you need under C:\TwinCAT\Functions\TF3520-Analytics-StorageProvider. One hierarchical level down you will see the WinService folder, where you will find the TcAnalyticsStorageProvider_config.exe file.
Open this executable file and you will see the configuration interface.
- Analytics Storage Provider
Main Topic: set your own main topic here to identify a stream with historical data.
Comment: you can enter a comment that will be displayed later in the Recorder window in the Analytics Workbench or the Service Tool. - Message broker
- Settings:
Enter here your message broker data such as URL, user name, password or certificates.
The settings can be checked. The result is displayed in the following window:
- Storage
Type: select the type of your data sink here, such as Analytics File or Microsoft SQL
Connection String: you can configure your Connection String manually or automatically through the given settings mask.
For Microsoft SQL see: - Additional Properties
Two additional settings can be made in the Additional Properties.
Max Write Length:
For Analytics File: the amount of data that is written to the .tay file in one call is specified here
For MsSQL: the amount of data that is stored in a tbl_Data data set is specified here
Max Duration:
For Analytics File: here, the time is specified, after which a new .tay file is created
With MsSQL: here, this setting is not relevant
- Analytics Storage Provider Windows Service
Status: View the status and default settings for starting the Windows service
Of course, the created configuration can be saved. If you click Save Config, the settings in TcAlySPWinService.exe.config will be saved in C:\TwinCAT\Functions\TF3520-Analytics-StorageProvider\WinService.