Hi, I have created a number of ad-hoc GQI queries. In the next step of my project, I would like to run these queries at fixed intervals - e.g. once per hour, and keep track of how the results evolve over time.
Is there any existing solution for this? Perhaps a connector that can run the queries and trend the results?
Hi Michiel,
I think this is a good use case for using the Data Aggregator. With this DxM, you can convert your GQI Queries to Queries that can be executed in the Data Aggregator. Next, you can schedule via so-called Cron Expressions the frequency (for example every hour). The results can be written in a CSV, so every hour you will have a CSV, with a clear datetime. Then, with an ad hoc data source reading those CSVs, you could visualize how the data changes over time in a Dashboard (or you can read it and calculate statistics in your own virtual connector of course).
An extra benefit of the Data Aggregator is that it comes out of the box with the Data Aggregator Monitor, which enables you to already have alarming and trending on the generated amount of rows, the duration of the query and if it has succeeded or not.
Kind regards,
Joachim