Toad Data Studio 1.1 - User Guide

Destination Database in Toad Intelligence Central

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

When publishing an object to Toad Intelligence Central, the Publishing dialog allows you to specify a destination database. This feature is provided for Toad Data Studio users who provision data objects to those who can access Intelligence Central through a third party application, such as Qliktech or Tableau.

This feature allows the provisioner to store and organize objects into databases. Databases are used by the third-party-application user to locate and access stored objects.

Folders in Intelligence Central

The Publishing dialog allows you to select a folder or create a new folder when publishing an object to Toad Intelligence Central.

• Toad Data Point—Folders are visible to Toad Data Studio users through the Object Explorer and are used by the Toad Data Studio user to store, locate, and access objects.
• Third Party Application—The Intelligence Central folders are not visible to the Third Party application.

Databases in Intelligence Central

The publishing dialog allows you to select a database or create a new database when publishing an object.

• Toad Data Point—Databases are visible to Toad Data Studio users through the Object Explorer. However, folders are the primary method used for organizing objects for Toad Data Studio users. This is because folders are more-flexible and easily-customizable through the Object Explorer.
• Third Party Application— Databases are visible to a Third Party application through a MySQL connection to Intelligence Central and are used to store, locate, and access objects. Databases are the primary method of organizing objects since the Intelligence Central folders are not visible to the Third Party application.

Third-Party Connection to Intelligence Central

You can create a MySQL connection to Intelligence Central through a third-party application like Qliktech or Tableau. To learn how, see Third Party Connection To Toad Intelligence Central in the Toad Intelligence Central Quick Start Guide.

Tip: In Toad Data Studio you can create a MySQL connection to Intelligence Central. The MySQL connection allows you to view the underlying MySQL databases in Intelligence Central. You might want to use this type of connection to view databases prior to provisioning.

Creating and Specifying Databases

When publishing an object to Intelligence Central, you can specify or create a database in which to store the object for users who will access it through a third-party application. Organizing objects into databases is important for these users because Intelligence Central folders are not visible to Third Party applications. See Publish to Toad Intelligence Central for more information about publishing objects.

To select an existing destination database

1. In the Publish to Intelligence Central dialog, click next to the Destination Folder field.
2. Select an existing database.
   • By default, the destination database is the one associated with the selected folder. If you are creating a new destination folder, the database name defaults to the new folder name.
   • When no destination folder is selected, published_objects is the default database.

   Note: If you select an existing folder in the Publishing dialog without specifying an existing or new database, Toad stores the object in the database with the same name as the folder.

To create a new Intelligence Central database

1. In the Publish to Intelligence Central dialog, do one of the following:
   • If you selected an existing folder in the Destination Folder field, then click and enter a name for the new database.
   • If you created a new folder, you can use the default database name or click and enter a new name for the database.

   Note: If you create a new folder (or sub-folder) through the Publishing dialog without specifying an existing or new database, Toad creates a default database using the folder name. For a sub-folder, the database name is <parent folder>_<sub-folder>.

Viewing Databases

Third Party Application

When using a MySQL connection to Intelligence Central, the following databases which contain published objects are visible:

• User-defined databases—A database is created for each new destination database created through the Publish to Intelligence Central dialog.
• folder name database—Each time a new folder (or sub-folder) is created through the Publishing dialog without specifying an existing database, a default database is created using the folder name. This database contains each object originally assigned to that folder. Even if an object is moved to another folder through the Object Explorer, the object remains in the original database. For a sub-folder, the database name is <parent folder>_<sub-folder>.
• published_objects database—The "published_objects" database contains the objects in the "No folder assigned" folder.
• Legacy databases—If the Intelligence Central instance contains objects that were published using Toad Data Point 3.6 or earlier, a database was created for each data source (containing all objects published from that data source). See Explore Toad Intelligence Central for more information about datasource names. In addition, a database was created for each user and contains their published datasets (data_username).

Toad Data Point

In the Object Explorer, the Intelligence Central databases listed above are visible, as well as the following:

• database/folder name database—If you select an existing folder but do not use the default database and instead select a different database in the Publishing dialog when publishing an object, Toad creates a folder under the Databases node in the Object Explorer using the format database/folder.

Rules for Duplicate Object Names

Views, snapshots, and datasets: No two data objects can have the same name within the same folder, regardless of object type: view, snapshot, or dataset.

Toad documents: The name must be unique within a folder per Toad document type. For example, no two ER Diagrams in the same folder can have the same name, but an ER Diagram and a Query Builder file in the same folder can have the same name.

Automation scripts: A script name must be unique among scripts. No two scripts can have the same name within an Intelligence Central instance.