From a web browser, click Home. Select the object to show details.
Table 1: Object details
Detail | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Name |
The name of the object. Managers of the object can rename the object. The name of the object must be unique for the object type and owner (user). So an owner (user) cannot have two Dataset type objects with the same name. Objects of the same name and type can be organized into the same folder. Published objects of the same name and type are differentiated by owner name. Objects sourced from data sources with the same name are differentiated by data source name.
| ||||||||
Description |
The object's description. This is a short textual description of the object. The description is (optionally) written when the object is published / created and can be edited by Managers of the object. | ||||||||
Tags |
Tags assigned to the object. Tag names are made up by the users of Intelligence Central. Typical examples of tag names are: the product name, the project name or version number. Tags are a textual indicator that 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 the object is in. The folder tree is an organizational structure collectively managed by the users of Intelligence Central. The object will be accessible from the parent folder. The parent folder is (optionally) assigned when the object is published / created and can be changed by Managers of the object. The No folder assigned folder is a special folder.
| ||||||||
Object Type |
The object type relates to what you can do with the object and where the object came from. The object type is identifiable by icon. 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 Connectivity object types are Tables, Views, Snapshots, Mappable Objects and Datasets. Use of Data Connectivity requires a Toad Intelligence Central Data Connectivity License. | ||||||||
Database |
Database is the database the object is in. This may 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. In Automation scripts, this field displays the connections included in the script. | ||||||||
Status | (Automation script and snapshot) Displays the last run or refresh time. | ||||||||
Schedule |
(Automation script and snapshot) Displays the script or snapshot schedule. | ||||||||
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.
| ||||||||
Visibility |
The object's visibility status. The visibility status can be changed by Managers of the object.
| ||||||||
Managers |
Managers of an object have privileges to do the following:
Initially the Administrator and owner of the object are managers. More managers can be assigned when the object is created. Managers can assign manage rights to other Toad Intelligence Central users.
| ||||||||
Locked date |
If an object is locked then only the user who locked the object and the Administrator can manage the object.
| ||||||||
Locked by |
For locked objects, the user who locked the object. | ||||||||
Row Count | (Dataset and snapshot) Displays the row count for the data object. |
Lower Pane
For some objects, additional information is displayed in the lower portion of the Details pane. For these objects, select a tab and click Expand to display the full contents of the tab.
|
Note: Object details can be modified in an appropriate application such as Toad Data Point. Object details cannot be modified through web browser access to Toad Intelligence Central. |
You can send an email to a user by clicking the user name in the Details pane.
This action opens an email pre-populated with the user’s address and the object name. Add a message and additional information before sending the email.
Data connectivity functionality allows Toad Data Point users to publish data objects (views, snapshots, and datasets) to Intelligence Central. Data objects are published to Intelligence Central as a way to store and share data from remote data sources.
|
Note: A Toad Intelligence Central Data Connectivity license is required to enable data connectivity functionality in Intelligence Central. |
Users of Toad Intelligence Central can log in to the web browser, view and download Data Connectivity objects that have been shared with them.
Object type | Download, view | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Table
|
Tables are tables of data mapped from data source mappable objects.
| ||||||||||||
View
|
Views are saved SQL statements.
| ||||||||||||
Snapshot
|
Snapshots are the result set from an executed SQL statement (View) or table. Snapshots capture data at a specific point in time and can be scheduled to execute once or repeatedly. Snapshot data is stored in Intelligence Central so it is fast to load and does not require data source authentication to view.
| ||||||||||||
Mappable Objects
|
Mappable objects are objects from the data source that can be potentially mapped to tables. Mappable objects are not available for download and not visible from a web browser. | ||||||||||||
Datasets
|
Datasets are tables of data published to Toad Intelligence Central. From a web browser, click Home. Locate the dataset.
|
The Web server provides a Reports section which allows you to view and create reports about Intelligence Central object usage. The Reports landing page provides a dashboard-type view that displays top-level usage statistics. The Reports feature is designed mainly for Administrators, but all users can view and export usage reports.
|
Note: Standard and Power users can view statistics for all objects. However, for these users, access to an object from a report page is limited to objects shared with or owned by the user. |
The dashboard displays top-level usage statistics. Use the dashboard to drill down to more-detailed information or object details. The dashboard graphs group data into the following categories:
To Filter the Dashboard View
This chart displays the most popular objects, i.e., the objects that have been downloaded or queried the most. You can click an object name to view object details.
This graph displays the percentage of objects used (downloaded or queried) in Intelligence Central. Click a graph data point to see the data broken down into usage statistics for the individual objects. Use filtering to narrow your results.
This graph shows what types of objects have been published during the selected time period, as well as the percentage for each object type. Click a graph section to view publishing statistics related to each object type.
New users and groups can be added to Toad Intelligence Central. Which user role is required before adding new users is dependent on how Intelligence Central is configured.
Use the following icons to identify the type of user or group wherever users/groups are displayed, for example the
Icon | Description |
---|---|
Active Directory® Users To self register from a web browser, click Register as a new user at the login prompt. The computer you use to login to Toad Intelligence Central must be accessible to your Windows® domain. This option is visible only if your local configuration allows self registration via a web browser. | |
Intelligence Central Users To self register from a web browser, click Register as a new user at the login prompt. Deselect the option to Use my Active Directory details. Fill in your user details. The options in this procedure may not be visible or selectable, depending on your local configuration. Your local configuration may not allow self registration from a web browser or registration of new Intelligence Central users. Following login to Intelligence Central from a web browser, to add users, select Administration | Users | Add User | Create Intelligence Central user. The availability of these steps depends on your Intelligence Central configuration. |
Icon | Description |
---|---|
Active Directory Groups Following login to Intelligence Central from a web browser, to add a group from Active Directory, select Administration | Groups | Add Group | Add Active Directory Group. Your Intelligence Central configuration may require login with an Administrator role to add Active Directory groups. | |
Intelligence Central Groups Any logged in user can create an Intelligence Central group. |
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy