Business scenario

A retail company has many shops around the world. Each shop has its own local database which stores daily transactions and tracks the number of articles left in its store. The central business division of the company needs to analyze every morning all the reports that show the number of articles sold in every country, grouped by predefined categories.

The company collects this data by using IBM InfoSphere DataStage. The company runs IBM InfoSphere DataStage jobs overnight to collect data from the local database of each store and then, using the procedures stored in the central database, produces the aggregated data to create the business reports. The process that runs the IBM InfoSphere DataStage jobs overnight is performed manually by an operator. To reduce costs and to ensure that the SLA requirement of having data available every morning is satisfied, the company wants to automate this process.

Using HCL Workload Automation plug-in for IBM InfoSphere DataStage, the company can satisfy this objective because the product helps it to automate and control the entire process.