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 Studio 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
- 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.
- 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
- (
- (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.