Extract data from Infor datalake and generate CSV files

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 ?

Find more posts tagged with

Infor Data Fabric

Accepted answers

All comments

unknown

You can use ION to extract data from Data Lake and export it as file to folder.

1. In ION Data lake flow, use Retrieve to extract tables required.

2. Use any filter/schedule as required

3. Migrate data to DB/File.

unknown

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.

unknown

Thank you for the inputs and quick response Mike, Do we have any steps/workflow (document) how to do we connect with Compass JDBC driver?

unknown

Absolutely, check out KB 2103864 for more details

unknown

Thank you Mike, I can see the documents to connect from sql clients but my requirement to extract data to CSV file. Compass JDBC driver supports python/java/Shell scripts ?

We may need to extract high volume of data and do we have any limitation with Compass API

Copyright © 2025 Infor. All rights reserved.