Hi,
We have got quite a large Data Miner network that handles many devices. We also have a central database (MSSQL) that stores alarm information on it.
As I understand, managing the central database is not the concern of dataminer. On the other hand, being able to influence it from there would simplify matters. Because of the size of this network, certain data needs to be offloaded somewhere else for archiving purposes, with some exclusions that would stay on CDB.
Is it possible to create an automation script from inside dataminer that would move certain old rows from central database to an archive location? If not, is there any way of influencing the central database (besides uploading information to store) from dataminer itself?
Hi Michal,
Whilst it's perfectly possible to run something in DataMiner, using embedded SQL statements for example, this would be an inefficient architectural choice. You would be potentially tying up resources on a live system to carry out the required actions.
It would be better to have something on the CDB server. There are many options, such as stored procedures to offload and clean data based on your chosen criteria.
Hi Simon and thank you for this answer!
I understand that there are currently no ready made tools integrated into dataminer that would allow me to automate this task, bringing the issue down to picking up the proper tool for the job.
I am wondering if anyone around here had to deal with periodical offloading of a stuffed central database and has found an elegant solution for this. Writing a special procedure would be an easy task at start but would require a lot of maintenance when it comes to changing requirements or adding some certain features. There is a also a risk of damaging data integrity, which wouldn’t be desirable.