Connection to Netezza from Talend Studio for DI

[Anonymous]

I am unable to create a connection to Netezza. I am using Talend 7.3 and have Java 1.8 installed on my machine. I get this java error when i test the connection:

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: org.netezza.error.NzSQLException: netezza.con.refused
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:208)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1146)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4208)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.netezza.error.NzSQLException: netezza.con.refused
at org.netezza.sql.NzConnection.initSocket(NzConnection.java:2877)
at org.netezza.sql.NzConnection.open(NzConnection.java:293)
at org.netezza.datasource.NzDatasource.getConnection(NzDatasource.java:719)
at org.netezza.datasource.NzDatasource.getConnection(NzDatasource.java:706)
at org.netezza.Driver.connect(Driver.java:155)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:199)
... 9 more

[manodwhb]

Check the below for the same case.

https://community.talend.com/t5/Design-and-Development/resolved-Cannot-connect-using-Netezza-driver/...

[Anonymous]

Hi Manohar,

Thanks for the reply. I saw they thread and have copied the driver jar to root/lib/java folder. I am still unable to connect through both netezza as well as jdbc connection. Am I doing something wrong?

[Anonymous · Accepted solution]

FWIW, TOS v7.3.1 does not work with Netezza driver v7.2.1.8. I used Netezza driver v7.0.4.4 and was able to setup the connection. No need to create a root/lib/java folder either. What a pita.