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. Publishing from Excel or Local Storage
Note: This feature is available in the Toad Data Studio Professional edition only and requires access to a Toad Intelligence Central server.
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.
See Create/Drop Index for a TIC Object for information about dataset indexes.
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 |
Users with Manage privileges can do the following (unless the object is locked):
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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center