The need for business intelligence analytics means organizations have to speed up their orchestration of data in the data warehouse while scaling the process to growing volumes of data and all the while maintaining data quality and reducing the potential for errors. No matter how complex your business processes are the IBM® Workload Scheduler Plug-in for Netezza® can define a successful data management strategy with Workload Scheduler.

Installing the plug-in for Netezza Performance Server in a Tivoli Workload Scheduler environment, you can define, schedule, and monitor Tivoli Workload Scheduler jobs that perform Netezza bulk data loading operations. You can condition the load of data upon successful execution of preliminary manipulation or delay data loading until the latest updates have been included.

Business scenario

A large financial company runs its business every day in many different countries. To succeed, the company manages and processes data from databases with hundreds of billions of rows and hundreds of terabytes. Their database management is based on a Netezza Performance Server appliance solution, which allows data warehouse appliance to architecturally integrate database, servers and storage components into a single unit. The big data amount managed by the company is extremely important to analyze the historical trend of the financial operation and to perform specific actions in the financial market.

The process that loads historical trend data to the Netezza database occurs overnight and is performed manually by an operator. To reduce costs and to ensure that the SLA requirement of having up-to-date trend data available every morning is satisfied, the company wants to automate this process. Using IBM Tivoli Workload Scheduler Plug-in for Netezza Performance Server, the company can satisfy this objective because the process of bulk data loading can be automated and controlled.