Object Details
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. |
Send Email from Details Pane
You can send an email to a user by clicking the user name in the Details pane.
- In the Details pane, click a user name in, for example, the Visibility, Publisher, or Managers fields.
-
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
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.
- Log in to the web browser.
- Click Home.
- Locate the object. See Find Objects for more information.
- Select the object to show details. See Object Details for more information.
- Click
to download the object. The location of the object on download will be as per your web browser settings.
| 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.
|
View and Download Reports
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. |
Dashboard View
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:
- Most-popular objects
- Percentage of objects used
- Most-often published objects
To Filter the Dashboard View
- Select a time period from What’s happened over the.
What's popular?
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.
- Click an object name to open the Home page with the object selected.
- In the Home page you can view the object details or perform additional actions on the object, such as download the object.
What's been used?
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.
- Click either the Objects Used or Objects Not Used section of the graph to view a breakdown of the data.
- In the Objects Used or Objects Not Used page, you can filter results by selecting a different time period.
- Filter results by object. (Objects Used) In the Object Downloads and Queries chart, click an object’s bar or value to filter the data grid by that object.
- Filter results by date. (Objects Used) In the Daily Downloads and Queries graph, click a data point to filter the data grid by that date.
- To sort by a column in the data grid, click the column header.
- To export the data in the data grid, click Download CSV.
What's been published?
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.
- Click a section of the graph to view a breakdown of the data for that object type.
- In the object type page, you can filter results by selecting a different time period.
- Change object type. To see results for a different object or for all objects simultaneously, select an option from the second drop-down list.
- Top 10 Publishers. Click
to see data for the top 10 publishers. In the Top 10 Publishers chart, hover the cursor over a bar to see a breakdown by Sharing option. Click a bar to filter the data grid by that publisher. To clear the filter, click the highlighted bar again.
- All Publishers. Click
to see data for all publishers. Click a publishers name to filter the data grid by that publisher. Click a value to filter the data grid by that criteria.
- To sort by a column in the data grid, click the column header.
- To export the data in the data grid, click Download CSV.
Users and Groups
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
Types of Users
| 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. |
Types of Groups
| 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. |