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

ben9
Follow / 16 Oct 2017 at 8:21pm / Toad Data Point

Change program icon

Expand content
Hi I run both Toad for SQL server and Toad for Data Point. Both have the same icon on the taskbar. It is a little confusing so if it's possible I want to make them different. I tried but couldn't...

Hi I run both Toad for SQL server and Toad for Data Point. Both have the same icon on the taskbar. It is a little confusing so if it's possible I want to make them different.

I tried but couldn't change the icon. Does anyone know how to?

thanks,

Ben

31 0 / Create an account to join the 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 129 1 / Create an account to join the discussion.
mercier104_000
Follow / 12 Jan 2017 at 4:29pm / Toad Data Point
Latest post by on 16 Oct 2017 at 6:54pm

If condition in automation script is not working properly (TDP 4.1...

Expand content
As i say in object, TDP return an error with condition . that's veryr strange ! condition worked in TDP 3.8. error message is : Exception Messages: If_1 - ''False'' cannot be converted...

As i say in object, TDP return an error with condition . that's veryr strange ! condition worked in TDP 3.8.

error message is :

Exception Messages:
If_1 - ''False'' cannot be converted to boolean.

When using Test button in activity, it' working !

Toad seems to quote every variables including its own !

Any workaround ?

Franck 

718 4 / Create an account to join the discussion.