Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Toad Data Studio 1.1 - User Guide

Table of Contents

Welcome to Toad Data Studio Understand Toad's Workflow

Create Amazon Redshift Connections Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint Connections Understand Toad Connections Troubleshoot SQL Server Connections

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

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

Related Topics

Data Objects in Toad Intelligence Central

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center