We have a running Dataminer system with Cassandra and OpenSearch which is being stopped due to project being completed. However, the customer wants to maintain access to the data collected. I see that there is an option for MySQL offload, however, is limited to data from time started. Is there a way to offload all data to MySQL to backup a running system and make data searchable from external tools.
Or is there a better way to make the collected data (trend and alarm) accessible once the system is turned off?
Hi Steve,
A possible solution is to use the Data Aggregator to offload information history information (alarm and/or trend data). For example, we are currently using this feature to download history alarms from the DB to CSV files.
Since Data Aggregator relies on GQI queries, you could implement adhoc data sources data offload specific information from DB. However, as Wale mentions, it is not a trivial exercise.
Hope it helps.