The client is the world largest marketer, distributor, and producer of bottle non-alcoholic refreshment. The Enterprise sells approximately 80 percent of their bottles in North America and is the sole licensed bottler for products of another company in Belgium, continental France, Great Britain, Luxembourg, Monaco, and the Netherlands.

The clients sales orders are entered by the field sales force into a consolidated Windows 2000 server and uploaded into an AS/ standard middleware solution (RemoteWare from Xcellenet) to achieve integration between these 400 system en route an SAP system under implementation. The previous solution used a non- multiple systems. Besides running in a batch mode, this solution used iterative processes, which demanded frequent manual intervention and were not robust enough to handle the growing data volumes. To monitor and support this data flow efficiently, the client needed a proven middleware solution that also conformed to its corporate platform standards.

The purpose of this project was to design, develop and implement such a middleware solution.

Vitria BusinessWare on IBM AIX operating environment was used as the middleware platform for this solution. Zensar developed the solution using custom connectors, custom transformers and connection models. client’s core services like sequencing, centralized management, error handling and notification were used to improve component-level reusability and cut down development time. Unix’s default scheduler service (crontab) was used for scheduling jobs. This is a real time solution where users no longer need to run applications in batch mode to upload sales order data.

Zensar was responsible for the entire lifecycle of the project. Specific activities included:

• Preparation of the Software Requirement Study (SRS) and the Software Design Specifications (SDS) documents, including proposing the overall solution architecture.
• Construction of the solution, which included development of custom transformers, stored procedures, shell scripts, connection models and the use of appropriate core services.
• Construction and execution of the Unit Test Plan.
• Construction of the Integration Test Plan and assisting business users in integration testing.
• Setting up support guidelines.
  

The resultant reduced the time-to-market thereby having potential savings in cost for future projects via dual-shore delivery model.