Toad Intelligence Central 6.4 - Getting Started Guide

Data Object Report

The Data Objects page of the Reports section allows you to view, create, and download reports about Intelligence Central object usage. The Data Objects landing page provides a dashboard-type view that displays top-level object usage statistics. This report is designed mainly for Administrators, but all users can view and export object usage reports.

To open the Data Objects page, select Reports | Data Objects.

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.

User Activity Report

The User Activity page of the Reports section allows you to view statistics related to Toad Intelligence Central user activity. This report is designed mainly for Administrators, but all users can view and export user activity data.

• To open the User Activity page, select Reports | User Activity.

Landing Page

The landing page for this report provides a summary of user activity in Toad Intelligence Central.

To filter the landing page

1. Select a time period from the Active Users Over the... drop-down list.
2. Then select the activity for which you want to view user statistics.
   • Select Published to view the most-active publishers.
   • Select Consumed to view the most-active consumers. Consumer activities include downloading files, downloading data objects, querying data objects from Toad Data Point, and running Automation scripts.

   Users are sorted according to the number of objects published or consumed, highest to lowest. The top 10 most-active users (for the selected activity) are displayed.

Other actions

• Click the N Total Users link to go to the Users page of the Web Console (Administration | Users) where you can view a list of Intelligence Central users, as well as user details (including objects associated with a user).
• Click the N Total Groups link to go to the Groups page of the Web Console (Administration | Groups) where you can view a list of Intelligence Central groups, as well as group details and a list of objects shared with the group.

Drill Down to Additional Data

From the landing page, you can drill down to view more data about user activity.

To drill down to additional data

1. Click the N Active Users link to view an expanded list of user activity. The time period is preserved. You can also export data from this page.

   On the TIC Active Users page, you can do the following:

   • Click a column header to sort the data grid by that column.
   • Click Download CSV to export the data to a .csv file.
   • Select a different time period from Active Users Over the....
2. Click a user name to drill down to a list of the user's activities.
   • On the user's page, click a column header to sort the list by that column.
   • Click Download CSV to export the data to a .csv file.
3. Click a link in the breadcrumb navigation to go back to a previous page.

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.

View/Edit Users

In Toad Intelligence Central, new user accounts are created using one or both of the following methods:

• Add (import) accounts from Active Directory®
• Create accounts within Intelligence Central

Use the following icons to identify the source of a user account.

Icon	Description
	Active Directory® user (imported from Active Directory). This type of account uses Windows® credentials.
	Intelligence Central user (created on Toad Intelligence Central). This type of user account exists only on Toad Intelligence Central and uses Intelligence Central credentials.

View User Information

You can view a list of users, as well as user details (including objects associated with a user), on the Users page of the Web interface.

To view user information

1. In the Web interface, click Administration | Users to display the list of users on Toad Intelligence Central.
2. Select a user to view details in the right pane. The following useful information is available:
   • Account details, email address, and user role.
   • Groups in which the user is a member.
   • Objects shared with the user.
   • Objects published by the user.

User Roles

Each user is granted a role. By default, a new user is granted the Standard role. A user with the Administrator role can change the default role for new users and can change the role of any existing user. See the Toad Intelligence Central Deployment Guide for more information.

Review the following role descriptions.

• Administrator—Users with an Administrator role are granted all privileges in the administration of users, groups and objects. They are also granted some server and licensing privileges. The role of the Administrator (root user) cannot be changed.
• Power User—Power users have all the privileges of the Standard user. In addition, Power users can force consumers to take a shared object that is published or managed by the Power user.
• Standard User—All new users are granted the Standard role, by default.

Edit Your Account / Change Your Password

If your account is an Intelligence Central user account, you can edit some account details (profile) or change your password.

If your account was created by importing it from Active Directory, you cannot change the password through Toad Intelligence Central. However, Intelligence Central can be configured to synchronize with Active Directory. See the Toad Intelligence Central Deployment Guide for more information about synchronization.

To edit your Intelligence Central user details

1. In the Web interface, click Administration | Users to display the list the users on Toad Intelligence Central.
2. Select your user name.
3. Click Edit in the Details pane to change your full name or email address.
4. Click Reset Password to change your Intelligence Central account password.

Change Your Email Subscriptions

Intelligence Central can send activity reports and error alerts to users for objects they own or manage. Individual users can subscribe/unsubscribe to these email notifications through their user account details.

To modify your email subscriptions

1. In the Web interface, click Administration | Users.
2. Select your user name.
3. Click Change subscription and then select which email notifications to receive. See the Toad Intelligence Central Deployment Guide for more information about Email Notifications.