Table input
This setup is Infor’s best practice with the Data Lake API (payload extraction) process to deliver data through the ION ETL Tool to on- premises databases.
The Table Input step is used to run a select statement against the data flow’s upsert table to determine the latest DL Document Date loaded to the specified table. This information is passed on to the DataLakeInput step and automatically added to the query string. At the same time the payload records are selected that must be pulled and sent to the on-premise database.