Using Netezza 7.2 with Toad Data Point

Toad Data Point & Toad Intelligence Central
1

Hi,

I am interested in my company doing a test of the Toad Data Point software for access to Netezza 7.2. We have previously been using Aginity Workbench.

I read the release notes for Toad Data Point 4.3 (http://dev.toadfordataanalyst.com/releasenotes/latest/ToadDataPoint_ReleaseNotes.htm).

These notes have this to say that applies to Netezza:

“ODBC connectivity provides basic querying capability, but may not be as full-featured as a native connection in Toad.”

Can anyone using Toad Data Point (TDP) against Netezza explain for me what features of TDP DO NOT work against Netezza? Are they show-stoppers?

The thing I miss the most about Toad (against Oracle) that Aginity Workbench/Netezza does not have is the ability to view table data without writing select statements. Does TDP/Netezza allow this?

Does TDP easily handle the multiple “databases” that are in my Aginity Workbench Object Browser?

Thanks,

Troy

2

Hi Troy,

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 :slight_smile:

Filip

3

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?

Thanks,

Troy

From: Filip Cevela bounce-FilipCevela@toadworld.com

Sent: Monday, July 2, 2018 7:39 AM

To: toaddatapoint@toadworld.com

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

Hi Troy,

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 :slight_smile:

Filip

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point Forum notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.

4

All features/windows are support for Netezza. What we have not done is written Netezza specific support such as Show Distribution or Storage as Troy mentions above.