Answer

AnySQL Maestro is a multi-purpose administration tool for database management, control and development. Key features include the following:

• Support of any database engine (SQL Server, MySQL, Access, etc.)
• Database Designer
• Data management: editing, grouping, sorting and filtering abilities
• SQL Editor with code folding and multi-threading
• Visual Query Builder
• Data export/import to/from the most popular formats

Environment:
AnySQL Maestro 9.8.0.2
NPS 4.6.5
Netezza ODBC driver 4.6.5
Windows XP Professional

You can download or purchase a version of AnySQL Maestro at the following site:
http://www.sqlmaestro.com/products/anysql/maestro/

1. Install the Netezza ODBC driver as described in the NPS ODBC, JDBC and OLE DB Installation and Configuration Guide.

2. Launch AnySQL Maestro and then on the Database menu, click Create Database Profile.



3. On the Create Database Profiles page, select localhost from the Database group drop-down list.
    For the connection string, click the ellipses (...) to the right of the field.



4. Click on the Connection tab and select NZSQL from the Use data source name drop-down list. Enter information in the user name andpassword fields. Then select system as the initial catalog and click OK.



5. After the wizard populates your connection string, click Next.



6. You can assign the database an alias and specify options for the profile. Click Ready.



In the explorer window, your newly created database profile appears.



7. Double-click the database profile name and the connection to the Netezza database will occur.



After you are connected to the Netezza database, you can explore the AnySQL Maestro functionality.



In the following view of the data in the all_sales table, you can drag a column header to group the data by that column.



The following SQL Editor window shows a basic select statement.  You can write your query and then hit the Execute Query button on the left hand side to execute it.



You can take advantage of AnySQL Maestro's versatility in managing the data in your Netezza database.