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.
Users of Toad Intelligence Central can log in to the Web Console (Web Server) to view and download Data Connectivity objects that have been shared with them.
For more information about working with objects published from Toad Data Point, see Work with Toad Data Point Objects.
Tables are tables of data mapped from data source mappable objects.
Views are saved SQL statements.
Snapshots are the result set from an executed SQL statement (View) or table. Snapshots capture data at a specific point in time and can be scheduled to execute once or repeatedly. Snapshot data is stored in Intelligence Central so it is fast to load and does not require data source authentication to view. Snapshots are published with a shared key.
Mappable objects are objects from the data source that can be potentially mapped to tables. Mappable objects are not available for download and not visible from a web browser.
Datasets are tables of data published to Toad Intelligence Central.
From a web browser, click Home. Locate the dataset.
Objects published to Intelligence Central are organized into folders. The object's publisher selects an existing folder or creates a new folder during the publishing process in Toad Data Point. Intelligence Central users can also create folders through the Web Console.
Intelligence Central can contain several different types of folders. These folders can differ by purpose, origin, contents, and characteristics. Review the following descriptions for different folder types in Intelligence Central.
The following folders are created by Intelligence Central and have specific functionality.
No folder assigned
The No folder assigned folder is a special folder.
Toad Data Point users can publish Transform and Cleanse Rules to Intelligence Central to share with other users. These Transform and Cleanse Rules are stored in the Common_Transformation_Repository folder. See the Toad Data Point Help for more information about this feature.
Aside from the special folders listed above, Toad Intelligence Central provides two types of folders for storing objects: secured folders and non-secured folders. Secured folders have visibility (sharing) and manage privileges assigned to them. Non-secured folders do not. See About Secured Folders for additional information.
An Intelligence Central server can provide one or both types of folders. A user with the Administrator role can configure which types of folders can be created and which user role/roles are allowed to create secured folders.
|Non-secured folder—Visible to all users.
|Secured folder—Secured folders are visible only to users with visibility (sharing) privileges and can be managed only by users with manage privileges.
You can create a new folder using the Web Console (Web Server). A folder can also be created through Toad Data Point when an object is published. Only alpha, numeric, and the underscore (_) characters are allowed in folder names. A name cannot begin with the underscore character.
For more information, see About Secured Folders.
To create a new folder
Click the button corresponding to the type of folder you want to create.
Note: If a button is disable, creation of that folder type is not allowed, either at the server level or in the selected parent folder. See the Restrictions listed above.
Note: A folder can be created by an object's publisher during the publishing process in Toad Data Point. See the Toad Data Point Help for more information.
On the Home page, you can drag-and-drop a folder to move it. To move a folder, a user must have the Administrator role or manage privileges to all objects in the folder. A folder cannot be moved if an object in the folder is locked by another user.
See About Secured Folders for more information about secured folders.
You can delete a folder if you have the Administrator role or have manage privileges to all objects in the folder (unless an object is locked by another user).
To delete a folder
You cannot delete the No folder assigned folder.
You can view information about a folder in Intelligence Central through the Folder Details pane. This is useful, especially for secured folders, which have sharing (visibility) and manage privileges assigned to them.
You can view the secured folders that have been shared with you. You can also view the parent folder of a secured folder that has been shared with you.
To view folder details
In the Home page of the Web Console, select a folder to display the Folder Details pane. Review the following for additional information.
Folder name. For a secured folder, managers of the folder can rename the folder.
Folder creator. This is the name of the user who initially created the folder.
(Secured folders) Displays the visibility (sharing) privileges for the selected folder. Managers can modify the visibility privileges.
Click Visibility to open the Alter Folder Visibility dialog where you can modify visibility and manage privileges for the folder. See Specify Visibility, Manage and Publish Privileges for Folders for more information.
(Secured folders) Displays the list of users and groups with manage privileges for the selected folder. Managers can modify the visibility and manage privileges for the object.
Click Managers to open the Alter Folder Visibility dialog where you can modify the manage privileges for the folder. See Specify Visibility, Manage and Publish Privileges for Folders for more information.
(Secured folders) Displays the list of users and groups allowed to publish objects to the selected folder. Users with manage privileges can modify publish privileges for the folder through the Alter Folder Visibility dialog. See Specify Visibility, Manage and Publish Privileges for Folders for more information.
For additional information about manage privileges for secured folders, see Manager Privileges.
Secured folders are special folders in Toad Intelligence Central. Secured folders have visibility (sharing), manage, and publish privileges assigned to them. Non-secured folders do not.
Secured folders have the following special characteristics:
The sharing and manage privileges specified for a secured folder are also applied to all objects in the folder.
The special characteristics of secured folders provide the following advantages:
These characteristics, along with the server-level Folder Security settings, allow companies to customize the way they define and manage object accessibility in Intelligence Central.
Use this feature to develop and implement a methodology for controlling and regulating the sharing and management of objects, files, and data.
Intelligence Central allows you to specify which type of folders users can create: secured, non-secured, or both. You can also specify which users are allowed to create and configure secured folders. These settings are specified at the server level by a user with the Administrator role.
To learn how to configure secured folder settings for the server, see the Toad Intelligence Central Deployment Guide.
Review the following rules and restrictions that apply to secured folders and their objects.
Privileges Based on User or Role
Creating and Moving Folders
Moving and Deleting Secured Folders
Rules for Moving Objects into or out of a Secured Folder
Notifications of Secured Folder Activity
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center