PC-iRoute case study
Extracting stock details from an Access database to interface into an inventory database on the iSeries.
Business requirement
Current stock details are recorded into an Access database. These are to be extracted and transfered to the iSeries for import into an existing system.
Using PC-iRoute
- A PC-iRoute script is created to extract the required stock details, specifying the iSeries as the destination type
- An Access database macro is specified as a pre-processing option. This verifies that the data is in the expected format
- A post-processing macro is specified to set the processed flag.
- The script is scheduled for execution on a daily basis, if the pre-processing option fails to execute then the script is not run
- The data is transfered to the iSeries and using an iSeries post processing option is interfaced in to the existing stock system
Benefits of using PC-iRoute
- A seemless interface between the Access database and iSeries stock system is created
Back to PC-iRoute case studies
