The Infor Communities is globally accessed system by
Infor and its customers, please do not post or upload
any content that could be deemed as sensitive, confidential or
subject to any data regulation requirements.
If you are unsure whether or not the content contains sensitive,
confidential or has any data regulation requirements,
please seek the advice of your internal security, legal, and compliance experts.
Hi , I have a requirement to create job(script) that needs to extract data from Infor datalake and to generate CSV files . Could you help to do with best approach ?
I'd recommend checking out page 124 (as of December 30th, 2019) of the Infor ION Development Guide - Cloud Edition. It provides details on available Compass APIs and how you can submit a query, check the status, and retrieve the result set.
You're able to request either a CSV or ndjson object that the API consumer can then further process. Alternatively, you could use the Compass JDBC driver to retrieve and export a result set.
The Compass APIs aren't yet compatible with the ION API connector within ION but will be soon as we add enhancements to expand support content request types.
Absolutely, check out KB 2103864 for more details
Any updates yet?
We have a requirement to keep everything within Infor ION.
I had the same requirement, and while waiting for the AnySQL connector, I built this solution to pull the data. It's not a straightforward process, but it works. If at all possible, I would suggest an external program and scheduling until the AnySQL connector is in place.