Chat now with support
Chat with Support

Toad Intelligence Central 4.3 - Deployment Guide

Welcome to Toad Intelligence Central

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®.

  • SHARE - Objects can be shared amongst users and groups and organized collectively in a familiar folder structure, assigned tags and given a description for easy search retrieval. Administration of users and groups can be managed locally or users and groups can be imported from Active Directory®.
  • 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.

About This Guide

The Deployment Guide is intended for Administrators and provides information about how to install Toad Intelligence Central and how to configure server options. It also provides information about managing users and objects, as well as other Administrator activities.

This guide describes procedures that can be performed by users with the Administrator role, including the Administrator (root) user. Non-Administrators should refer to the Toad Intelligence Central Quick Start Guide for functionality available only to non-Administrator roles.

Install Toad Intelligence Central

The components of Toad Intelligence Central are as follows.

Component Description

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 the Intelligence Central server.

See also Install Toad Data Point and ODBC Drivers.

Web Server

The Toad Intelligence Central Web Server is used for administrative and general user access. It also hosts Web-based applications for collaborative Toad products.

The Toad Intelligence Central Web Server is installed on the same computer as the Intelligence Central server. For more information, see Install the Web 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.

Install the Toad Intelligence Central server

Use the Toad Intelligence Central Server Installer.

TIP: If installing on a virtual machine, see Use Virtual Disk (VMDK) in Virtual Machine Installation for additional information.

To install the Toad Intelligence Central server

  1. Run the Toad Intelligence Central Server Installer.
  2. Select to install Toad Intelligence Central.
  3. Agree to the license agreement.
  4. Provide details if connections to data sources outside your organization need to go through a proxy server.

    Field Description
    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.

  5. 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.

    Field Description Default
    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. 3566
    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. 2166
    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.

  6. Create a password to connect to Toad Intelligence Central. This is the administrator (root) password to the Intelligence Central server.
  7. 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.

  8. 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.

  9. Help improve Toad Intelligence Central. Optionally, select to provide anonymous user experience feedback. Refer also to the Privacy Statement.

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.

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.

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating