What is the AppDesigner? (4242218)

What is the AppDesigner that  is introduced in Toad 9.7 replacing the Action Palette?

For more detailed information, please refer to the Toad Help file - search for AppDesigner.

AppDesigner Overview

You can use AppDesigner to automate and control processes you perform regularly. Connection information, window settings, and queries can be saved, shared, scheduled and run from the command line or batch files to simplify repetitive tasks.

The AppDesigner makes use of several categories to control Toad. These include:

--Action - An piece of Toad functionality encapsulated for the purpose of executing, scheduling, sharing and building Apps.

--App - One or more Actions designed to work together as a mini Toad application.

--Scheduled Item - An app or action that has been scheduled using the Windows Task Manager.

--Execution Log - A log file containing the execution status of recently-run apps. It is automatically generated as you run actions, and contains data up to 7MB. When it reaches 7MB, old data is trimmed back to 5MB, and then it continues accruing.   In this way it remains a current log of the most recent action execution.

To access the AppDesigner

The AppDesigner is the central location for running and creating Actions and Apps. While actions can be created from and loaded to many of the other windows within Toad, the power of actions is located in the Apps Designer.

Within the Apps Designer you can:

--Create new actions

--Organize actions into sets (apps)

--Run actions and apps

--Store actions and apps

--Schedule actions and apps

--Copy actions and apps to and from the clipboard

To access save/load window snapshot from a Toad window

1.   Click the camera (Save/Load window snapshot)   button in the status bar of the window.

2.   Select Create/Load Toad Action.

In addition, as with SQL Recall, actions are saved automatically when you perform a task that is action-enabled. (See Using History Items.)

Recalling an app gives you the ability to perform a distinct operation or sequence of operations in Toad on demand. Actions that can be used in the AppDesigner are listed in the Action Catalog.