Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2011-08-02 12:36 PM

Caanot connect to netezza

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
Labels (2)
Labels
364 Views
0 Likes
4 Replies
Anonymous
Not applicable
‎2011-08-03 06:12 AM
Author

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-T...
364 Views
0 Likes
Anonymous
Not applicable
‎2011-08-03 12:46 PM
Author

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
364 Views
0 Likes
Anonymous
Not applicable
‎2011-08-05 07:07 AM
Author

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
364 Views
0 Likes
Anonymous
Not applicable
‎2011-08-05 07:29 AM
Author

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