Chat now with support
Chat with Support

Toad Intelligence Central 4.3 - Deployment Guide

Setup HTTPS for Web Server

You can configure the Toad Web Server to use HTTPS protocol for network communication. To do this you must add an HTTPS binding to the Toad Web Server applicationhost.config file. Then bind a certificate to the port you specified to be used for the HTTPS communication.

The following procedure describes general instructions. Instructions for your environment may vary.

To configure Web Server for HTTPS

  1. Stop the Toad Web Server.
    1. Open the Windows Control Panel.
    2. Select Administrative Tools | Services.
    3. Right-click Toad Web Server (Toad Intelligence Central) and select Stop.
  2. Add a site binding to the Toad Web Server config file.
    1. Locate the Toad Web Server installation directory. The default path is:

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

    2. In this directory, open applicationhost.config in an editor, such as Notepad.
    3. Add a site binding using the following format:

      <bindings>

      <binding protocol="https" bindingInformation="*:443:"/>

      </bindings>

      Where:

      • protocol defines the protocol to use (in this case "https")
      • bindingInformation provides the following: [ip]:[port]:[host]

      The example above adds an https binding on port 443 for any IP address and any host.

  3. View available public key certificates on host computer.
    1. To view public key certificates available on this computer, open the Microsoft Management Console (MMC.exe). (Open the Command Prompt, type mmc, and press ENTER.)
    2. In the Console, select File | Add/Remove Snap-in.
    3. Select Certificates and click Add.
    4. In the Certificates snap-in dialog, select Computer account. (Optionally, select My User account or Service account if applicable.)
    5. In the Select Computer dialog, click Finish.
    6. In the Add or Remove Snap-ins dialog, click OK to save your changes and close the dialog.
    7. In the Console, expand the Certificates (Local Computer) node (depending on the added snap-in) to display certificate stores.
    8. Select a store to display available certificates in that store.
  4. Select certificate to use and copy thumbprint value.
    1. Select a certificate to bind to the https port number.
    2. Double-click the selected certificate to open it.
    3. In the Certificate dialog, select the Details pane.
    4. Scroll down and select Thumbprint. This hexadecimal value identifies the certificate.
    5. Copy the thumbprint value. You must remove the spaces before using it in a command.
    6. Paste the value in an editor, such as Notepad, and remove the spaces. This is your certificate hash.
  5. Bind certificate to port.
    1. Open a Command Prompt window.
    2. Run a command similar to the following to bind the certificate to the port:

      netsh http add sslcert ipport=0.0.0.0:443 appid={00112233-4455-6677-8899-AABBCCDDEEFF} certhash=YOURCERTHASH

      Where:

      • ipport is the IP address and port to bind
      • appid is a GUID that can be used to identify the owning application
      • YOURCERTHASH is the certificate hash (thumbprint) value
  6. Start the Toad Web Server.

Upgrade Toad Intelligence Central

To upgrade, run the Toad Intelligence Central installer.

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.

This release of Toad Intelligence Central has been tested with and supports an upgrade from either of the two previous versions. For example, an upgrade to Intelligence Central 4.3 from version 3.3 or 3.2 has been tested and is supported.

Notes:

  • The Toad Intelligence Central Data folder stores user information, data source connection information and mappings, snapshots and datasets. This folder is not affected by the upgrade. See Toad Intelligence Central Data Folder for more information.
  • By default, the location of the Toad Intelligence Central Data folder is ProgramData\Quest Software\Toad Intelligence Central\. If you upgraded from Intelligence Central 3.2 (or earlier), the location of this folder might be ProgramData\Dell\Toad Intelligence Central. 
  • To upgrade Toad Intelligence Central from a deprecated operating system, refer to Upgrade Toad Intelligence Central from a deprecated operating system.

Intelligence Central Automatically Upgrades Authentication Keys

If upgrading from Toad Intelligence Central 3.3 or earlier, authentication keys for some objects must be upgraded to support the more-simplified object Authentication process introduced in Intelligence Central 4.3. Specifically, if a view has both a shared key and a personal key, the personal key is removed. This process runs automatically during upgrade/installation.

IMPORTANT: If an error occurs during the process of deleting the redundant authentication keys (deleting personal keys where a shared key exists), please contact Quest Support for further assistance.

Upgrade Toad Intelligence Central from a deprecated operating system

Follow these instructions to upgrade Toad Intelligence Central from a deprecated operating system.

  1. Stop the Toad Intelligence Central server.

  2. Copy ProgramData\Quest Software\Toad Intelligence Central\ including subfolders to the location that will be used by Toad Intelligence Central 4.3

    The default location is (C:\ProgramData\Quest Software\Toad Intelligence Central\). 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 it as this folder is frequently referred to during server maintenance.

    If you upgraded from Intelligence Central 3.2 (or earlier), the location of this folder might be ProgramData\Dell\Toad Intelligence Central.

    See Toad Intelligence Central Data Folder for more information.

  3. Install the Intelligence Central server 4.3 on a supported operating system.

    During installation you will be prompted for the Data Files Folder. Ensure this location is set to the place you copied ProgramData\Quest Software\Toad Intelligence Central\.

  4. The Administrator connects to Toad Intelligence Central 4.3 via the Web Server
    1. The Administrator password is the Administrator password for the original Toad Intelligence Central installation.
    2. Reenter the Toad Intelligence Central License.
    3. Notify Toad Intelligence Central users of the change. As the host name / IP address of the Toad Intelligence Central server has changed then they will need to update their connection details as appropriate.

    Note: A known issue on connecting to Toad Intelligence Central 4.3 following this upgrade is Error fetching build_arch for Intelligence Central server. If you see this error then right click the Data folder in ProgramData\Quest Software\Toad Intelligence Central\ and select Properties. On the General tab in the Attributes section ensure Read-only is NOT selected.

  5. Use Toad Intelligence Central 4.3 (Data Source Connections and Drivers)

    Some data source connections make use of drivers installed on the Intelligence Central server. Ensure all drivers required by the Intelligence Central server data source connections are installed on the new Intelligence Central server.

Uninstall Toad Intelligence Central

Use the Toad Intelligence Central installer to uninstall each component.

Backup / Remove Data

Data from Toad Intelligence Central is stored in ProgramData\Quest Software\Toad Intelligence Central\. This folder is not removed automatically on uninstall. Backup or remove it manually as required.

Note: If you upgraded from Intelligence Central 3.2 (or earlier), the location of this folder might be ProgramData\Dell\Toad Intelligence Central.

For more information see: Backup the Toad Intelligence Central server and  Toad Intelligence Central Data Folder.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating