You can filter the data in a view, snapshot, or dataset before downloading the data. This is useful for large data sets as it allows you to download only the data you need, instead of the entire data set.
To filter data before download
In the object's Details pane, click to filter the data.
Enter Variables—For views containing a variable, Intelligence Central prompts you for a variable value. Enter a new value or use the default. The new value applies to this download only. The default value is specified when the view is published from Toad Data Point and can be modified through Toad Data Point.
|
Note: If authentication is required, the data object is not downloaded/accessed and an error message is displayed. You must authenticate through Toad Data Point before you can download this data object. 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. |
|
TIP: Filter one or more columns to quickly create the framework for your filter. Then refine it in the filter editor. |
|
TIP: To create a complex filter, plan out your filter before building it in the filter editor. Identify grouped conditions (those in parentheses). Identify the Boolean operator for the main expression. Add parentheses to your expression if necessary to help clarify which conditions should be evaluated first. |
Click Download in the data grid window to begin the download process.
|
Note: This action closes the data grid window containing your filter and preview of filtered data. |
Intelligence Central prepares the filtered data and displays a Success message when the data is ready.
Toad for Oracle users can publish Automation Apps, scripts, files, test results, code analysis results, and other resources created in Toad for Oracle to Intelligence Central. For detailed information about how to use Intelligence Central from Toad, see the Toad for Oracle documentation.
Review the following pages found in the Toad Intelligence Central Web interface.
You can use the Home page of the Web interface to view and download Toad for Oracle objects that have been shared with you. In addition, you can manually run Toad for Oracle Automation Apps.
|
Note: For Toad for Oracle objects, the object's publisher can choose to share and update the object in a mandatory way on Toad Intelligence Central. This ensures consumers of the object always have the latest updates. See the Toad for Oracle documentation for more information. |
To download objects
To manually run an Automation App
For more information about creating, publishing, and running Automation Apps, see the Toad for Oracle documentation.
The Code Quality page provides information from Code Analysis, Code Tester, and Team Coding. See the Toad for Oracle documentation for a breakdown of the information provided by each of these Toad for Oracle features.
To view Code Quality information for an object
Toad for Oracle allows you to publish Code Analysis results to Intelligence Central. Use the Code Analysis page to view Code Analysis reports. See the Toad for Oracle documentation for more information about using Code Analysis, as well as publishing and viewing Code Analysis data.
To view Code Analysis results
Use the Code Tester page to view published test results from the Code Tester feature in Toad for Oracle. See the Toad for Oracle documentation for more information about using Code Tester.
To open the Code Tester page
The Team Coding page allows you to view the status of all team coding objects.
To open the Team Coding page
Toad for Oracle allows you to publish the results of a DB Health Check to Intelligence Central. Use the Database Health Check page to view published health check results. To learn how to run a DB Health Check and store the results on Intelligence Central, see the Toad for Oracle documentation.
To view a DB Health Check
HTML Report are created in Toad Data Modeler.
HTML Reports can be published from Toad Data Modeler to Toad Intelligence Central. From Toad Data Modeler they can be shared with users of Toad Intelligence Central. Refer to your Toad Data Modeler documentation for more information.
Users of Toad Intelligence Central can log in to the web browser, view and download Toad Data Modeler HTML Reports that have been shared with them.
|
Note: A Toad publisher can choose to share and update objects in a mandatory way on Toad Intelligence Central. This ensures consumers of the objects always have the latest updates. For more detail, refer to the Toad application used to publish. |
Use your web browser to find objects on Toad Intelligence Central.
Method | Description | ||
---|---|---|---|
By folder |
Click Home to show objects in their folder structure. 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.
| ||
By search |
Click Home. Use the search bar. The search highlights matching text in the object name, object owner, modified date and object type. | ||
List just the objects you own |
From your username, select My Profile. Alternatively, click Administration | Users and select your username. The objects owned by you are listed in the Published Objects pane. Tabs show the number of objects that are Private (visible to you and the Administrator) and Shared (with other Toad Intelligence Central users). Click the Private / Shared tabs to show / hide these objects. | ||
List objects shared with you |
From your username, select My Profile. Alternatively, click Administration | Users and select your username. The objects shared with you are listed in the Shared Objects pane.
| ||
List objects shared with a group |
Click Administration | Groups and select the group. Objects shared with this group are listed in the Shared Objects pane. If you are a member of this group then you will see all shared objects. If you are not a member of this group then you will only see the objects shared with you; there may be additional objects shared with this group that you do not have the right to see. |
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy