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