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,
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.
When publishing files and resources as part of a project, there are some considerations worth noting. Please review the following.
When published to Intelligence Central, the following resources are notably different.
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.
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.
To publish a single Toad project
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.
To publish multiple Toad projects
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.
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.
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. |
© ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center