Chat now with support
Chat with Support

Toad for SQL Server 8.1 - Installation Guide

Explore Toad Intelligence Central

Use the Toad Intelligence Central Object Explorer to view and access objects in an Intelligence Central server. Then, explore object details using the Database Explorer (Viewer). See Using the Database Explorer (Viewer) .

Note: This feature requires access to a Toad Intelligence Central server.

Using the Toad Intelligence Central Object Explorer

The Toad Intelligence Central Object Explorer allows you to view and access objects in Intelligence Central. Review this topic to learn how you can group and display objects, identify objects by icon, filter object lists, and organize objects into folders.

Objects Visible to You

  • In the Object Explorer, you can see only the objects that you own or that have been shared with you.

    Tip: Select an object and click , to view sharing/visibility options for the object.

Display Options

In the Object Explorer, click to select a display option. You can group objects by the following:

  • Types—Groups objects into the user-defined folders.
  • Databases—Groups objects by database. In this view, Toad creates separate folders for Automation Scripts and Toad files.
  • Created By—Groups objects by creator.
  • Object Type—Groups objects by type.
  • All Types—Displays all groups simultaneously.

    Tip: Use All Types together with the Tabbed or Dropdown view option.

In the menu, standard Object Explorer view options are at the top; Intelligence Central view options are in the middle of the menu.

Intelligence Central Users Tab

Notifications Tab

Toad Documents and Misc Objects

Icon Object Description Icon Object Description
Automation script Import template
Automation script - running Named SQL
Automation script - with error Pivot Grid
Data Compare file Project Manger object (can contain one or more projects)
Database connection Query Builder file
Database object (object details) SQL file or Toad Editor file
ER Diagram Toad Data Report
Export template Transform and Cleanse file
FTP connection URL
Generic file Visualization file

Search and Filter

  1. Click to filter or search for objects.
  2. To search for objects using a partial string, enter <characters>* in the Search String field.
  3. To include folders in the results, select True in the Folders field.
  4. To include tags, owners, or data sources in the search, select True in the respective field. Or select False to exclude these from the search.

    Note: See Alter Tags to learn how to add tags to an object.

  5. Select the Preview tab to preview the results.

Create Custom Folders

Toad allows you to create custom folders and move objects into and out of custom folders in Intelligence Central. This is useful for grouping objects from several different data sources into one folder.

The custom folders are displayed along with the default folders created by Toad (e.g., for grouping objects into categories, such as the created by and object type folders) in the Object Explorer.

  • To create a new folder, click .
  • To rename a folder, click .

Using the Database Explorer (Viewer)

Use the Database Explorer (Viewer) to view detailed information about an object.

To view object information

  1. Right-click an object in the Object Explorer and select View Details.
  2. Select the Information tab to view the following object properties:

    • Sharing/Visibility options
    • Object owner
    • Who can manage the object
    • Who locked the object
  3. Select the Connections tab to view the connections included in a Toad document.

  

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating