Aginity is a Netezza Solution Provider partner. The Workbench was born out of our need for specific tools to support our extensive experience developing large systems on the Netezza appliance. Workbench offers features unique among other similar products, including: + One-click access to distribution information, including unclaimed, deleted records, and the graphic display provides easy visualization of where problems exist on a node-by-node basis. + Reclaim functionality allowing developers to truly recover server space occupied by deleted records and free up storage space for other uses. + Additional DDL enabling developers to view and alter table and add field comments. Users also can compare varying database schemas -- including data dictionaries -- for differences and generate delta scripts. Most of these DDL functions are menu driven for greater efficiency. + Reverse engineering capability that allows developers to generate DDL scripts from an existing Netezza databases. In addition to its industry-leading capabilities, the Aginity Netezza Workbench also includes functionality no such offering can be without, including: + Freeform SQL + One-click scripting for database objects using a SQL editor or Windows clipboard . + List display of internal and external tables and management views + Query execution from a SQL file, similar to standard IDE-like Start/Stop/Pause/Restart, Step + Over and Run to Cursor.
Full Specifications
What's new in version 4.1
Release 4.1
Added a command line switch for turning processing of SQL parameters off in unattended mode
Implemented email notifications in unattended mode
Added more internal parameters for Workbench
Implemented setting parameter values in SQL
Added Open in Microsoft Excel context menu to the results grid
Added a function for scripting the table content as a series of INSERT statements
Added support for schema (NPS 7.0.3 and newer)
Implemented single-row results view
Fixed row-secure tables not showing up in the object tree
Release 4.0
NPS 7 certification
NPS 7 specific enhancements
Change expired password
Database grouping in the object tree
StreamAppendNode in query plans
Workbench internal parameters for query text
SQL parameters in unattended (command line) mode
Execution logging (Query / Execute with Trace)
SQL auto-complete in all windows
UI editor for building Workbench command line
Load testing functionality with visual performance reporting
General
ReleaseMay 16, 2013
Date AddedMay 16, 2013
Version4.1
Operating Systems
Operating SystemsWindows 2003, Windows 8, Windows Vista, Windows, Windows 7, Windows XP