Solution Description

ChainSys Mass Data Loading automates expensive, time-consuming, and error prone manual data entry for JD Edwards with its fast, accurate, secure browser-based utility to perform mass data loads from CSV or Excel files to your system. Each mass data load complies with system import routines, system security, and custom business rules. Pre-validate each load, fix data errors, and keep a detailed audit trail.

Key Features and Highlights

Why ChainSys

• Time for repetitive data entry tasks is reduced.

• User errors for repetitive data entry tasks are reduced through pre-validation.

• System security is enforced.

• Centralized load monitoring and row and column-level audit trails are supported.

ChainSys Approach

Upon signing into the ChainSys Mass Data Loading tool, users can connect to file shares where CSV or Excel files are stored. Users then create a Loader and map the CSV or Excel files to the Loader through a drag-and-drop interface. In addition to the target system constraints, users can configure business rules to validate or transform data prior to loading to the target.

During execution, each loader will perform pre-validation against business rules configured in advance. Any validation failures can be fixed and re-submitted to the pre-validation engine. After pre-validation and data fixes are complete, the loader will execute the load against the target system. Successes and failures returned by the target system are also logged.