In the Web interface, you can register and manage server-side applications to be used in Automation. For example, register Toad for Oracle to run Automation Apps on an Intelligence Central server.
An Intelligence Central user with the Administrator role can register server-side applications.
Note: Toad for Oracle is automatically registered if installed from the Toad Intelligence Central Server Installer.
To register a server-side application
Users with an Administrator role are automatically granted Manage privileges to all objects on Toad Intelligence Central. See User Roles for more information.
In addition to the following object-management activities, the Web interface provides object usage reports.
In the Web interface, use the Home page to view the objects in Intelligence Central. You can also view a list of objects per user (or group) on the Users page (or Groups page).
Users can see only the objects that they own or that have been shared with them, with the exception of the Administrator. The Administrator can view all objects on Intelligence Central.
To view objects and object details
When a user with an Administrator role generates a list of objects they see all objects on Toad Intelligence Central. When any other user generates a list of objects they see the objects for which they have Share or Manage rights. Another user may not see all the objects that the Administrator can see.
Show the objects owned by a particular user
From a web browser with log in to Intelligence Central, click Administration | Users and select the user. The objects owned by that user are listed in the Published Objects pane. Tabs show the number of objects that are Private (to that user) and Shared (with other Toad Intelligence Central users). Click the Private / Shared tabs to show / hide these objects.
Show the objects shared with a particular user
From a web browser with log in to Intelligence Central, click Administration | Users and select the user. The objects shared with that user are listed in the Shared Objects pane.
Show the objects shared with a particular group
From a web browser with log in to Intelligence Central, click Administration | Groups and select the group. Objects shared with that group are listed in the Shared Objects pane.
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.
When data is published from a remote data source by a Toad Data Point user, the connection information is stored on Intelligence Central. Intelligence Central uses ODBC connectivity to connect to relational database sources that have been defined by Toad Data Point.
Note: To connect to data sources using ODBC connectivity, supporting ODBC drivers and necessary client files must be installed on the Toad Intelligence Central server host.
User Access to Remote Data Source - Authentication
When a Toad Data Point user publishes a data object to Intelligence Central, the object is associated with a particular data source connection. This data source connection in Intelligence Central must have a login ID (or authentication key) to use when connecting to the remote data source. This ID / authentication key is created when the object is published and can be either shared or personal. A shared ID / authentication key can be used by any user when accessing the remote source. A personal ID / authentication key requires that each user log in using their own personal login credentials when accessing the remote source.
The ability of any user, including a user with an Administrator role, to
The following table describes the origin of data and the authentication requirements for the data objects in Intelligence Central.
|Tables||Tables are tables of data mapped from data source mappable objects. The data is sourced direct from the data source. Authentication is required to view the contents of the object.|
|Views||Views are saved SQL statements. When the SQL statement is executed, data is sourced direct from the data source. Authentication might be required to view the result set if the object was published with a personal key. Authentication is not required if published with a shared key.|
|Snapshots||Snapshots are the result set of an executed SQL statement (View) or table. The data is stored on Toad Intelligence Central. Authentication is not required to view the result set.|
|Mappable Objects||Mappable objects are data source objects that can be potentially mapped to tables. Authentication is required to list mappable objects and map tables.|
If the Automation Script scheduled to execute on the Toad Intelligence Central server includes an instruction to send an email, then in order for that email to be sent the Toad Intelligence Central server must have access to an email SMTP port.
If the Automation Script scheduled to execute on the Toad Intelligence Central server includes an instruction to run a macro in an Excel spreadsheet, then Microsoft Excel must be installed on the Toad Intelligence Central host computer for the macro to successfully execute.
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.
A support bundle can assist in the diagnosis of issues such as data connectivity and query performance. To help troubleshoot these issues, you might want to generate a support bundle to send to Quest Software Technical Support. See the following for more information: