Toad Data Point 6.0 - User Guide

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

Publish Projects to Intelligence Central

Toad allows you to publish a project from the Project Manager as an object to a Toad Intelligence Central (TIC) server. After publishing, you can share and manage these projects similar to other objects in TIC.

Note:This feature is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server.

You can use published projects as a way to share a set of Toad resources for a particular project or task with others. For example, you can publish a project containing a Toad file, the connection, an Automation script, and the exported Excel file.

You can publish a single project or multiple projects at one time from your currently-loaded Project Manager file. See Project Manager to learn more about projects and the Project Manager.

Before Publishing a Project

When publishing files and resources as part of a project, there are some considerations worth noting. Please review the following.

Files and Other Resources

When published to Intelligence Central, the following resources are notably different.

Files are copied to server: While your local Project Manager project contains a link to a file, a published project contains the actual file. The file is copied to the Intelligence Central server when you publish the project.
Database connections: The connection information is included, but not the connection password.
FTP connections: The connection information is included, but not the connection password.

Toad Documents

For some Toad documents, a document published as a project is not equivalent to the same document published separately.

All Toad documents (except Query Builder, Import template, and Export template): When published as part of a project, these documents do not include a defined connection. See Best Practices for options.

Note: A Query Builder, Import template, or Export template published as a project is equivalent to the same document published separately.
Automation scripts: A script published as a project is not modified for the TIC environment and therefore cannot be executed on TIC.

Best Practices

All Toad documents (except Query Builder, Import template, and Export template): For best results, add the connection (as a database connection resource) to the project before publishing. See To add a database connection to a project for more information.

Another alternative is to publish the file separately, not as part of a project (open the file and publish it from an open document window).

Automation scripts: Publish a script as part of a project to share the script with colleagues. To run an Automation script on TIC, publish it separately, not as part of a project.

Publishing misc resources: Publishing as part of a project is the easiest way to publish the following resources: URLs, FTP connections, database object links, and named SQL.

Publish Projects

To publish a single Toad project

In the Project Manager window, right-click the project and select Publish Project. The Publish to Intelligence Central dialog opens.
In the Publishing dialog, select a destination server, a folder, and sharing options for your published project. You can also rename the project. See Publish to Toad Intelligence Central for detailed information about publishing options.

Note: The sharing privileges you specify for a Project Manager object apply to all files and resources in the project or projects. If necessary, you can alter the sharing and managing privileges at the project level or the file level after publishing.
After the project is published to TIC, it displays in the Object Explorer as a Project Manager object . Users with which you shared the object can Get (copy) the entire project or selected files from the project. See Get As Project.
After publishing, add tags to the Project Manager object to apply the tags to each file and resource in the project.

To publish multiple Toad projects

Select any project in the Project Manager window and click .
In the Publish Projects dialog, do the following:
1. Select each project you want to publish.
2. If you want a project to have a different name in TIC, you must rename it in this dialog. You cannot rename individual projects in the Publishing to Intelligence Central dialog. However, you can rename a project in Intelligence Central after it is published.
Click Publish. The Publish to Intelligence Central dialog opens.
In the Publishing dialog, select a destination server, a folder, and sharing options for your published Project Manager object. See Publish to Toad Intelligence Central for detailed information about publishing options.

Note: The sharing privileges you specify for a Project Manager object apply to all files and resources in the project or projects. If necessary, you can alter the sharing and managing privileges at the project level or the file level after publishing.
When the publishing process is finished, a success message displays. Click the link in the message to open the project in Intelligence Central.
After the projects are published to TIC, they display in the Object Explorer as Project Manager objects . Users with which you shared the object can Get (copy) an entire project or selected files from a project. See Get As Project.
After publishing, add tags to the Project Manager object to apply the tags to each file and resource in the project or projects.

Considerations and Limitations

Consideration/Limitation	Description
Multiple FTP connections with the same name in one folder are not published	When a single folder contains multiple FTP connections with the same name, only one FTP connection is published. Workaround: Give each FTP connection a unique name, or move duplicates to separate folders.
Getting a project from TIC replaces current projects in Project Manager	Whether you get (copy) a Project Manager object containing a single project or multiple projects, Toad replaces your currently-loaded Project Manager file (all projects) with the projects in the Project Manager object. Toad automatically saves your currently-loaded Project Manager (all projects) as a file.
An Automation script published as a project cannot be executed on TIC	An automation script published as part of a project (or published from the Project Manager) cannot be executed on Intelligence Central. To publish an Automation script and run it on Intelligence Central, use another publishing method. See Publish Automation Scripts to Intelligence Central for more information. Toad does not check script connections or modify the script for the Intelligence Central environment when you publish it as part of a project.
Some Toad files do not include connections when published as part of a project	If you Get a Toad file that was published as part of a project, and the file contains connections that are not currently defined in your Connection/Navigation Manager, the connections are not automatically defined for you. You must define a connection when the Connection dialog opens. This applies to all files except Import and Export templates and Query Builder files.
Directory shortcut	You cannot publish a directory shortcut.
To-Do List	You cannot publish a To-Do List.
Toad files and Automation scripts with connection to local data source	Toad allows you to publish a Toad file or Automation script containing a connection to a local data source, such as Local Storage. This is not the case when publishing a file or script separately.
Overwriting an existing project	If you publish a project and overwrite an existing project, only the files/resources common to both are overwritten.

Bitte w&auml;hlen Sie Ihr Produkt aus:

Damit wir Ihnen besser helfen können, geben Sie den Grund Ihres Chats an:

Empfohlene Lösungen für Ihr Problem