The Aginity Workbench for Netezza is a free software tool that provides basic database querying along with advanced features that help server administrators and developers harness the power of Netezza.
Here is a basic structure of the Aginity Workbench for Netezza help.
Main Window
Describes main window of the program and layout of its components, such as: Object Browser, Query Analyzer, Result Set, etc.
Menu Bar
Describes all drop-down menus which provide easy working experience with the Workbench.
Below is the list of most common features you can access via Menu Bar:
- Define Autosizing Behavior for Rows and Columns
- Expand and Collapse Code in SQL Editor
- Create Bookmarks in SQL Editor
- Manage Code Snippets
- Use Parameters Substitution
- View Database Space
- Upload Data from Different Sources
- Compare DB Schemas
- Analyze DB Schema
- Run Each Query in Debug Mode - SQL Dump Runner (video)
- Generate DDL Script and Migrate a Database From Different Platforms to Netezza
- Compare Stored Procedures' Content with an External File Diff Tool
- Modify Visual Appearance of Query Analyzer Window and DB Selector
Command Line Interface
Describes Command line execution that enables using workbench in place of nzsql on a Windows machine.