Batch Automation

Objective

The objective of the Batch Automation software is to allow either a development or operations staff to start, stop, pause, monitor and restart batch streams more efficiently. The ability for a staff to know the status of any processing run is paramount to current production systems especially for Data Warehouse and Data Mart load processes which generally refresh data on a daily basis.

Architecture

Batch Automation and all associated Programs, subroutines and non-gui menus were developed using UniVerse BASIC. Batch Automation, is designed to be run outside of the DataStage runtime environment, allowing for greater control over dissimilar processes that can process during any given run. Batch Automation integrates with DataStage by relying on the known published DataStage API supplied by Ascential Software Corporation.

Product Functionality

  • Can be integrated with Control-M for macro scheduling
  • Group like jobs into batches, thereby reducing number of jobs in any given batch, thereby increasing the number of batches
  • Enhance automation reporting
  • Define control points
  • Define nature of checkpoints
  • Ability to start, pause and stop batch stream
  • Ability to interface with an external data source i.e., Oracle or SQL Server
  • Utilize one (1) parameter file for control of batches