Netezza SQL Client Web-Based
DBHawk provides web-based SQL tool for IBM Netezza Database.
Using DBHawk, Netezza SQL developers can browse database schema, run SQL queries, build SQL Queries using SQL Query Builder, Generate SQL script, create SQL reports and schedule reports to receive results by email.
Netezza Data Browser
DBHawk supports Netezza database browsing feature. Users can view database table data, filter data, count total number of rows in a table.
Netezza Data Editor
DBHawk online data editor allows to create, insert, update, and delete data. Users can also update clob, blob data.
Netezza Table Data Filter
DBHawk provides advanced database filter on the table and view data. With simple clicks, users can apply table data where condition and order by conditions to filter table and view data.
Netezza Export/Import Data
DBHawk online export data feature allows to export table data into csv, html, insert and pdf formats.
Users can also import csv data directly to the tables. DBHawk parse input csv data columns and display column mappings between table columns and uploaded CSV file data columns. After successful import, users can save import as a job and schedule it to run at regular interval.
Netezza Table Columns
Using DBHawk, users can view Netezza table column details.
Using DBHawk, users can view table constraints details. It displays Constraint name, Type, Constraint columns.
Netezza Table DDL Generator
DBHawk display table DDL with a simple click. User can generate Table SQL and save SQL.
Netezza View Manager
Using DBHawk, users can browse view data, filter data, count total rows in a view, get SQL for the view definition, export view data in a various formats such as PDF, CSV and HTML.
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. User can click and view details.
Netezza Procedure with DBHawk
Users can view database Procedure details, modify existing Procedure, and save SQL.
Users can view sequence details.
Netezza SQL Editor & History Viewer
Using DBHawk web-based SQL Editor, users can executes SQL queries online. It also Formats SQL queries, enables to View SQL query history.
Netezza SQL Query Builder
DBHawk Visual SQL Query builder is supported with Netezza . Users can build SQL Queries by simply dragging and dropping database tables from a schema browser to the SQL query builder. With data preview window, users can view data as they build SQL Queries.
Netezza Report Builder
DBHawk provides ad-hoc SQL report building capabilities. User can build parameterized report, group by report, summary report and save it in PDF, XLS, XLSX formats.
Netezza web-based job scheduler
DBHawk provides SQL Job Scheduling feature. Using DBHawk Job Scheduler, users can schedule reports, or SQL statement to to receive results by email or save on the disk
Netezza Data Charts and Dashboards
Using DBHawk, users can create various charts, create dashboards and share created charts/dashboards with other users.