Toad Data Point 5.3 - User Guide

Chat now with support

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

Datasets

A dataset in Toad Intelligence Central (TIC) is a table. A dataset is created by publishing data to TIC from a remote source (see Publish to Toad Intelligence Central). Once published, a dataset is no longer associated with the data source. Any changes to the source data are not reflected in the dataset.

The purpose of a dataset is to allow users to create user-owned tables for storing static data. You can, however, share datasets with other TIC users.

Data from the following sources is always published as a dataset: an Excel file, a Local Storage database, or an Access database. See Publishing from Excel or Local Storage for more information.

Note: This feature is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server.

Using Datasets

To query a dataset

Use the following naming format when querying a dataset. (The data in a dataset is in a hidden table that uses this format.)

data_<username>.<datasetname>

Example: data_susanb.MyFavDataset

Tip: To easily query a dataset, build a query in the Query Builder. The dataset table name will be included in the SQL.

Dataset Indexes

See Create/Drop Index for a TIC Object for information about dataset indexes.

Operations

Use the following operations (commands) from the Object Explorer toolbar or the right-click menu.

Operation	Description
	Click to modify sharing (visibility) options for the selected dataset. Specify Sharing and Manage Privileges for Objects
	Click to add or delete tags for the selected snapshot. Alter Tags
	Locks the selected dataset. Lock and Unlock Objects
	Unlocks the selected dataset. Lock and Unlock Objects

Manage Privileges

Users with Manage privileges can do the following (unless the object is locked):

Lock the object
Drop the object
Modify the object's sharing options
Rename the object
(Automation scripts and Toad files) Edit the script or file
(Snapshot) Refresh snapshot or modify refresh schedule
(Automation scripts) Modify schedule
(Automation scripts) Change user account for script execution
(Views and Automation scripts) Modify the default value for a variable
(Data objects) Modify a shared (public) key password
(Views) Change the type of Authentication key
(Secured folders) Modify the folder's sharing and manage options
(Secured folders) Rename or delete the secured folder
(Secured folders) Create a subfolder

To see a comparison of dataset properties against other TIC objects, see Data Objects in Toad Intelligence Central.

Note: See Use Database Automation Activities to learn how to use the Execute Script activity in Automation to automate publishing data as a dataset to TIC.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem