Hello Dataminer community,
I would like to know if there is an easy way to retrieve data easily from one Dataminer cluster system to another and combine them in dashboards or low code apps.
Kind regards,
Marieke Goethals [SLC] [DevOps Catalyst] Posted new comment 22nd November 2024
Hi Alexandre,
Depending of your use case, I believe there are two possible options:
- In case you plan to retrieve specific information from the cluster, the option described by Edib will be a good approach. Something to keep in mind is that the every time that you open a dashboard in the destination cluster, the GQI query will be triggered requesting data from the source cluster. For example, if there will be multiple users opening this dashboard, the GQI query will be executed multiple times. You will need to see if a cache mechanism is required.
- In case you plan large amount of data (e.g. the list of all amplifiers available on your cluster, the peak value of a KPI from the last 24 hours), then you could use Data Aggregator. Data Aggregator can execute GQI queries in the source cluster (in a scheduled way) and store the result in a CSV file (in the destination cluster). Then the dashboard in the destination cluster will read the content of the CSV file. In that way you avoid retrieving data from the source cluster every time that you open a dashboard in the destination cluster.
Hope it helps.
Miguel Obregon [SLC] [DevOps Catalyst] Answered question 2nd August 2024
Hi Alexandre,
I see that this question has been inactive for some time. Do you still need help with this? If not, could you select the answer that has been most helpful for you (using the ✓ icon)?