Managing the data sources
Data that has been historized with the Analytics Storage Provider can be used as a data source for the charts. The data sources can be managed directly via the dashboard.
 | Automatic addition of historical sources during code generation From TwinCAT Analytics Workbench version >= 49.0, all historical data sources from the project are automatically transferred to the dashboard during code generation. It does not matter whether these are actively used in the project or have merely been added as sources. Please note that live data sources cannot be used. |
Open of the Data Source Management
Data sources can only be managed by users in the "__SystemAdministrators" or "Administrators" group. You can open the Data Source Management via the menu icon in the top right-hand corner: Menu - <username> - Data Source Management.
Alternatively, you can also open Data Source Management via an existing Interactive Chart.
Overview of data sources
All existing data sources are displayed in the Data Source Management. The status of each data source is also displayed. This has the following meanings:
- OK: The data source has been configured correctly.
- NOCONNECTION: The data source was configured incorrectly. In this case, the connection parameters should be checked and corrected.
- OBSOLETE: The Storage Provider of the data is outdated and should be updated to at least version >= 1.0.12.3. Otherwise, data cannot be queried correctly.
- INIT: A new configuration has been sent to the server extension. This attempts to connect to the data source.
- UNDEFINED: The configuration has only been created locally and has not yet been saved in the server extension.
- NOSOURCEHANDLER: The configuration could not be loaded correctly in the server extension and should be saved again.
Creating a data source
New data sources can be added simply by drag and drop from the TargetBrowser. In the TcAnalytics tab, select Historical Data sources.
All symbols are automatically added to the data source.
If the parameters have been read successfully, the upload icon lights up green. Click on the upload icon to send the configuration to the server extension.
If the Target Browser is not available on the device, you can create an empty data source using the plus icon in the bottom right-hand corner. This must be configured manually.
Configuring and changing a data source
You can use the arrow to the left of a data source to expand and edit it.
The following parameters can be set:
Parameter | Description |
|---|---|
Source ID | Unique ID of a data source. This is unique and is assigned by the server extension. |
Message Broker | Address of the message broker |
Broker Port | Port of the message broker |
Topic | MQTT topic of the historical stream „…/TcAnalyticsStorageProvider/…/Historical/Stream…“ |
StreamTopic | Original topic of the recorded stream. |
Cycle Time | Cycle time of the data source in 100 nanoseconds. |
Layout | Layout of the stream |
Stream SystemID | SystemID of the recorded stream. |
UserID | User name for accessing the message broker. |
Password | Password for access to the message broker. |
With certificates | If the value is checked, the selected certificate files are used. |
CA | CA file (can be uploaded to the server extension). |
CERT | CERT file (can be uploaded to the server extension). |
KEY | KEY file (can be uploaded to the server extension). |
Key Password | Password for the KEY file. |
The changes can be sent to the server extension via the save icon (green). Alternatively, the changes made locally can be undone using the reset icon (blue). The status of the data source can be queried again via the refresh icon (gray).
Deleting a data source
A data source can be deleted using the corresponding delete icon (red). Please note that all charts using this data source will no longer work. If parameters are changed, such as the broker address or the renewal of certificates, it is advisable to adapt existing data sources and not to delete them.