SQuirreL SQL Client - for netezza on window/linux,mac

SQuirreL SQL Client

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. The minimum version of Java supported is 1.6.x as of SQuirreL version 3.0.
SQuirreL's functionality can be extended through the use of plugins.

My client having issue connecting netezza on mac using any sql client tool. He was forced to use "Parallels" to install window client tool to connect to netezza.

SQuirreL SQL Client  is java based tool ,which could be installed on any OS , including mac, window, linux etc.

Download and Install client -

• Go to http://squirrel-sql.sourceforge.net/
• Download required installer
• Follow  steps to install Squirrel client. You need to follow step by step wizard. Its very simple.

After installing SQuirreL tool, first step is to configure it for netezza. 
Below the steps to configure this tool -

Create new Driver for Netezza

You will find “Aliases” & “Drivers” tabs on left pan. Click on “Drivers” tab -> Click on “+” icon to add new Drivers.

Drivers

• Name : Give some user friendly name
• Example URL: jdbc:netezza://hostname or ip address:5480/databasename
• Website URL : jdbc:netezza:// hostname or ip address:5480/databasename 
• Extra Class Path : Click on “Add” to browse the netezza jar file. If you don't have netezza jdbc driver (jar file), you can dowload it from IBM.
• Class Name : org.netezza.Driver

Click OK

Once you configured and created driver, its time to create/configure alias.

• Click on “Aliases” tab on left pan
• Click on “+” icon to add new aliases. 
• Add Alias window will open.
• Name : Pass user friendly name
• Drivers : Select you drivers, which you have created in previous step
• URL : jdbc:netezza://hostname or ip address:5480/database name
• User name : Your Netezza User name
• Password : Your netezza password
• Click on “Test” to test the connection

• Once test connection successful , now its time to run your query
• Select your netezza Aliases name.
• Click on “Connect to Selected Alias (Control O)” icon 
• Now to to “SQL” tab and run you query 

Thanks & Good luck. Post me question, in case you have any problem configuring this tool.