Note: This feature is available in the Toad Data Point 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 Point 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.
The Publishing dialog allows you to select a folder or create a new folder when publishing an object to Toad Intelligence Central.
The publishing dialog allows you to select a database or create a new database when publishing an object.
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 Point 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.
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
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
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>.
Third Party Application
When using a MySQL connection to Intelligence Central, the following databases which contain published objects are visible:
Toad Data Point
In the Object Explorer, the Intelligence Central databases listed above are visible, as well as the following:
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.