Integrate IBM Netezza Performance Server (formerly PureData) with ActiveBatch

Automate and Integrate End-to-End Netezza Processes

ActiveBatch Workload Automation and Enterprise Job Scheduler has a demonstrated track record in leveraging our customer’s requirements for improved BI performance by removing complexity and shortening the time to implementation by integrating and managing key resources in their Data Warehousing environments including database appliances such as those offered by Netezza Corporation.

The ActiveBatch Integrated Jobs Library provides production-ready Netezza Job Steps designed specifically to eliminate the need for command line use and/or expensive scripting. ActiveBatch users can automate and integrate critical processes performed by Netezza including:

• NzLoadData for loading data into the Netezza appliance;
• NZ-PLSQL Block to execute SQL queries in the Netezza SQL language;
• NZBackup for database backups.

In addition, the ActiveBatch Execution Agent can be installed directly on the Netezza host to support direct access to all Netezza operations.

ActiveBatch’s advanced enterprise job scheduling and workload automation core capabilities including alerting, monitoring, audits, constraints and much more have proven to improve the quality and reliability of the data from upstream business processes that Netezza processes are dependent upon. The result is improved data quality presented to the Netezza system for processing. The ActiveBatch Extension for Netezza within the Integrated Jobs Library is separately licensed.

Netezza, a leader in data warehouse appliances, combines storage, processing, database and analytics into a single high-performance system. Led by its TwinFin™ line of data warehouse appliances, Netezza offers purpose-built systems that solve business problems quickly and easily for a wide range of clients.