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

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

• Product documentation - Find the complete set of Toad Intelligence Central technical documents.
• Toad Intelligence Central User Forum - Learn more about Toad Intelligence Central, find answers to questions, and connect with the community.
• Toad Intelligence Central Blogs - Find articles describing how to use the features in Intelligence Central.

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.

Install Toad Intelligence Central

Use the Toad Intelligence Central Server Installer to install the Intelligence Central server and the Web Server.

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.

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.