Toad Intelligence Central enables enterprise users to be far more productive with their tools including Toad Data Point by centralizing automation workflows, accessing data directly, collaborating and sharing on datasets, queries and Toad files and providing a secure and established way to manage your data sprawl.
AUTOMATE - Toad users can schedule the regular automated execution of Toad Data Point automation scripts on Toad Intelligence Central.
ACCESS - Toad users can access Toad files and basic data files published to Toad Intelligence Central that have been shared with them. An additional data connectivity license extends Toad Intelligence Central to work across a wide range of data stores including relational database models, data warehouses, No SQL and Business Intelligence data sources like OBIEE and SAP®.
SECURE - Toad Intelligence Central provides a centrally managed, secure, stable and accessible system.
Distributions of Toad Intelligence Central include a Web Server for administrative and general user access. In addition, Toad Data Point and other collaborative Toad products can directly access Toad Intelligence Central. Data on Toad Intelligence Central can be accessed via a third party product such as Tableau for further data processing and visualization.
This Guide is Intended for Administrators
The Deployment Guide is intended for Administrators. This document provides information about how to install Toad Intelligence Central and how to configure server options. It also describes other Administrator activities, including managing users and managing objects.
Users with the Administrator Role
Standard and Power Users
To go to product documentation from the Web Console, click and select Technical Documentation. This actions opens the Technical Documentation page for Toad Intelligence Central on the Quest Support Portal.
There you will find the Release Notes, User Guide, Deployment Guide (installation and Administrator information), and What's New in This Release for the current and earlier versions of Toad Intelligence Central.
The components of Toad Intelligence Central are as follows.
Intelligence Central server
The Toad Intelligence Central server stores objects published to Toad Intelligence Central and account information for users of Intelligence Central.
Follow the steps to Install Toad Intelligence Central.
See also Install Toad Data Point and ODBC Drivers.
The Toad Intelligence Central Web Server is used for administrative and general user access.
The Toad Intelligence Central Web Server is installed along with the Toad Intelligence Central server.
Note: Beginning with Toad Intelligence Central 4.3, the Admin Console is no longer installed by the Toad Intelligence Central Installer. The administrative functionality of the Admin Console is now superseded by the Web Server. The activity of mapping/editing data objects is best performed through Toad Data Point.
Use the Toad Intelligence Central Server Installer to install the Intelligence Central server and the Web Server.
TIP: If installing on a virtual machine, see Use Virtual Disk (VMDK) in Virtual Machine Installation for additional information.
To install Toad Intelligence Central
Provide details if connections to data sources outside your organization need to go through a proxy server.
|Proxy host address
Type the DNS or IP address of the proxy server within your organization. HTTP and HTTPS secure proxy servers are supported.
|Proxy port number
Type the port on which the proxy server operates. The standard proxy port number is 8080. Sometimes port 80 is used. Less commonly an entirely different port may be used.
Make a note of the port numbers.
Note: These port numbers can be modified during installation to resolve port conflicts on the target host. However, all three port numbers are reserved for Toad with the Internet Assigned Numbers Authority and the default values should be valid for most installations.
|Intelligence Central server Port number
|This port can be used by third party applications to connect to Toad Intelligence Central. All other applications should use the Application server port number to connect to Toad Intelligence Central.
|Internal port number
|This is an internal port used by Toad Intelligence Central and should only be changed in the case of port number conflicts.
|Application server port number
Client applications use this port to connect to Toad Intelligence Central. Make sure you note down this port number. You will be required to enter this port number to connect Toad Data Point to Toad Intelligence Central.
|Web server port number
Port 80 is reserved for the web port. During installation, you can change this if required.
Accept or change the installation folder (C:\Program Files\Quest Software\Toad Intelligence Central).
If you change the installation folder be sure to document the new location. This folder is referred to in server maintenance.
Accept or change the Data Files Folder (C:\ProgramData\Quest Software\Toad Intelligence Central).
TIP: Ensure this folder has room to grow. All Toad Intelligence Central data will be stored in the ProgramData\Quest Software\Toad Intelligence Central\ folder and its subfolders. This folder will potentially grow quite large if lots of users publish lots of objects and take snapshots. You may choose to change the default folder location. For example, you may choose to direct the data files folder to a separate drive. If you do change the location of the data files folder be sure to document this as the data files folder is referred to in server maintenance. See Toad Intelligence Central Data Folder for more information.
Note: Beginning with Toad Intelligence Central 4.3, the Admin Console is no longer required and is not included in the installation. If an earlier version of the Admin Console exists, it is recommended that you uninstall it.
Product registration is optional. Register as a Toad user to receive product news and updates. If you register at the time of installation, you can unsubscribe at: https://www.quest.com/unsubscribe.
Upon successful installation, the Intelligence Central server will run as three services that start automatically when Windows starts. For more information, see Toad Intelligence Central services.