Chat now with support
Chat with Support

Toad Intelligence Central 5.3 - Deployment Guide

Welcome to Toad Intelligence Central Install Toad Intelligence Central License Toad Intelligence Central Connect to Toad Intelligence Central Add New Users and Groups Manage Users and Groups Email Notifications Misc Administrator Activities Manage Objects Manage Folders Object/Folder Manager Privileges Reports Health Check Dashboard Support Bundle Server Maintenance Upgrade Toad Intelligence Central Uninstall Toad Intelligence Central About Us

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

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

  • This guide describes procedures that can be performed by users with the Administrator role, including the Administrator (root) user.

Standard and Power Users

  • Non-Administrators should refer to the Toad Intelligence Central Quick Start Guide for functionality available only to the non-Administrator roles.

Additional Resources

Find Help from Inside Toad Intelligence Central

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

  • To go to the Toad Intelligence Central User Forum in Toad World, click and select User Forum.

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 Toad Intelligence Central.

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.

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.

Install Toad Intelligence Central

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

  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.

    8066
    Web server port number

    Port 80 is reserved for the web port. During installation, you can change this if required.

    Note:

    • The installer will let you know if there is a conflict in using the default port 80.
    • It is not advisable to install other web servers on the Toad Intelligence Central server host.
    • A port number other than 80 must be included in the web browser address as per http://hostName:port/.
    • Ensure the port is open for TCP inbound connection. Ensure the Windows firewall and any other firewalls affecting the Toad Intelligence Central server host allow access to the Web Server.
    80
  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. Click Install.

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.

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