What is the process to access the database on the FME Server just so that we could have a trail of files that users ingested and the outputs that were generated?
What are some of the best practices we can implement that can be helpful at the time of audit ?
The best practice is to not use the FME Flow database.
If you’re looking for jobs analytics, you want to use the FME Flow API to retrieve data about them and process that (job logfile, metadata,...) :
https://docs.safe.com/fme/html/FME_REST/apidoc/v3/#!/transformations/listCompleted
The best practice is to not use the FME Flow database.
If you’re looking for jobs analytics, you want to use the FME Flow API to retrieve data about them and process that (job logfile, metadata,...) :
https://docs.safe.com/fme/html/FME_REST/apidoc/v3/#!/transformations/listCompleted
100% this.
If there is information you would like to be able to see about the instance/jobs and it’s not in the API, it’s very possible it could be added. If this is the case, open an Idea for Safe to pick up for development.