The FFCore hot folders can be configured to automatically make a CLI call when a file (any type of file) is dropped into the HF. The output of that script should be a file that FFCore understands.
If you can export a file from the MIS into a FFCore hot folder, you should be able to invoke a custom script to make the SQL query and generate a manifest (aka a CSV file) that FFCore would process for job submission.
If you are unsure about how to implement the above, I would suggest that you contact your Xerox analyst. They should point to resources that can help with this sort of thing.
