I am doing some research into our connectivity with Netezza. If you are using Toad Data Point with Netezza and can spare a few minutes to write me an email providing feedback on your experiences? Or if you would prefer and you and have the time, I can schedule a quick call and get your feedback on the phone. Just email me at julie.hyman@quest.com. I can even send you a free Toad T-shirt [:)]
I just downloaded the trial to test this use case out. I’m also testing SQuirreL, Aginity Workbench for Netezza, and WinSQL.
SQuirreL has a Netezza specific plug-in and uses JDBC. Aginity is built for Netezza and uses ODBC. WinSQL is an all-purpose client that uses ODBC. I haven’t run into any glaring flaws with any of the clients yet.
We found that some ODBC connections did not support multi-threading so we added a feature to disable multi-threading. In TDP 4.0 multi-threading is turned off by default. Turn this back on and see if that gives you better performance. The option is on the Advanced tab of the connection.