Category
主题
Book
User Guide > Add Report Bands
A report band determines how and where controls from the Toolbox display in the report. ... The following report bands are available and can be added or removed from the Explorer tool window. ... See About Navigating Reports for more information.
User Guide > Create Hive Connections
Toad allows you to connect to a Hive data warehouse system. ... Apache Hive is one of the NoSQL data sources supported by Toad. ... Review the following for additional information: ... Enter the host name or IP address of the Hive data source.
User Guide > Snapshots in TIC
A snapshot is a table in Toad Intelligence Central (TIC) consisting of the result set of a query, the stored SQL query, and the mapping information to the remote object. ... A snapshot is a copy of the data taken at a specific point in time.
User Guide > 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
User Guide > Create Histograms
Histograms are useful for getting a comprehensive overview of the range of data of a column. ... Histogram data can also show the distribution and density of values. ... This range can be used in where conditions and case statements.
User Guide > MySQL Reports
Description ... Help Topic ... Displays the first 10 rows of the mysql.help_topic table. ... Related Topics ... About Managing Reports
User Guide > Publish Toad Documents to Intelligence Central
Toad allows you to publish Toad documents as objects to a Toad Intelligence Central (TIC) server. ... After publishing, you can share and manage these Toad documents similar to other objects in TIC.
User Guide > Execute/Schedule Automation Scripts
You can execute automation scripts on demand from the Automation window or the Project Manager. ... You can also schedule scripts to run on a recurring basis at a specific time. ... For example, schedule a script that performs long-running tasks to run when database activity is light.
User Guide > Diagram Relationships
Use the Database Diagram to view a high-level, visual representation of an object and those objects which may be related to it. ... This helps you easily identify relationships between tables via foreign keys.
User Guide > Get Published Generic File
You can copy a published generic file from Toad Intelligence Central and save it locally as a new file. ... Note: This feature is available in the Toad Data Studio Professional edition only and requires access to a Toad Intelligence Central server.
User Guide > Record and Play Macros
Use Macros to record a series of keyboard commands in the Editor that can be played back multiple times. ... This is useful for reducing the amount of manual typing you have to do. ... Scenario ... You have an INSERT statement with 500 lines of data to insert in the Directors table of the MOVIES database.
User Guide > Grid Options
Review the following for additional information: ... Displays a panel that allows you to group data columns. ... Automatically resizes data columns to maximize the amount of data that displays. ... Maximum rows to process
User Guide > About SAP Business Objects Data Sources
SAP Business Objects is one of the business intelligence connections provided by Toad. ... When you create a connection to Business Objects, you are connecting to the Query as a Web Service (QaaWS) component.
User Guide > Welcome to Toad Data Studio
Toad ® Data Studio is a heterogeneous database IDE intended to assist Data Engineers and other technical users to easily manage, query and develop against any database in your environment. ... Connect to almost any database or ODBC data source (see the Release Notes for a list of tested ODBC connections)
User Guide > Default Account for Script Execution
When you publish an Automation script to Intelligence Central, you can select a user account to run the script. ... You can specify a specific user account or you can use the default user account to run the script.
User Guide > Define Conditional Styles
You can create and apply conditional formatting rules to customize the appearance of pivot grid cells and cell contents. ... Create a rule by specifying a condition and then define the desired cell appearance (background color, text color, etc.).
User Guide > Prepare to Publish Automation Scripts
Because the destination Intelligence Central (TIC) server may be slightly different than your local environment, an Automation script that runs successfully on your local machine may not always run successfully on a TIC server.
User Guide > Profiling Options
Use this page of the Options dialog to specify default values to use with the Data Profiling tool. ... The settings you specify here apply to new Data Profiling sessions. ... You can override these settings at the session level.
User Guide > Automate Tasks
Use Automation to schedule a single script to run reports and queries, save results in Excel spreadsheets, and distribute results to the business community via email. ... You can schedule scripts that perform long-running tasks to run when database activity is light.
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.
User Guide > More About Excel Export Options
Automation scripts are a powerful and useful tool in Toad. ... For many users, the end result of their script is an Excel report. ... Toad allows you to specify a number of options for the exported Excel report.
User Guide > Compare Differences in Data
You can compare result sets from the current editor or a different editor in the Database Explorer's Data tab or the editor's Result Sets without having to save one of the sets to a file. ... If you want to synchronize data, use Data Compare instead of the Data Diff Viewer.
User Guide > Add Active Directory User or Group
When you publish an object to Intelligence Central, you can choose to share the object with one or more users. ... The Publishing dialog presents a list of Intelligence Central users from which you can select.
User Guide > General Database Options
Review the following for additional information: ... Enter the number of rows to initially retrieve when querying data in the Database Explorer. ... Unlimited—Return all rows for a query. ... Caution: Selecting unlimited rows can impact performance and memory usage when querying a large table.
User Guide > About SQL Server Analysis Services Data Sources
You can create a connection to a Microsoft SQL Server Analysis Services data source to access and query multi-dimensional cubes. ... When you create a new connection to a Business Intelligence or NoSQL data source, Toad automatically maps the data source objects.
新产品关联性