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.
Use the Toad Intelligence Central installer to install the Web Server on the same computer as the Intelligence Central server.
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.
If necessary, you can run the Web Server on Microsoft IIS instead of Microsoft IIS Express.
To run the Web Server on IIS
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
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');
|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.|