22

Recurring file-based integrations utilize data entities and the Data Management workspace to move data to the end application tables. The process is currently setup to first use SSIS to move data into the SQL staging table and then immediately execute the job to copy the data from staging to target.


There are scenarios that require user input in the staged data before executing the process to sync data from staging to target. There is currently no way to model these integration scenarios. An option should be added to a recurring data job to enabled or disable the "Copy data to target" step. When disabled, the integration could have a status called "Staged" where a user could provide input and then update the status to "Ready to copy to target." At this point the integration job could pick back up and execute the final step to copy the data.

STATUS DETAILS
Under Review