Category
主题
副主题
Book
User Guide > Getting Started with Automation
This tutorial helps you get started with Automation by giving you an overview of the Automation module and then guiding you through the process of creating a basic script. ... In this tutorial you will learn:
User Guide > Automate Toad Data Reports
In this tutorial you will use Automation to execute an existing Toad Data Report file and publish a customized PDF report containing query results. ... In this tutorial you will learn: ... Toad Data Reports (.tdr) are Toad files that you can use to design and publish attractive reports for your query results.
User Guide > Create MySQL Connections
You can create a new connection, or connect to an existing connection from the Create New Connection window. ... Review the following for additional information: ... Select the protocol to use when connecting.
Installation Guide > Background Processes
Use the Background Processes pane to monitor and stop SQL statement execution, database object retrieval, and web page retrieval. ... When a statement is executing, a process task and progress bar display in the Background Processes pane.
Release Notes > Use Database Automation Activities
You can use the following activities in automation scripts. ... Note: When building an automation script, you must have the appropriate connections open for database activities. ... Tip: You can save an activity and its settings as a template to reuse in other scripts.
Installation Guide > Working With Intelligence Central Objects
Note: This feature is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server. ... Review the following considerations and limitations when using Intelligence Central objects.
User Guide > Create Queries for SQL Server Analysis Services
To use SQL Server Analysis Services (SSAS) cube data in the Query Builder, you can drag a cube to the Query Builder or you can create a Query first and send that to the Query Builder. ... The Database Explorer is used to create and save Queries from SSAS cube data.
Release Notes > Organize Files Using the Library
The Library is designed to be used as part of your primary workspace in Toad Data Point. ... The Library allows you to organize and view your files by categories and groups that you create. ... Create topics to group files.
User Guide > Use Variables In Automation
Automation variables are a powerful tool that can greatly extend your scripts. ... Variables can add flexibility and customization. ... Variables can be used in almost every Automation activity. ... Watch Using Variables in Automation for a video demonstration of this feature.
User Guide > Add Column Totals and Subtotals
This topic focuses on information that may be unfamiliar to you. ... It does not include all step and field descriptions. ... <P class=Procedure>To add a column total or subtotal</P> <OL> <LI value=1>Right-click the data and select <B>Show | Summary Footer Panel</B>.
Installation Guide > Advanced Analytics
Toad's Advanced Analytics feature allows you to perform advanced, in-database analysis of your data using a repository of sophisticated functions to perform predictive modeling and data mining. ... To use these functions, you must first copy the data to the Local Storage database.
Release Notes > Execute SQL
Use one of the following methods to execute SQL: ... To execute all statements, in order, one at a time, click or press F5. ... To execute the current statement, click or press F9. ... To execute the code within a code Region
Installation Guide > Filter Data
You can filter data to reduce the amount of time required to query the data and display results. ... You can define an advanced data filter, which re-executes the query, or can define a basic data filter for a column, which does not re-execute the query.
Release Notes > Auto-replace Options
Use these options to create and modify characters or words that are automatically replaced by the correct spelling/formatting when typed in the Editor. ... To set auto-replace options ... Review the following for additional information:
Release Notes > Create New Columns from Existing Columns or Functions
Use Calculated Fields to create a new column that is calculated from other columns or functions and assign the new column to a table in the query. ... To create a new column from an existing column or function
Installation Guide > Create SAP HANA Connection
Review the following for additional information: ... Host names for distributed systems are determined automatically. ... If the specified host is not available, the connection is established through one of the other hosts.
User Guide > Automation and Importing Data
This tutorial teaches you how to automate the task of importing data into a database. ... You will build a script that uses the Import Wizard activity. ... First, the tutorial teaches you how to create three different Import Wizard templates, and then how to automate them.
Installation Guide > About Working with Data
Use the Data tab of the Database Explorer to view data for the currently-selected object in the Object Explorer. ... From the data grid you can also export data or send data to other tools in Toad.
User Guide > Get a Published Toad Document
With Toad you can edit a Toad document stored in Toad Intelligence Central (TIC) and then re-publish the Toad document back to the same TIC instance. ... To edit a Toad document stored in TIC, you must have Manage privileges to the object.
Installation Guide > Oracle Reports
Displays cluster information, including the cluster type, definitions, storage parameters, and affected tables. ... Invalid objects ... Displays any invalid objects for the selected schema and includes a subtotal of all invalid objects for that owner.
Installation Guide > About Business Intelligence and NoSQL Data Sources
Toad provides users with the ability to create connections to non-traditional data sources, such as NoSQL and Business Intelligence data sources. ... These connections are different than traditional database connections.
Installation Guide > Configure DB2 LDAP Support
Configuring the client consists of enabling LDAP support and specifying the host name and port number of the LDAP server. ... Once the client is configured, Toad retrieves names from your LDAP server and displays them in the Database Alias list in the Connections window.
Release Notes > Set WHERE Conditions
In the Query Builder, you can use a Where condition to filter data returned by a query or to join sets of data. ... Note: If you reverse engineer a query that contains a Where clause, it displays in a Global Where clause bubble on the Diagram pane rather than the Where Condition field below the Diagram pane.
Release Notes > Using Variables in Automation
Automation variables are a powerful tool that can greatly extend your scripts. ... Variables can add flexibility and customization. ... Variables can be used in almost every Automation activity. ... Watch Using Variables in Automation for a video demonstration of this feature.
User Guide > Automate Creating and Refreshing Snapshots in Local Storage
In this tutorial you will learn how to create a snapshot in Local Storage and how to use Automation to create and refresh snapshots. ... Note: This feature is available in the Toad Data Point Professional Edition only.
新产品关联性