Toad Data Point 5.6 - User Guide

Chatta subito con l'assistenza

Ottieni assistenza in tempo reale
Completa la registrazione

Accedi

Richiedi prezzo

Contatta il supporto vendite

Welcome to Toad Data Point Understand Toad's Workflow

Create ODBC Connections Create Oracle Connections Create SQL Server Connections Create Snowflake Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Report

Tutorial: Create a Toad Data Report Manage Reports

About Managing Reports DB2 Reports MySQL Reports ODBC Reports Oracle Reports SQL Server Reports

Publish and Share Reports

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

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

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.
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.

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

Toad Data Point 5.6 - User Guide

Automation Tutorial and Guided Tour

More Tutorials