Installation
System Requirements
Install Toad
Specify App Data Directory Location
Read-Only Installation
Install Toad Silently
Install Toad on Citrix Systems
Upgrade Toad
Upgrade Automation Scripts
Files Migrated During Upgrades
Uninstall Toad
Configure Toad Layouts
Create Connections
Understand Toad Connections
Create Access Connections
Create BusinessObjects Connections
Configure DB2 Client Connections
Configure DB2 LDAP Support
Create DB2 Connections
Create Excel Connections
Create SharePoint Connections
Create Google Analytics Connections
Create Hive Connections
Create Intelligence Central Connections
Create MySQL Connections
Create ODBC Connections
Configure Oracle LDAP Support
Create Oracle Connections
Create Oracle BI Connections
Create PostgreSQL ODBC Connections
Create Salesforce Connections
Create Snowflake Connections
Create SQL Server Connections
Create SSAS Connections
Create SAP Connections
Create SAP HANA Connection
Create Teradata Connections
Troubleshoot Connections
Troubleshoot Access Issues
Troubleshoot Hive Issues
Troubleshoot Excel Issues
Troubleshoot DB2 LUW Issues
Troubleshoot DB2 z/OS Issues
Troubleshoot Informix Issues
Troubleshoot MySQL Issues
Troubleshoot Oracle Issues
Troubleshoot SQL Server Issues
Troubleshoot Sybase ASE Issues
Configure Version Control
Tables in TIC
TIC tables always reflect the current data in the source table. TIC tables can be public, private, or shared with a list of users.
Note: This feature is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server.
Operations
Use the following operations (commands) from the Object Explorer toolbar or the right-click menu.
| Operation | Description |
|---|---|
|
|
Click to configure sharing (visibility) options for the selected table. Specify Sharing and Manage Privileges for Objects |
|
|
Drops the selected table. |
|
|
Locks the selected table. Lock and Unlock Objects |
|
|
Unlocks the selected table. 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