topic Re: [resolved] Netezza connection error for TOP 4.2.2 in Data Quality

[resolved] Netezza connection error for TOP 4.2.2

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

Hi,
Trying create netezza connection on TOP 4.2.2 and got a driver not found error. Is there a location like TOS lib/java where I can drop the netezza jdbc jar file?

Re: [resolved] Netezza connection error for TOP 4.2.2

Anonymous — Tue, 28 Jun 2011 16:31:35 GMT

I'm not familiar with Netazza, but you can try the following if you have the jdbc driver (I used the procedure a while back when I tried to connect to another database).
- put your driver in the folder /plugins
- open TOP and go into the preference menu (Window->Preferences)
- on the left side under Data Explorer select JDBC Drivers
- in the right window select Netazza and click on Edit
- In the Driver Window click on the "Extra Class Path"
- click on "Add" and point to the /plugins/****.jar file - and the Open
- select the Driver Class Name from the drop down (should be already filled)
- click OK
Hope that helps.

Re: [resolved] Netezza connection error for TOP 4.2.2

Anonymous — Tue, 28 Jun 2011 17:03:36 GMT

Thanks. That works!