Chat now with support
Chat with Support

Toad Data Point 5.1 - Release Notes

Views in Intelligence Central

A view is a query. When you access a view, the query is executed and the data is retrieved on the remote source. TIC views can be private, public, or shared with a list of users you specify.

Note: This feature is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server.

Create Views

You can create a view in Intelligence Central by using the Publish to Intelligence Central dialog.

To publish data to Intelligence Central as a view

  1. Do one of the following:
    • In the Object Explorer, right-click a table or view and select Publish.
    • In the Editor or Query Builder, right-click a SQL statement and select Publish.
    • In a data grid, right-click in the data grid and select Send To | Publish Data.
  2. In the Publish to Intelligence Central dialog, specify publishing options and select View as the Object Type. See Publish to Toad Intelligence Central for more detailed instructions.

Operations

Use the following operations (commands) from the Object Explorer toolbar or the right-click menu.

Operation Description
Click to modify sharing (visibility) options for the selected view. Specify Sharing and Manage Privileges for Objects
Click to add or delete tags for the selected view. Alter Tags
Drops the selected view.
Click to change the default value for variable/variables in the selected view. Disabled if no variables are detected. Variables in Views/Scripts and Publishing to Intelligence Central
Locks the selected dataset. Lock and Unlock Objects
Unlocks the selected dataset. Lock and Unlock Objects

Manage Privileges

Users with Manage privileges can do the following (unless the object is locked):

  • Lock the object
  • Drop the object
  • Modify the object's sharing options
  • Rename the object
  • (Automation scripts and Toad files) Edit the script or file
  • (Snapshot) Refresh snapshot or modify refresh schedule
  • (Automation scripts) Modify schedule
  • (Automation scripts) Change user account for script execution
  • (Views and Automation scripts) Modify the default value for a variable
  • (Data objects) Modify a shared (public) key password
  • (Views) Change the type of Authentication key
  • (Secured folders) Modify the folder's sharing and manage options
  • (Secured folders) Rename or delete the secured folder
  • (Secured folders) Create a subfolder

To see a comparison of View properties against other TIC objects, see Data Objects in Toad Intelligence Central.

  

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating