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 remaining in stock. The central business division of the company every morning needs to analyze 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 and creates the reports using IBM Cognos. Overnight, the company runs the following processes:
  • IBM InfoSphere DataStage jobs to collect data from the local database of each store and then, using the procedures stored in the central database, to produce the aggregated data to create the business reports.
  • IBM Cognos jobs to create the business reports to be used by the business analysts.
Both processes are 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 the entire process.

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