Hi Dojo,
I am looking to integrate external data containing Device name, timestamps and polled value results into DataMiner and visualize this data using Dashboard graph.
Could you please advise on the recommended approach to achieve this? Specifically:
- Are there any preferred or required file formats for importing external data? Eg:Json, CSV or xlsx?
- Do I need to create any specific elements to manage this data?
Any guidance or references to relevant documentation would be greatly appreciated.
Thank you.
Hi Aswiny,
Depending on the nature of the external source, an ad hoc GQI might be a suitable option in this case. Please see the documentation here:
Ad hoc data sources | DataMiner Docs
Either format is possible; however, text-based files will be easier to integrate than binary types like MS-Excel. I would say, if you can control the output of the external source, CSV and JSON are preferred.
Consider implementing mechanisms that filter, and update based on the size and frequency of changes from the external source.
Hi Ashwiny,
Yes, the GQI could provide data for use by other graphics components. If you want to add time range filtering, it is a matter of adding an input argument so that the response will be constrained within the time frame.
Hi Gelber,
Thanks for the response and the documentation.
Kindly advise with GQI fetching the data from external file source, is it possible to generate graphs for certain time range: daily, weekly, monthly?