0OVERVIEW
Our Client is a leading shoe retailer, dwelling over 3,500 shops across the United States of America. The retailer proffers an assorted variety of fashion accessories and footwear products by enforcing modernism and dynamic response. The client holds many warehouse amenities and supply chain maintained by a Warehouse Management System.
BACKGROUND
Initially, the Client practised the traditional batch processing solution for the execution of outstanding orders. The mainframe system handles the data, and a time-frame is scheduled during early morning or night and was fed into Warehouse Management System. Moreover, E-Commerce orders are also processed which increased the volume of batch processing data. This imbalance in load leads to several time and processing constraints in the Warehouse Management System. In addition to this, the issues aroused with joining of the data as it is needed to join various distribution centres data. For the client, there was a necessity for the solutions to be reliable and should be architecturally compatible between the Eastern Distribution Center and the Western Distribution Center solutions. The Client approached TeckSphere and asked us to integrate the incoming ticket requests from the mainframe system to real time system to process the outstanding orders quickly.
TECKSPHERE SOLUTION
TeckSphere recommended a real time solution by employing TIBCO suite to integrate the enterprise data management products. The solution was built and enforced individually for the two Warehouse Management Systems and deployed to a central enterprise integration management and administration application. While processing E-Commerce orders, the Mainframe system generates a pick ticket file, and the data in the pick ticket file was populated into the Warehouse Management System staging table after the ETL procedure.
Our team has employed Publisher-Subscriber Architecture to collect, examine and transforms the incoming data before publishing it into Java Messaging Service (JMS) Server and finally upload the data to the target system. TIBCO adapter is used in file transfer operation to assure reliability. TIBCO File Server is used to parse the transaction, generates the order message, transform the message into canonical format and publish the individual transactions. The subscribing Business Information Warehouse converts the message into Eastern Distribution Center, and the Western Distribution Center format and places the transactions into their corresponding Warehouse Management System staging tables and the mainframe system is alerted for the process completion by inducing a trigger.
Based on the business needs, our TeckSphere experts have explored a complete data transformation and integration solution. The solution holds reusable property and adheres the standard of Retail Industry.
Outcome
- The retail orders are processed under real time scenario.
- Enhanced order management support.
- Well Organized and Centralized distribution operations.
- Improved system scalability and data consolidation
- Reduced overall system Usage by avoiding the usage of Warehouse Management System
TECHNOLOGIES USED
TIBCO BusinessWorks
TIBCO DataExchange
TIBCO Rendezvous
TIBCO EMS
TIBCO Object Star
