Chat now with support
Chat with Support

Toad Intelligence Central 3.3 - Deployment Guide

Install Toad Data Point and ODBC Drivers

You are here: Install Toad Intelligence Central > Install Toad Data Point and ODBC Drivers

When Toad Data Point is used to publish objects and Automation scripts to Toad Intelligence Central, ensure the following requirement is met.

Install Toad Data Point on the same host computer as Toad Intelligence Central.

Beginning with Intelligence Central 3.0, if the Toad Intelligence Central Server Installer is used, Toad Data Point and applicable ODBC drivers are automatically installed immediately following the Intelligence Central installation. This ensures compatibility of features and drivers for objects published through Toad Data Point and is required in order for Toad Data Point Automation Scripts to execute on Toad Intelligence Central.

Note: Following installation of Toad Data Point on the Toad Intelligence Central host computer, start the Toad Data Point application and add your Toad Data Point Professional license key. Adding your license key to Toad Data Point is required, however Toad Data Point installed via the Toad Intelligence Central installer is not counted in the Toad Data Point license count.

In addition, if Toad Data Point is used to publish Automation scripts to Intelligence Central, ensure the following requirements are met (if applicable).

Does the Toad Intelligence Central server have access to an email SMTP port?

If an Automation Script scheduled to execute on the Toad Intelligence Central server includes an instruction to send an email then in order for that email to be sent, the Toad Intelligence Central server must have access to an email SMTP port.

Is Microsoft® Excel® installed on the Toad Intelligence Central host computer?

If an Automation Script scheduled to execute on the Toad Intelligence Central server includes an instruction to run a macro in an Excel spreadsheet, then Microsoft Excel must be installed on the Toad Intelligence Central host computer. Other Automation script uses of Excel do not have this requirement. For example, Excel is not required to execute an Automation script that exports to Excel.

Install Toad for Oracle

You are here: Install Toad Intelligence Central > Install Toad for Oracle

In order for Toad for Oracle users to successfully execute Toad actions on Intelligence Central, the Intelligence Central server must have Toad for Oracle and an Oracle client installed.

Install Toad for Oracle on the same host computer as Toad Intelligence Central.

Beginning with Intelligence Central 3.0, if the Toad Intelligence Central Server Installer is used, Toad for Oracle is automatically installed immediately following the Intelligence Central installation. This is necessary if you plan to schedule and execute SQL scripts and Toad Actions on Intelligence Central.

Enter license key

After Toad for Oracle is installed, start Toad for Oracle and enter a license key.

Install other necessary client files

To prepare the Intelligence Central server to schedule and execute SQL scripts and Toad Actions when connected to an Oracle database, please ensure the following are installed on the Intelligence Central server:

  • A corresponding Oracle Client: If Toad for Oracle 64-bit is installed, install the 64-bit Oracle Client.

    Note: The 64-bit version of Toad for Oracle is automatically installed when the Intelligence Central Server Installer is used.

  • A tnsnames.ora file.

Install the Web Server

You are here: Install Toad Intelligence Central > Install the Web Server

Use the Toad Intelligence Central installer to install the Web Server on the same computer as the Intelligence Central server.

IIS Express

The Web Server requires Microsoft® IIS Express be installed. Installation of IIS Express is included in the installer and will run only if required and by your agreement.

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.

Authenticated Proxy Server Connections

You are here: Install Toad Intelligence Central > Authenticated Proxy Server Connections

The following is required if the host on which the Toad Intelligence Central server is installed connects to the Internet via a proxy server and the proxy server is authenticated. Execute this SQL statement after the Toad Intelligence Central server is installed. You can execute this statement in the Admin Console.

INSERT INTO hub_information_schema.hub_proxies VALUES ('http', 'http://proxyAddress:proxyPort/', 'username', 'password');

Variable Value
http The protocol under which the proxy server operates. The protocol may be http or https or both http and https. If both http and https are used then execute the SQL statement twice, once per protocol.
proxyAddress The IP address of the proxy server.
proxyPort The port on which the proxy server operates.
username The username to the proxy server.
password The password to the proxy server.
Related Documents