Chat now with support
Chat with Support

Toad Data Studio 1.1 - 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.
  • 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:

  

Related Topics

Use System Automation Activities

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating