It would be super cool if the underlying metadata and job/task history (in the internal Derby database) were available to be queried.
The simplest way to do this might be to replicate the internal database (using Sync!) to some other customer-owned database. Then they can access it using their connectors and tools of choice.
So someplace under “Settings”, the user would provide connection details for “Reporting Database”. Then a hidden Sync job would sync up the internal database to that destination every X minutes or hours.
I guess a different way to accomplish this would be for me to access all of the data through the Sync API, and set up a API-to-database syncing job myself. But that’s more work for me. ;-)
