Thanks very much Filip for your information.
There is one feature of Aginity WorkBench that is very specific to the Netezza architecture that probably is not in Toad Data Point. And that is the ability to right-click on a table and select ‘Show Distribution’ and ‘Show Storage’.
These show us how well our data is distributed over the 960 SPU’s we have.
By chance, does Toad Data Point give this information?
From: Filip Cevela bounce-FilipCevela@toadworld.com
Sent: Monday, July 2, 2018 7:39 AM
Subject: RE: [Toad Data Point - Discussion Forum] Using Netezza 7.2 with Toad Data Point
RE: Using Netezza 7.2 with Toad Data Point
Reply by Filip Cevela
Main difference between native and ODBC are that there should miss some advanced features and implementations (some advanced work with transactions etc.). All this features are really depend on provider. You can see all detailed information on IBM sites
here (section for ODBC and compare with ADO or JDBC).
I believe that with Netezza ODBC driver we can provide you lot of needed information and you won’t be limited (you don’t need to write any select statements). We have Object Explorer where you can easily find DB objects on all Databases you have on your servers. On Object Detail you can see all your data, information about object and some kind of relationships (Indexes, FK, PK, Privileges etc).
You can also work with our advanced tool in TDP with Netezza. You can prepare your query in Editor or Query Builder, you can easily transform your data or do Data Compare with any other provider you have. There are lot useful tool so give a try
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad Data Point Forum notifications altogether.
Toad Data Point - Discussion Forum
this post as spam/abuse.