Chat now with support
Chat with Support

Welcome, erwin customers to Quest Support Portal click here for for frequently asked questions regarding servicing your supported assets.

Toad Intelligence Central 5.1 - Quick Start Guide

Toad Data Modeler

HTML Reports

HTML Report are created in Toad Data Modeler.

HTML Reports can be published from Toad Data Modeler to Toad Intelligence Central. From Toad Data Modeler they can be shared with users of Toad Intelligence Central. Refer to your Toad Data Modeler documentation for more information.

Users of Toad Intelligence Central can log in to the web browser, view and download Toad Data Modeler HTML Reports that have been shared with them.

  1. Log in to the web browser.
  2. Click Home.
  3. Locate the object (Find Objects).
  4. Select the object to show details (View Object Details).
  5. Click View to view the HTML Report in your web browser.
  6. Click to download the HTML report. The location of the report on download will be as per your web browser settings.

 

Note: A Toad publisher can choose to share and update objects in a mandatory way on Toad Intelligence Central. This ensures consumers of the objects always have the latest updates. For more detail, refer to the Toad application used to publish.

Objects

Find Objects

Use the Web Console to find objects on Toad Intelligence Central.

Method Description

By folder

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.

By search

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.

List just the objects you own

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.

TIP: Secured folder visibility privileges override object owner (publisher) visibility privileges.

List objects shared with you

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.

TIP: Select a username other than your own. The objects this user has shared with you are listed in the Published Objects pane. The objects shared with both you and this user are listed in the Shared Objects pane.

List objects shared with a group

Click Administration | Groups and select the group. Objects shared with this group are listed in the Shared Objects pane. If you are a member of this group then you will see all shared objects. If you are not a member of this group then you will only see the objects shared with you; there may be additional objects shared with this group that you do not have the right to see.

View Object Details

Use the Details pane to view information about an object. You can also modify object properties from the Details pane. See Edit Object Details for more information.

To view object details

In the Web Console, click Home. Select an object to show object details.

Table 1: Object Details - Upper Pane

Detail Description

Name

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.

Note: Tables and Mappable Objects cannot be renamed.

Description

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

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.

Folder

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.

Object Type

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.

Database

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.

Source

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.

TIP: From a Web browser, where the name of the source is long, click the arrow to show/hide the full name.

Status

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

Schedule

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

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

Publisher

The user on Intelligence Central who created the object.

Created

The date and time the object was created.

Updated

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

Visibility

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.

Private The object can be seen by the owner and Administrator.
Shared The object can be seen by the owner, Administrator, and selected users and groups.
Public The object can be seen by all Intelligence Central users.

Managers

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.

Locked by

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

Credentials

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

Row Count (Dataset and snapshot) Displays the row count for the data object.

Table 2: Object Details - Lower Pane

Click Expand to display the full contents of each tab. This action opens the lower pane in a separate window.

Tab Description
Columns (Views, snapshots, datasets, tables) The Columns tab displays the columns and data types for the object.
Query

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

Note:  Only Administrators and users with Manage privileges to the object can view the query text.

Variables (Views, Automation scripts) If the object includes one or more variables, the Variables tab displays and provides each variable name and default value. To edit default values, see Modify Variable Default Value.
Logs

(Automation script) The Logs tab provides execution times and results.

Note: Only Administrators and users with Manage privileges to the script can view the detailed execution logs.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating