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.
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