Overcoming Data Volume and System Limitations

Migrated 4.7 million records, overcoming significant challenges posed by the substantial data volume and inherent limitations within the AS400 integration environment

Client

Hit Promotional Products Inc, FL, USA

Vertical

Retail

Solution

IBM AS/400

Hit Promotional Products Inc, FL, USA

Customer Profile

Hit Promotional Products is a leading, family-owned company in the promotional product industry, offering a vast selection of branded items and gifts with top-tier imprinting and decoration services. As one of the top five suppliers in the nation, Hit is committed to sustainability and continuously adapts to meet client needs in a fast-evolving market. With a strong focus on customer success, extensive inventory, and swift delivery, Hit Promotional Products is the trusted one-stop shop for all your promotional product solutions.

Problem Statement

Proposed Solution

To streamline the migration, intermediate tables were created within the AS400 system to temporarily store and format the incoming data. Custom programs were developed to efficiently transform and load the data into the AS400 system. Thorough data validation procedures, including error detection and duplicate checks were implemented to ensure data accuracy. Additionally, a comprehensive mapping process was conducted to guarantee precise field alignment. Robust integrity measures, including rollback capabilities, were implemented by Team Somnetics to safeguard data during the migration.

The successful migration of 4.7 million records into the AS400 system was achieved through the use of intermediate tables and customized programs. This method streamlined the data upload process and ensured that the data was accurately formatted and integrated into the system. Consequently, the AS400 system is now better equipped to handle large datasets effectively, enhancing overall data management capabilities.

Retail