Toad Intelligence Central 6.1 - Quick Start Guide

Click Home to show objects in their folder structure. The objects you see are the objects that have been shared with you.

The folders you see include all non-secured folders and the secured folders that have been shared with you.

The folder tree is used to organize the objects published to Intelligence Central. A folder is created, or an existing folder is selected, when an object is published. Folders can also be created through the Web Console. For more information about folders, see Folders.

See View Object Details for more information about the Details pane.

The No folder assigned folder is a special folder.

• The No folder assigned folder holds all objects not yet moved (or assigned) to other folders.
• The No folder assigned folder cannot be moved, renamed or deleted.
• The No folder assigned folder cannot have sub folders.

Click Home. Use the search bar. The search results highlight text in the object name, object publisher, modified date, and object type fields that match the search string.

From your username, select My Profile. Alternatively, click Administration | Users and select your username.

The objects owned by you that are in folders visible to you are listed in the Published Objects pane.

• Private—Click to hide/show the objects that are visible only to you (as the owner) and the Administrators.
• Shared—Click to hide/show the objects that are also shared with other Toad Intelligence Central users.

From your username, select My Profile. Alternatively, click Administration | Users and select your username. The objects shared with you are listed in the Shared Objects pane.

Object name. Managers of the object can rename the object.

No two data objects can have the same name within the same folder. For Toad documents, the name must be unique within a folder per Toad document type. A script name must be unique among scripts. No two scripts can have the same name within an Intelligence Central instance.

The object's description. This is a short textual description of the object. The description is written when the object is published and can be edited by Managers of the object.

Tags are applied when an object is published and are editable by Managers. Tag names are created by the users of Intelligence Central. Typical examples of tag names include: the product name, the project name, or version number. Tags help the users of Toad Intelligence Central locate or group similar objects. Tags are an organizational tool. Tags are collectively managed by the users of Toad Intelligence Central.

Valid characters are letters, numbers, space ( ), dash (-), underscore (_) or dot (.). Letters entered in upper case are converted to lower case.

The folder in which the object is located. The folder is selected or created when the object is published. Folders can also be created through the Web Console. This field can be used to move an object by a user with the proper privileges. See Folders.

To move the object, click within the Folder field and select a folder from the drop-down list.

See Getting Started with the Web Console for more information about the folder structure.

See About Secured Folders for more information about secured folders.

Several types of objects can be published (or mapped) to Intelligence Central. Use this field to identify the type of object. An icon (Name column in grid) also indicates the object type.

Toad artifacts are created in a Toad product then published to Toad Intelligence Central. There are many types of artifact. Each type is identifiable by icon.

Data objects (views, snapshots, datasets), Automation scripts, and Toad documents are published from Toad Data Point.

Data Connectivity object types are Tables, Views, Snapshots, Mappable Objects and Datasets. Use of Data Connectivity requires a Toad Intelligence Central Data Connectivity License.

The underlying Intelligence Central database that contains the object. This can vary dependent on the application used to publish the object to Toad Intelligence Central.

For example, Toad Data Point users can personalize the database when they publish the object to Toad Intelligence Central for all object types except Automation scripts. If the database is not personalized from Toad Data Point the object is stored in database published_objects or <folder name>. For Data Connectivity objects created in the Admin Console, Database is the display name of the data source in Toad Intelligence Central.

For Data Connectivity objects, the Source is the actual name of the originating data source.

• Click the data source link to modify the Authentication key or to update credentials. See Alter Authentication for more information.
• When the data source has a shared key applied, the link is enabled only for users with Manage privileges to the object.

For Automation scripts, this field displays the connections included in the script.

(Automation scripts and snapshots) Displays the last run or refresh time.

(Automation scripts and snapshots) Displays the script or snapshot execution schedule.

Click Schedule to edit the schedule. See Modify Execution Schedule for more information.

The user on Intelligence Central who created the object.

The date and time the object was created.

The date and time the object was last modified, and the user who last modified the object.

Displays the sharing (visibility) privileges for the selected object. Sharing privileges are specified when the object is published. Managers can modify the sharing (visibility) privileges.

Click Visibility to open the Alter Visibility dialog where you can modify sharing and Manage privileges for the object. See Specify Visibility and Manage Privileges for Objects for more information.

Displays the list of users and groups with Manage privileges for the selected object. Manage privileges are specified when an object is published. Managers can modify the Manage privileges for the object.

Click Managers to open the Alter Visibility dialog where you can modify the Manage privileges for the object. See Specify Visibility and Manage Privileges for Objects for more information.

Displays the user who locked the object. See Edit Object Details for more information about locked objects.

(Automation scripts) Displays the name of the user account specified to run the Automation script. The run account is initially specified at the time the script is published.

Click Credentials to open the Alter Credentials dialog where you can select or modify the user account used to run the Automation script. See Alter Automation Script Credentialsfor more information.

(Views, snapshots) The Query tab displays the underlying query for the object.