Hi guy, ;-)
do they really want the reports or have they simply seen values like start and stop time? Or similar stuff? The reports are definitely the wrong things to export.
For reporting purposes you should extract the relevant(!!) data and store it in another database. That's what Analytics is doing to reduece the workload on the main database. If you don't have this you will need to export the data by yourself. A couple of database jobs will do the trick.
The problem is to determine what is the set of relevant information. One approach could be to let them define the metrics they like to have and then to identify the DB table(s) that contain the data. The first thing is surely to build up some understanding of the data model behind Automic. Otherwise OH, EH and AH might confuse you. :-)
Regards
Juergen
------------------------------
Juergen Lechner
Senior Consultant
setis GmbH
Germany
------------------------------
Original Message:
Sent: 05-27-2020 06:30 AM
From: Thierry Tarrason
Subject: Export of data for metrics
Hi guys,
Our Data Analytics team needs to generate metrics to provide indicators, KPI's and dashboards.
For that, they'd like me to export all the job reports.
What would be in your opinion a good way to do this?
------------------------------
Best regards,
Thierry
Banque de Luxembourg
------------------------------