Connecting to a SQL database

[youngy4130]

Hi 

Out MIS system is SQL based and doesn't use jdf. Is there a way i could submit a SQL statement or request in Freeflow?

I just need to pull out a size value from our database to use as a variable.

Thank you

[JavierM-Xerox]

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.

[youngy4130]

Thanks I'll do a bit of digging and see if we can work this out.