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.
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. |
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.
|
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. |
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy