The Data Load Workbench feature provides a framework to import, view and verify, and export data from source systems in the ERP Integrator.
Key features of the Workbench include
Interactive Load Process with options for Import and Export
Provision to view Source (All) / Source (Mapped) / Target / Source and Target values
PTD / YTD Value display for ready reference
Display options for Valid, Invalid, Ignored and All Data
Online and Offline Load process
Query option for Historical Loads
Historical Loads Export to Excel
Drill-back to source from Workbench
Note: | The Data Load Workbench and Write-Back Workbenches share an almost identical user interface. For this reason, both features are documented in this section. Exceptions are noted when applicable. When you login with the Run Integration role, these links are visible in the Tasks pane: Data Load Workbench, Data Load, Member Mapping, HR Data Load, Metadata, and Process Detail. |
The Data Load Workbench consists of three sections:
POV Bar
Status
Data Grid