Skip to main content
To homepage To homepage
Solved

Ingest Data from Infor Data Fabric

  • October 30, 2024
  • 2 replies
  • 86 views
M
Visitor

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

Best answer by rory.smith

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.

View original
    Did this topic help you find an answer to your question?

    2 replies

    rory.smith
    TimeXtender Xpert
    Forum|alt.badge.img+7
    • rory.smith
    • TimeXtender Xpert
    • 652 replies
    • Answer
    • October 30, 2024

    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.

    Thomas Lind
    Community Manager
    Forum|alt.badge.img+5
    • Thomas Lind
    • Community Manager
    • 1020 replies
    • October 30, 2024

    Hi @Marco 

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

    Reply


    Most helpful members this week

    Terms and ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings