Access to Toad Intelligence Central
You can access Toad Intelligence Central using one or more of the following methods:
- The Web interface (Web server)
- A Toad application, such as Toad Data Point or Toad for Oracle
- A third-party tool, such as Tableau or a MySQL command line interface
|
|
Note: Toad Intelligence Central is a server that runs as three services that start automatically when Windows starts. For more information, see Toad Intelligence Central services. |
Web Interface
The Web interface (Web server) provides Standard users with the ability to view and perform limited operations on objects published to Intelligence Central from other Toad applications. To use the Web interface, the Web server must be installed on the same computer as Intelligence Central.
See Log In From a Web Browser for more information about accessing Intelligence Central through the Web interface.
The Web interface allows users with the Administrator role to perform advanced activities such as the management of users, groups, and objects, as well as Intelligence Central server configuration and maintenance.
Toad Applications
Toad Data Point users can publish data objects, Automation scripts, Toad documents, and other resources created in Toad Data Point to Intelligence Central. Toad for Oracle users can publish Automation apps, files, and other resources created in Toad for Oracle. For these users, their primary method to view, access, manage, and edit Intelligence Central objects is through their Toad application.
Third-Party Tool
A Toad Intelligence Central user can create a MySQL connection to Toad Intelligence Central through a third party tool such as Tableau, MySQL command line interface, or MySQL Workbench. This connection can be used to query Data Connectivity objects stored in Toad Intelligence Central. See Third Party Connection to Toad Intelligence Central for more information.
Log in from a Web Browser
When the Web server is installed along with the Intelligence Central server, users can access Intelligence Central through a Web-based interface using a Web browser.
To log in to Toad Intelligence Central using a web browser
-
In a Web browser, enter the URL to the server hosting Intelligence Central. Review the following for additional information.
URL
The address of Toad Intelligence Central is http://hostName/ where hostName is the name of the computer hosting the Web Server and Toad Intelligence Central. If the Web Server has been installed on a port other than port 80 then the address is http://hostName:port/.
Log in
Toad Intelligence Central prompts you to login.
If you login to Toad Intelligence Central using Windows credentials then enter your login name at the login prompt. If necessary, include your Windows domain: domain\username. The computer you use to login to Toad Intelligence Central must be accessible to your Windows domain.
To login to Toad Intelligence Central as the Administrator (root), in the username field type root. In the password field type your Administrator password. The initial Administrator password is as per the password you entered when you installed the Intelligence Central server.
Note: The login screen may include an option to Register as a new user. If you do not have a login to Toad Intelligence Central then click this link to add yourself as a new user. The availability of this link is dependent on local configuration. For more information on this feature, see Users and Groups
|
|
Note: Toad Intelligence Central encrypts your login credentials when transmitted over the network. Refer to your local Toad Intelligence Central Administrator for more information. |
Third Party Connection to Intelligence Central
A Toad Intelligence Central user can create a MySQL connection to Toad Intelligence Central through a third-party tool, such as one of the following:
- Tableau
- MySQL command line interface
- MySQL Workbench
This connection can be used to query tables, views, snapshots and datasets stored in Toad Intelligence Central.
Requirements / Limitations
| Third party tool | Ensure the authentication method you use to connect to Toad Intelligence Central is supported by the third party tool. This is straightforward if you login to Toad Intelligence Central using credentials local to Toad Intelligence Central. If you login to Toad Intelligence Central using Windows credentials then the third party tool must also support MySQL connection via Windows credentials. |
|
Computer where the third party tool is installed |
Ensure a MySQL driver is installed appropriate to the third party tool and Toad Intelligence Central. Ensure the default character set is UTF8. |
| Toad Intelligence Central Share / Manage rights | To see an object that you did not create yourself you must have Share or Manage rights to that object. These rights can be granted by any Toad Intelligence Central user with Manage rights to the object using an application such as Toad Data Point or the Admin Console. |
| Data source authentication | Ensure the data source authentication you use to access the result set of a table or view is defined in Toad Intelligence Central. This can be done using an application such as Toad Data Point or the Admin Console. It cannot be done using the third party tool. |
Connection
Create the MySQL connection.
| Parameter | Description |
|---|---|
| Host name |
The name of the Toad Intelligence Central server host. |
| Port |
The connection port to the Toad Intelligence Central server. This is the Port number set during installation of the Toad Intelligence Central server, by default 3566. |
| Username and Password |
Your username and password to Toad Intelligence Central. Alternatively, if you use Windows credentials to connect to Toad Intelligence Central then select the option to connect via Windows credentials. |
MySQL database
Select the MySQL database where the object is stored. This is dependent on the application used to create the object.
| Application | Description |
|---|---|
| Toad Data Point |
The database is defined when the object is published to Toad Intelligence Central. |
| Admin Console |
For a table, view or snapshot the MySQL database is the name of the data source. For a dataset the database is of the form data_owner. The owner is the user that created the dataset. |
|
|
Note: Hidden, temporary and internal Toad Intelligence Central databases and MySQL databases may be visible. |
Queries
Query tables, views, snapshots and datasets.
|
|
Note: When querying tables and views, execution of SQL may fail under some circumstances. If the SQL used by the third party tool has a MySQL dialect, then that SQL may fail if the query is shipped to a non-MySQL relational database for remote execution. As a workaround, you could use Toad Data Point or the Admin Console to save the table or view as a snapshot and then access the snapshot via the third party tool. |
MySQL Views
You can use the following MySQL commands to verify the third party tool.
- SHOW [FULL] TABLES command
- DESC[RIBE] command
- EXPLAIN command
- SHOW [FULL] COLUMNS command
- SELECT query against information_schema.views
- SELECT query against information_schema.tables
License Toad Intelligence Central
Toad Intelligence Central is shipped with a trial key that enables a 90 day open trial license to Toad Intelligence Central. Use this key to evaluate Toad Intelligence Central. At the end of the 90 day trial, if a Data Connectivity license has not been entered, your Toad Intelligence Central functionality will be limited to that of the Toad Intelligence Central Community Edition.
Data Connectivity License
A Data Connectivity license is required to use Toad Intelligence Central with Data Connectivity. Any Toad Intelligence Central license from a prior release can serve as a Data Connectivity license for this release.
To view / activate Toad Intelligence Central licenses
- From a web browser, log in to Toad Intelligence Central. Any Toad Intelligence Central user can add a license. Administrator credentials are required to remove a license.
- Select Administration | Licensing.
- If Toad Intelligence Central has multiple licenses assigned, select the license to view or click Add License to add a license.
After licensing Toad Intelligence Central, you can elect to provide anonymous user feedback to help influence the design of future releases. See Enable User Experience Feedback to learn how to easily enable this feature.