Get more from Toad Data Point...

with onsite training

Toad™ Data Point is a multi-platform data preparation tool that’s built for anyone who needs to access data from multiple sources, quickly integrate and prepare data to produce datasets and reports for analysis. It dramatically simplifies data access, writing SQL queries and data preparation – all from a single tool and without needing to be a SQL expert. With Toad, you can:

  • Access almost any source from a single tool
  • Visually drag and drop to create SQL queries
  • Profile, transform and cleanse data easily
  • Automate frequent reporting tasks

Toad Data Point v4.2 is now available 

Check out what's new!

Use these links below to learn more about the most popular Toad Data Point topics!


Getting Started



Mastering
Connectivity

Writing
Queries

Import/Export


Automation

Community Discussion

andy.corson
Follow / 21 Sep 2017 at 12:53pm / Toad Data Point
Latest post by on 16 Oct 2017 at 7:23pm

Data compare for specific tables/columns in database

Expand content
I have used data compare with Excel data connections before and it works great. I tried to do one on a database yesterday, and after the compare wizard analyzed the databases, it displayed a list of tables...

I have used data compare with Excel data connections before and it works great. I tried to do one on a database yesterday, and after the compare wizard analyzed the databases, it displayed a list of tables. I want to select only a handful of the tables, and choose which columns to compare. Is this possible? Or do I have to construct select statements choosing the tables and columns, export the data to Excel, and then use Excel data connections? I didn't want to have to create a bunch of Excel connections, which is why I went the database route.

Unanswered 117 1 / Create an account to join the discussion.
Kris.Kawaguchi
Follow / 22 Sep 2017 at 2:00am / Toad Data Point
Latest post by on 16 Oct 2017 at 6:12pm

Transpose Table Data for Comparison

Expand content
Is there an efficient approach to transpose a given table so that it results in the following: Primary Key | Field | Value 1 Field 1 Value 1 Field 2 Value 1 Field 3 Value 2 Field 1 Value ...

Is there an efficient approach to transpose a given table so that it results in the following:

Primary Key |    Field     |  Value

1                      Field 1       Value

1                      Field 2      Value 

1                      Field 3       Value

2                      Field 1       Value

2                      Field 2      Value 

2                      Field 3       Value

I would like to be able to do this for 2 or more similar tables and then join them back by primary key and Field in order to compare there values.

Unanswered 73 1 / Create an account to join the discussion.
marcia.m
Follow / 2 Oct 2017 at 9:31pm / Toad Data Point
Latest post by on 11 Oct 2017 at 4:12am

Upgrade path from Toad Data Point 3.8 32-bit to TDP 4.2 64-bit with...

Expand content
We're trying to determine the best upgrade path from TDP 3.8 32-bit, to TSP 4.2 64-bit, while keeping the user's settings as they were. I personally do not have control over the installer, it...

We're trying to determine the best upgrade path from TDP 3.8 32-bit,  to TSP 4.2 64-bit, while keeping the user's settings as they were.


I personally do not have control over the installer,  it is done via MSI, and executed by our packaging group guy, for rollout to many machines in enterprise. I am testing it now, and hitting some issues.

1. If he installs 4.2 64-bit,  it is not recognized as an upgrade, and so none of my prior settings are migrated (connections, UI settings , etc.)      We've tried manually forcing it, but still nothing is migrated. 
2. If he installs 4.2 32-bit, then I get the migration popups and warnings, as expected,and my customizations are brought over.

Is going from 3.8 32-bit  to  4.2 64-bit a  valid  migration path?

If not, is there any recommended best practice for how to end up at 4.2 64-bit while keeping my 3.8 settings?   That's what we need to do, but can't see how yet. 

Thanks!

Unanswered 206 12 / Create an account to join the discussion.