|
| New data warehouse consolidates critical company data from legacy systems.
|
|
Business Challenge
With over 2,000 sales representatives, this distributor of office products had a tremendous amount of customer data, personnel records and compensation schedules on legacy systems. The distributor required project support to migrate this data to a data warehouse built to coexist with an AS/400. Major concerns centered around the complexities of cleansing the legacy code and capturing the large volume of mission-critical data that needed to be migrated to the data warehouse.
The solution required strong programming skills both in mainframe and AS/400 environments, which favored IBS. Extensive project experience in data bridging was another determining factor in the selection of IBS. The data migration project not only involved millions of lines of code, but also required a clear understanding of the distributor’s business.
Benefit Provided by IBS
IBS delineated the process in an overview statement, considering the appropriate data architecture required to accommodate specific business issues such as billing rates, compensation structures, and channels of communication. Within the targeted time frame, IBS analyzed the data architecture, cleansed the legacy data, and initiated the process of migrating the data to the AS/400. As a result of the efforts, the distributor is well positioned to achieve its goal of conducting the majority of its business online within the next few years.
IBS Expertise Applied
Data migration from legacy mainframe to AS/400 midrange system with data warehouse |
|
