Toad Data Point 6.2 - User Guide

Automation Tutorial and Guided Tour

The Automation Tutorial (Guided Tour) is a helpful wizard that guides you through the process of creating one of several different simple Automation scripts. You can use this wizard to quickly create a basic script, and then use the script as is, or you can further customize and expand the script after it opens in the Automation window.

For beginners, the Automation Guided Tour is a great way to learn the Automation script building process. The wizard explains the process as it guides you through each step. In addition, the wizard provides sample SQL in some cases, which can be used with the Toad Sample Database.

You can use the Automation Guided Tour to build an Automation script that performs one of the following common tasks:

• Export Data and Email—Executes a query and saves the data to a file. It then emails the file as an attachment.
• Execute Script—Executes a SQL script and exports the results to Local Storage or Toad Intelligence Central.
• Import Wizard—Imports data using an Import Wizard template. You can select an existing template or build a new one.
• Exception Reporting—Queries a database for bad data based on criteria you specify. If bad data exists, it creates and emails an exception report. Use the sample SQL or provide your own.
• Loop Dataset—Uses the Loop Dataset activity to loop through a dataset and perform activities. The default script selects a list of departments and then exports data for each department to an Excel^® file. Use the sample SQL provided or provide your own.

Note: The Automation module is disabled if Toad was installed with the Prohibit saving passwords option selected.

To use the Automation Guided Tour

1. Launch the Automation Guided Tour using one of these methods:
   • Select Tools | Automation Tutorial.
   • Click in the Query Builder, or Editor toolbar.
   • Click the Send to Automation button in the Wizard bar.
2. Read and complete each page in the guided wizard.

   • If you are using the wizard as a tutorial, some sample SQL statements are provided and are designed to be used with a Toad Sample Database connection.

     Note: The items provided by the wizard are listed on the introduction page with a beside them.

   • If you are using the wizard to create your own script, you can delete the sample SQL when it is provided in the wizard and enter your own SQL.

Tip: You can also launch the Automation Guided Tour from the last page in the Import Wizard.

More Tutorials

You can learn more about automating the same tasks presented in the Automation wizard through written and video tutorials. See the following:

• Automate Exporting to Excel Reports
• Automation and Executing Scripts
• Automation and Importing Data
• Automate Exception Reporting
• Using Loop Dataset Activity

Related Topics

Automate Tasks

Use Database Automation Activities

Use System Automation Activities