Skip to main content

Hi,

 

we are in a project to update our on premise ERP system Infor to the current version Infor LN CE which is running on the cloud. Since we cannot access the database then directly we are currently checking how to ingest the data to TimeXtender in future. There is a tool within the ERP suite to provide the data to "Infor Data Fabric" which is an Amazon S3 data lake where the ERP data is stored in JSON files. This data fabric provides a SQL Endpoint to query the data. So similar architecture as in MS fabric with lakehouses.

 

The data can be queried in two ways:
- JDBC: using a JDBC driver with API Gateway authentification, see
    Link
- API: handle API request in a certain order to start a query job, aks its status and get the results, see link:
    
    https://www.youtube.com/watch?v=m4d0awIQ6Ag

For TimeXtender, which would be the way to prefer? I could not find the possibility to add a JDBC datasource with API authentification and I am wondering if TimeXtender can handle the process order of the API requests as in the description.

Thanks for any input.

Regards
Marco

Hi,

if there is no ODBC driver for Infor Compass, you could use a JDBC-ODBC bridge (see: https://www.progress.com/tutorials/odbc/odbc-connectivity-to-the-infor-data-lake-using-the-compass-jdbc-driver-and-openaccess-sdk) but that will probably cost some performance.

I assume the ION API system will require setting up a REST endpoint and then calling it. That will likely be doable with REST or JSON connectors. The documentation for that seems a bit sparse, there is no mention of which route is more preferable for bulk extraction.


Hi @Marco 

I would agree, the API is the way to go.


Reply