How to comment out clauses in the Toad Data Point query builder
How to comment out clauses in the Toad Data Point query builder
This video demonstrates how to comment out clauses in the Toad Data Point query builder....
Changes in Toad Data Point user interface
Changes in Toad Data Point user interface
This video demonstrates the various user interface changes in Toad Data Point....
How to use automation best practices in Toad Data Point
How to use automation best practices in Toad Data Point
This video shows how to use automation best practices in Toad Data Point....
How to use automation scripts in Toad Data Point
How to use automation scripts in Toad Data Point
Learn how to use automation scripts in Toad Data Point....
Toad Data Point Automation Series Blog #16 – Automation on Toad Intelligence Central
Toad Data Point Automation Series Blog #16 – Automation on Toad Intelligence Central
Hello, I wanted to talk to you today about where to install and use Toad Data Point automation scripts. Currently we have three ways: On your pc, on a server, and with Toad Intelligence Central. Toad ...
Toad Data Point Automation Series Blog #15 – Email Activity
Toad Data Point Automation Series Blog #15 – Email Activity
The email activity in Automation is a very important activity. Most automation scripts end with an email deploying a report or confirmation that the script is complete. To start using Email you ...
Toad Data Point Automation Series Blog #14 – For each row Do….(Loop dataset Activity)
Toad Data Point Automation Series Blog #14 – For each row Do….(Loop dataset Activity)
As shown in other videos, variables can be very useful in automation. In this video let’s discuss how to use variables with the LoopDataset activity. This activity allows you to take a result set and ...
Toad Data Point Automation Series Blog #13 – Variables in exception reporting
Toad Data Point Automation Series Blog #13 – Variables in exception reporting
Not all reports are repetitive. Perhaps you have a situation where you only want to produce a report when a set of circumstances arise. Here is a simple example. Clerks enter orders and at the e...
Toad Data Point Automation Series : Blog #12 – Variables
Toad Data Point Automation Series : Blog #12 – Variables
In Toad for Data Analysts 2.5 Automation Variables were added which greatly expanded what you could accomplish in an automation script. Variables can be used in almost every activity. What is a v...
Toad Data Point Automation Series : Blog #11 – Toad Editor Files (*.tef)
Toad Data Point Automation Series : Blog #11 – Toad Editor Files (*.tef)
Many Toad Data Point users like to use the Toad Editor. It is very flexible for free handing SQL and scripts. But did you know that you can save your result sets to a file? The file extension for this...
Toad Data Point Automation Series Blog #10 – Zip Files
Toad Data Point Automation Series Blog #10 – Zip Files
Most automation scripts produce some kind of output, such as an Excel report, and these need to be distributed to end users or storage locations. When there are many such reports you might want to zip...
Toad Data Point Automation Series: Blog #9 – Execute Script
Toad Data Point Automation Series: Blog #9 – Execute Script
The most common automation activates are exporting and importing data. There are times when some database set up is needed. This can be done with the Execute Script activity. For example, I have ...