Data load from Data Lake into Infor EPM relational modeling

To load data manually from Data Lake into relational modeling, manually specify a query in relational modeling, or generate a SQL SELECT query in Compass and paste the generated query into the Query Editor in relational modeling. Select Data Lake as the source connection.

Automation of query execution is possible with Infor ION Workflow and ION data flows.

You can also run load queries using Application Engine processes and non-SQL scripts.

Running time for load queries must not exceed 60 minutes. If data is not fully loaded, you must clear the affected integration or staging tables and rerun the load query. You can adjust data with INSERT, UPDATE, or DELETE statements in the relational modeling scripts.