Toad Data Point 6.0.5

Chatta subito con l'assistenza

Ottieni assistenza in tempo reale
Completa la registrazione

Accedi

Richiedi prezzo

Contatta il supporto vendite

Welcome to Toad Data Point Understand Toad's Workflow

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

Understand

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

Query

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

Report

Tutorial: Create a Toad Data Report Manage Reports

About Managing Reports DB2 Reports MySQL Reports ODBC Reports Oracle Reports SQL Server Reports

Publish and Share Reports

Automate

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

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

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