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.
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.|
If you plan to install Toad Intelligence Central in a virtual machine (VM) environment, and you require more space than is available, you might choose to utilize a virtual disk (VMDK) to store the Toad Intelligence Central Data Files Folder.
Create the virtual disk and mount a drive on the VM to the virtual disk (if remote) prior to installing Toad Intelligence Central. Then during installation, specify the virtual disk as the location for the Data Files Folder.
The following procedure describes how to add a virtual disk for a VMware® virtual machine.
Add new virtual disk (VMDK) to VMware VM
The following methods are available for deploying Toad Intelligence Central in Microsoft Azure:
Toad Intelligence Central is now available in the Azure Marketplace. This pre-installed offering provides a quicker, more-simplified deployment of Intelligence Central. If you do not need to customize your installation, this method might be preferable to manually installing Intelligence Central in a new or existing Azure VM.
To locate Toad Intelligence Central in the Azure Marketplace, go to Microsoft Azure Marketplace and search for Quest Toad Intelligence Central.
To deploy Toad Intelligence Central from Azure Marketplace
Use these guidelines to help you set up and install Toad Intelligence Central in your own virtual machine environment in Microsoft Azure. Use this manual method if you have any of the following requirements:
To install Toad Intelligence Central in Azure
Resource group—A resource group is a collection of resources that share the same life cycle, permissions, and policies.
Select Use existing to select an existing resource group or select Create new to create a new one.
Add the Application server port and the Web server port to the inbound port rules list and the outbound port rules list.
Update Windows Firewall rules on the virtual machine.