RouteOne case study
Populating a data warehouse in an SQL Server database from files across multiple iSeries systems.
Business requirement
A worldwide electronics organisation has 17 iSeries systems situated throughout Europe. The company requires standardised reporting. To achieve this, one iSeries has been designated as a data warehouse.
Using RouteOne
- RouteOne definitions are created across the multiple databases
- Foreign characters sets are converted, therefore avoiding language issue conflicts
- An FTP request is created specifying an SQL server to populate
- Data compression is used to achieve the highest possible transfer rates
- A centralised history log is monitored to ensure a successful outcome
Benefits of using RouteOne
- Up to the minute information is now available for users in one central location allowing much better response to business issues.
Back to RouteOne case studies