Chat now with support
Chat with Support

Toad Intelligence Central 4.3 - Deployment Guide

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

You can run the Web Server on Microsoft IIS, if necessary. See Run Web Server on Microsoft IIS for important configuration instructions.

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.

Run Web Server on IIS

If necessary, you can run the Web Server on Microsoft IIS instead of Microsoft IIS Express.

To run the Web Server on IIS

  1. Allow the Toad Intelligence Central installer to install IIS Express along with the Web Server.
  2. After successful installation, stop the Toad Web Server (Toad Intelligence Central) and change its Startup type to Disabled.
    1. Go to Control Panel | Administrative Tools | Services to open the services.msc dialog.
    2. Right-click Toad Web Server and select Stop.
    3. Right-click Toad Web Server and select Properties to open the Properties dialog. In the Startup type field, select Disabled.
  3. Now you can deploy the Toad Web Server to IIS. The site content path is the path to the Toad Intelligence Central Web Server installation folder, for example:

    C:\Program Files\Quest Software\Toad Intelligence Central Web Server

  4. You must include the following Role Services for the Web Server (IIS) Role:
    • Web Server | Common HTTP Features
      • Default Document
      • HTTP Errors
      • Static Content
    • Web Server | Application Development
      • .NET Extensibility 4.5
      • ASP.NET 4.5
      • ISAPI Extensions
      • ISAPI Filters
  5. When finished, restart the Toad Web Server.

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.

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

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating