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

Vaibhav Gupta
Follow / 17 Aug 2017 at 5:32pm / Toad Data Point
Latest post by on 17 Aug 2017 at 5:46pm

Email Automation : TIC and TDP

Expand content
Hi I am using TDP 4.2 and trying to create an automation. It consist of an Export activity followed with a Set Variable and Send Email activity. Export activity fetches data to an XLSM file and then there...

Hi I am using TDP 4.2  and  trying to create an automation. It consist of an Export activity followed with a Set Variable and Send Email activity.  Export activity fetches data to an XLSM file and then there is a macro that fires up and create an XLSX file with Current date as Suffix. Now during the send email acitivity I want to pick that most recent file but since name of the file changes because of Suffix I can not pick that file. I can use variable for subject line of the email, but not as an attachement.

I have to  eventually publish this script on TIC.

Unanswered 12 1 / Create an account to join the discussion.
Vaibhav Gupta
Follow / 14 Jun 2017 at 7:01am / Toad Data Point
Latest post by on 17 Aug 2017 at 5:17pm

Macros not firing up from scripts published on TIC working fine with...

Expand content
Hi, I have a script that has an export activity followed with a macro, when I run this script from TDP , macro fire up. But when I run the same script after publishing from TIC, it ignores the macro...

Hi,

I have a script that has an export activity followed with a macro,  when I run this script from TDP  , macro fire up. But when I run the same script after publishing from TIC, it ignores the macro and only export happens. I am using TDP 4.2 and TIC 3.3.

Unanswered 246 4 / Create an account to join the discussion.
sbiggs
Follow / 28 Jul 2017 at 2:30pm / Toad Data Point
Latest post by on 29 Jul 2017 at 1:03am

Toad Data Point (V3.3.0.1526)

Expand content
We've been using this version of Toad for several months to run scheduled jobs (.TAS jobs) successfully. This week, for some strange reason, Toad has been running jobs at a time that is not scheduled...

We've been using this version of Toad for several months to run scheduled jobs (.TAS jobs) successfully.  This week, for some strange reason, Toad has been running jobs at a time that is not scheduled. The job is set to run Sunday only at 8Pm in the evening, but we get an email sent every day at 8Am in the morning.  We also get a job set at 6:30AM, and there is not a even a job scheduled for 6:30 am (or pm).

Using Windows 7, SP1

We've done the following to try to solve this:

- Rebooted the PC

- Powered off/on the PC

- verified the jobs do not show in Windows Job Scheduler. What we see in Windows Job scheduler, matches the Toad Job Manager Task list.

Unanswered 88 1 / Create an account to join the discussion.