Toad Data Point Subscription - Knowledge Base

Release Notes > Add or Remove Application Code

You can easily add syntax for another development tool such as C# to the SQL statement in the Editor to paste it into the development tool's code. ... You can also remove any syntax specific to the code development tool from the SQL statement so you can execute it in Toad.

Release Notes > Add Controls

You can drag controls from the Toolbox tool window to customize the report. ... The following controls are available: ... Adds a text label to the report. ... You can bind this control to data to calculate a summary.

Release Notes > Create Google Analytics Connections

Toad allows you to create connections to your Google Analytics data. ... A connection in Toad allows you to access the Google Analytics accounts and data that are available to you from your Google user account.

User Guide > Automate Complex Excel® Reports

You may need to create an Excel report that contains multiple result sets on a single worksheet. ... You can do this by exporting result sets to a specific cell in a worksheet. ... You may also want to make this report attractive.

User Guide > Pivot and Chart Data

Use Toad pivot grids to reorganize and summarize data to create meaningful reports. ... You can sort and aggregate data independent of the original data layout. ... This is useful for creating financial and statistical reports.

Release Notes > Filter Data in Transform and Cleanse

To filter data in the Transform and Cleanse tool, create a Filter Data rule. ... A filter data rule can be simple or complex. ... A simple filter rule can have several conditions, but uses only one type of operation.

Installation Guide > Browse Data in Related Tables

Use the Master Detail Browser to browse data in parent tables and drill-down to data in related child tables. ... This is useful when you need to analyze or edit data. ... For example, suppose you need to view a list of all Nick's Flix stores and the inventory of comedy movies at each store.

Release Notes > Manage Intelligence Central Users and Groups

You can view and manage Intelligence Central users and groups through the Users tab (or node) in the Object Explorer. ... The Users tab allows you to create Intelligence Central groups, add Active Directory users and groups, and edit or drop groups.

User Guide > Calculate Summary Data

Use the Summary Editor to calculate a summary for a label that is bound to data. ... Add a label control from the Toolbox to the report band where you want to calculate the summary, and bind it to the data.

Installation 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 > 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 > Automate

Installation Guide > Manage Intelligence Central Users and Groups

You can view and manage Intelligence Central users and groups through the Users tab (or node) in the Object Explorer. ... The Users tab allows you to create Intelligence Central groups, add Active Directory users and groups, and edit or drop groups.

Release Notes > Output

Toad uses the Output window to display logs and messages, including ... SQL execution logs ... Automation script execution logs ... Error messages ... Messages that you elect to display here ... Confirmation Options on how to specify where you want to display certain messages.

User Guide > Automate Publishing Data to Intelligence Central

In this tutorial, you will build an Automation script that publishes data as a dataset to Toad Intelligence Central. ... Your script can either overwrite the dataset or append data with each script execution.

User Guide > Data Profiling

Data Profiling allows you to inspect your data to assess its content and data quality. ... Use Data Profiling to find duplicates and nulls, to identify anomalies and patterns, and to view statistics about your data.

User Guide > Show or Hide Data

This feature is only available when using the Grid view to display data. ... You can re-add the hidden column by right-clicking a column heading, selecting Column Chooser, and then dragging the column from the Customization window.

Release Notes > Build Queries Visually

The Query Builder enables you to create a query without writing or editing SQL statements. ... Even if you are familiar with SQL, the graphical interface makes it easier to create relationships and visualize the query.

Release Notes > Create SAP Business Objects Connections

Review the following for additional information: ... Click Connect to connect immediately while saving the connection information. ... Optionally, click Save to save the connection without connecting.

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

Installation Guide > Troubleshoot Hive Issues

Toad allows you to connect to a Hive data warehouse system. ... Apache Hive is one of the NoSQL data sources supported by Toad. ... Toad allows you to connect to Hive using Kerberos authentication.

Release Notes > Edit or Copy Automation Scripts on Intelligence Central

With Toad you can open and edit an Automation script stored on Toad Intelligence Central (TIC) and then re-publish the script back to the same TIC instance. ... To edit a script, you must have Manage privileges to the script.

Release Notes > Database Explorer

Use the Database Explorer to view details for database objects. ... Click here to view a video of this feature. ... The Database Explorer opens displaying details for the selected object. ... Select the Data tab to view data for tables and views.

Installation Guide > Troubleshoot Oracle Issues

Review the following solutions to help troubleshoot Oracle connection issues pertaining to database connections and missing functionality and object information in Toad. ... Solution: ... In order to connect using the Oracle Instant Client, the directory for the Instant Client must be included in the environmental path, or you must copy the client files for the instance to the root install directory of Toad Data Point.

Release Notes > Formatter Options

Use these options to modify the way syntax is formatted when formatting code in the Editor. ... Click one of the following links to view a video about Basic or Advanced formatting features. ... Note: If you want statements automatically formatted when sending them from the Object Explorer to the Editor, select the Automatically format generated SQL check box in Explorer | General.