Chat now with support
Chat with Support

Toad Intelligence Central 4.3 - Quick Start Guide

Modify Variable Default Value

A view or Automation script can contain one or more variables. Each variable has a default value. The initial default value is specified when the view or script is published from Toad Data Point.

You can modify a variable default value for a view or Automation script through the Web interface (Web Server). You can modify the default value for objects you own or objects to which you have Manage privileges.

When downloading a view or manually running an Automation script that contains a variable, Intelligence Central allows users to enter a variable value. This run-time value applies to the current download or execution and does not change the default value. See Toad Data Point for more information.

To modify variable default value

  1. In the Web interface, click Home.
  2. Select an object containing a variable to modify.
  3. In the lower portion of the Details pane, select the Variables tab or click Expand and then select the Variables tab.

    Note: The Variables tab displays only for objects containing one or more variables.

  4. Enter a new value in the Default Value column.
    • For a view, the new value will be used when the result set is returned.
    • For a script, the new value is used when the scheduled script is executed.

 

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 interface (Web server) to view and download Data Connectivity objects that have been shared with them.

  1. Log in to the Web interface (Web server).
  2. Click Home.
  3. Locate the object. See Find Objects for more information.
  4. Select the object to show details. See View Object Details for more information.
  5. 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.

Download

Click to prepare download of the table result set.

Data is retrieved direct from the data source. Some time may be required to prepare the data for download.

Note: If authentication is required, Intelligence Central prompts you for your credentials.

Track the preparation of the download on the web browser display. Success is an indicator that the table is ready for download.

Click Download in the Success message. The location of the table on download will be as per your Web browser settings.

Source

The source is one of the object details listed on the Details pane. Where the name of the data source is long, the web browser has the facility to expand/ contract your view. Table data is retrieved from this source.

Click the data source link to alter authentication. See Alter Authentication for more information.

Columns Show the table structure, column names, and data types.
Expand Click to expand and show column details: data type, data size and Not Null status.

View

Views are saved SQL statements.

Download

Click to execute the SQL statement on the data source and prepare the result set for download. Some time may be required to prepare the data for download.

Note: If authentication is required, Intelligence Central prompts you for your credentials. For example, you might be required to authenticate the first time you access a View that was published with a personal key, instead of a shared key.

Track the preparation of the download on the web browser display. Success is an indicator that the result set is ready for download.

Click Download in the Success message. The location of the result set on download will be as per your web browser settings.

Source

The source is one of the object details listed on the Details pane. The SQL statement is executed against this data source. Where the name of the data source is long, the web browser has the facility to expand/ contract your view.

Click the data source link to alter authentication. See Alter Authentication for more information.

Note:  When the data source has a shared key applied, the link is enabled only for users with Manage privileges to the object.

Query

Show the query that is executed to produce the result set.

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

Expand Click to expand and show column details: data type, data size and Not Null status.

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. Snapshots are published with a shared key.

Download

Click to prepare download of the snapshot result set. This converts the snapshot to a CSV file. Depending on the size of the snapshot, this can take some time.

Track the preparation of the download on the web browser display. Success is an indicator that the snapshot is ready for download.

Click Download in the Success message. The location of the snapshot on download will be as per your web browser settings.

Source

The source is one of the object details listed on the Details pane. The SQL statement is executed against this data source. Where the name of the data source is long, the web browser has the facility to expand/ contract your view.

Click the data source link to alter authentication. See Alter Authentication for more information.

Note:  When the data source has a shared key applied, the link is enabled only for users with Manage privileges to the object.

Status Status is an object detail that indicates the execution status of the snapshot. It may be success, error, running (currently taking the snapshot) or pending (where Toad Intelligence Central is waiting to take the snapshot). If there was an error taking the last snapshot then expand to see the error details.
Schedule When was the last snapshot taken? When will the next snapshot be taken? The snapshot is scheduled to refresh (the result set) at the given date and time.
Query

Show the query that is executed to produce the result set.

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

Expand Click to expand and show column details: data type, data size and Not Null status.

 

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.

  1. Select the dataset to show details.
  2. Click in the Details pane. This converts the dataset to a CSV file. Depending on the size of the dataset, this can take some time.
  3. Track the preparation of the download on the web browser display. Success is an indicator that the dataset is ready for download.

  4. Click Download in the Success message. The location of the dataset on download will be as per your web browser settings.

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.

  1. Click an object name to open the Home page with the object selected.
  2. 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.

  1. Click either the Objects Used or Objects Not Used section of the graph to view a breakdown of the data.
  2. In the Objects Used or Objects Not Used page, you can filter results by selecting a different time period.
  3. 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.
  4. 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.
  5. To sort by a column in the data grid, click the column header.
  6. 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.

  1. Click a section of the graph to view a breakdown of the data for that object type.
  2. In the object type page, you can filter results by selecting a different time period.
  3. Change object type. To see results for a different object or for all objects simultaneously, select an option from the second drop-down list.
  4. 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.
  5. 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.
  6. To sort by a column in the data grid, click the column header.
  7. 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. A user with the Administrator role can configure registration parameters through the Web interface. To learn how to configure new user registration, see the Toad Intelligence Central Deployment Guide.

Use the following icons to identify the type of user or group wherever users/groups are displayed, for example the Users or Groups pages. Review the following descriptions.

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.

To register new users post login, select Administration | Users | Add User | Add Active Directory User. Your local configuration may require login with an Administrator role to add Active Directory users.

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating