I am trying to create a data lake using data from 20-25 independently hosted moodle systems on the same network.
I cannot access the backend of these systems. I am aware that the admin can run a custom SQL query from the front end and export it as a CSV/ JSON etc.
I need to automate the process of the above generated file being uploaded to a given server.
What are my options to receive the daily report to a common server location without having to access the backend.
Thanks.