RouteOne case study
Transferring sales orders to an Access database to perform a mail-merge.
Business requirement
A Scottish manufacturing company requires a method of producing order confirmations as part of a mail merge document using data extracted from the iSeries database.
Using RouteOne
- A RouteOne definition is created to only transfer new orders using the appropriate function
- Each order contains multiple order lines within the iSeries database. In order to perform a mail-merge, these have to merged into one record in the Access database. RouteOne allows the user to merge multiple records to one row. The order lines span the columns rather than the rows.
- A post processing path is included in the FTP request to call the mail merge routine that prints the order confirmations in a word document.
- The RouteOne job is added to the IBM scheduler to run overnight
Benefits of using RouteOne
- Data is imported automatically into an Access database with no manual intervention such as defining date fields and numeric fields.
Back to RouteOne case studies
