topic Re: Caanot connect to netezza in Data Quality

Caanot connect to netezza

Anonymous — Sat, 16 Nov 2024 12:45:50 GMT

I am trying to connect to a Netezza database. looking on other forums i found that I needed to obtain the netezza driver nzjdbc.jar and copy it to a specific location
i have installed the netezza driver in program files\java\jdk1.7.0\jre\lib
but I am still getting Driver not found: org.netezza.Driver errors
I guess I am missing something. Please can you help?
Thanks

Re: Caanot connect to netezza

Anonymous — Wed, 03 Aug 2011 10:12:41 GMT

Hi there,
Sounds like you have the appropriate JDBC driver, but you need to deploy it where Talend can see it rather than inside the JDK. There is a link below to a post where another user had the same question: can you try these steps and let us know how you get on?
https://community.talend.com/t5/Data-Quality-Preparation-and/resolved-Netezza-connection-error-for-TOP-4-2-2/td-p/94985

Re: Caanot connect to netezza

Anonymous — Wed, 03 Aug 2011 16:46:51 GMT

I can now connect to the Netezza database but when I tried to do a statistical analysis on a single column, I got an error - At least one analysis execution failed, check the error logs for more details.
I have included the entries in the log from when I tried to run the analyse below
Please can you help?
Thanks
Tracey

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:00.557
!MESSAGE 2011-08-03 16:36:00,557 INFO org.talend.dq.analysis.AnalysisExecutor - Connection tojdbc:netezza://10.156.11.205:5480/COBAL_ODS_DEV

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:14.760
!MESSAGE 2011-08-03 16:36:14,760 INFO org.talend.cwm.management.connection.DatabaseContentRetriever - Database Product Name:Netezza NPS

!ENTRY org.talend.platform.logging 1 0 2011-08-03 16:36:14.760 !MESSAGE 2011-08-03 16:36:14,760 INFO org.talend.cwm.management.connection.DatabaseContentRetriever - Database Product

To see the whole post, download it here
OriginalPost.pdf

Re: Caanot connect to netezza

Anonymous — Fri, 05 Aug 2011 11:07:34 GMT

Hi,
Your original question (How do I...?) was quite correctly posted on the forum. It looks to me like this second issue isn't something you've done - it's an error.
In that situation, you can post on our bugtracker - but I see that someone has already encountered this, and a fix is currently scheduled for 4.2.3. The issue is reported here: http://jira.talendforge.org/browse/TDQ-1693
You are still welcome to raise an issue for it if you wish - it will be marked as a duplicate of the original, and enables us to track that more than one user is affected by the issue.
hope this helps

Re: Caanot connect to netezza

Anonymous — Fri, 05 Aug 2011 11:29:56 GMT

Thanks, I will wait for 4.2.3. Any idea when this will be delivered, please?