Cisco Tidal Enterprise Adapter for Netezza

Automate Netezza Job Scheduling

Improve Netezza job scheduling with the Cisco Tidal Enterprise Adapter for Netezza. This software option works with Cisco Tidal Enterprise Scheduler to simplify job scheduling and automate execution for Netezza ETL (extract, transform, and load) processes. It also helps simplify jobs that advance other processes.

Reduce Errors and Improve Business Intelligence

This cross-platform, cross-application enterprise scheduling solution provides broad coverage. It is superior to point tools because it helps you easily factor dependencies into Netezza ETL schedules. This feature:

• Reduces errors
• Enhances business intelligence (BI)
• Improves supporting IT operations

For example, this solution guides upstream processes correctly before dependent Netezza jobs are triggered. Accurate data is then delivered downstream to the BI system.

You can define and automate jobs not only for Netezza ETL, but also for other workflows that affect:

• Report generation
• Data cube analytics
• Online Analytical Processing (OLAP)

Use a Solution Built Just for Netezza

Java Database Connectivity (JDBC) advances this adapter. JDBC makes calls to the Netezza SQL database, helping you use standard job definition dialog screens to schedule Netezza jobs (Figure 1). It makes full use of:

• Job, file, and variable dependencies
• Calendars
• Events
• Monitoring
• Error notifications

This software also provides detailed runtime error detection, alerts, and automated remediation.

Click to Enlarge

Figure 1 View and Manage Netezza Stored Procedures and SQL Statements for Easy Netezza Job Scheduling

This Netezza job scheduling solution also includes:

• Standardized job definition and management
• Scriptless scheduling
• Event-led processing
• Flexible monitoring and alerting of errors and potential errors