Netezza SQL Client Tool
DBHawk provides web-based SQL client tool for IBM Netezza Database.
Netezza is a data warehouse appliance from IBM. It provides MPP (Massively Parallel Processing) data processing. It’s been used by many companies to analyze and process big data with fast performance. It does this faster processing with an array of S-Blades.
DBHawk supports major Netezza database features including browsing and querying database tables data, applying a various filter, insert, update, delete the data. DBHawk Netezza SQL Editor allows to run SQL Queries, create database reports, create data charts.
Netezza System Catalog views
Netezza performance server system has many system catalog views. These system catalog views help to information about the users, tables, indexes, functions etc. DBHawk provides data browsers for all these system catalog views. A user can click and view details.
DBHawk Netezza Procedure Feature
DBHawk provides Procedure view for Netezza. It allows users to modify existing Procedure, and save SQL.
Netezza SQL Query Builder
DBHawk Netezza SQL Query builder provides drag and drops way to build SQL Queries. Users can drag tables to the query builder and DBHawk automatically builds queries.
Netezza Report Builder and Job Scheduler
A user can build parameterized report, group by report, summary report and save it in PDF, XLS, XLSX formats. After creating reports, users can schedule a job to run created reports at regular interval. This is a very handy feature for power SQL users, who needs to run queries and receives reports by emails very often.
How to connect to Netezza using JDBC driver
DBHawk does not include Netezza JDBC driver. Copy Netezza JDBC driver(nzjdbc.jar) to \webapps\dbhawk\WEB-INF\lib directory.
Choose “GENERIC” database type from a drop-down list
Enter driver class as org.netezza.Driver
Enter JDBC URL.
By default all Netezza connections are auto-committed. All transactions are automatically committed to the database.