Netezza supports JDBC, ODBC and OLEDB connectors. There are many free and paid Netezza query tool available in market. There most popular Netezza query tool includes Aginity workbench, WinSQL, SQuirrel SQL Client tool etc.
Aginity Workbench
Aginity Workbench is free, most popular and an easy-to-use application that enhances your performance when you are working with your Netezza data warehouse. If anybody think of Netezza query tool then first thing comes to their mind is Aginity workbench. This SQL database development tool offers unique capabilities that allow you to focus on MPP databases. The Aginity workbench application provides a powerful set of GUI-based tools for Developers, DBAs, and Data Analysts to maximize the productivity of users in these roles.
The Aginity workbench is packed with many features that helps developers and administrator to manage the Netezza server easily. You can perform the various advanced tasks such as import data from excel files, perform reverse engineering, and difference between two schemas. It also supports the migrating the DDL from other RDBMS such as oracle, DB2, SQL Server, Exasol, Greenplum etc.
WinSQL
WinSQL is the one of the best Netezza query tool utility available. This utility is designed to interact with the many different types of databases like Netezza, Oracle, and SQL Server etc. This tool uses the Netezza ODBC driver to connect to Netezza server. You have to install the Netezza ODBC, OLEDB or JDBC drivers explicitly downloading from IBM fix central.
WinSQL comes with many features that help developers and technical staffs. You can also perform the advanced tasks such as data export, test data generation and check different schema differences
You can download the WinSQL utility from the official website – Download
SQuirrel SQL Client
SQuirrel SQL client tool is a single, simple and free front end application that you can use to interact with the many databases. This tool uses JDBC connectivity; you can connect to any server that supports the JDBC connection.
SQuirreL SQL Client is a program written in Java that allows you to view the contents of a database, issue SQL commands, and as you will see, perform a number of other functions. The graphical front end is built to support JDBC-compliant databases. This tools provides the unique features such as you can generate charts showing table relationships,
SQuirreL supports simultaneous sessions with multiple databases. This allows comparing data and sharing SQL statements between databases
You can download and configure the Squirrel SQL client tool from the official website – Download