What does Toad for Cloud Databases Eclipse plug-in do?
The community edition of Toad for Cloud Databases is a free Eclipse plug-in that enables users to use SQL to:
- Work with data in a cloud/NoSQL database.
- Join a cloud/NoSQL database to a relational database on the personal computer.
- Copy tables from one cloud/NoSQL database to another or between a cloud/NoSQL database and a
relational database on the personal computer.
How does Toad for Cloud Databases work?
There are two key components to Toad for Cloud Databases. The first is the Eclipse plugin. The
Eclipse plugin is used to access the cloud/NoSQL database and write and execute SQL statements.
The second component is the Data Hub. It translates SQL statements submitted through the
Eclipse plugin into a language understood by the cloud/NoSQL database, and returns results in the
familiar tabular row and column format. It can be installed on the local computer or another
computer with network access.
Use the following instructions to install:
* Toad for Cloud Databases Eclipse plugin
* Windows Data Hub
* Fedora Data Hub (RPM packages)
Read the Getting Started Guide for more detailed installation instructions and requirements.
Read the Release Notes for more specific information pertaining to this release.
Install Toad for Cloud Databases for Eclipse
Follow these instructions to install Toad for Cloud Databases extension for Eclipse.
* Ensure Eclipse 3.5 or higher is installed and operational in the computer system. Ensure
the computer system satisfies all the requirements to run Eclipse, such as Java JRE installed
before you install Toad for Cloud Databases.
1. Start Eclipse.
2. For Eclipse 3.7 (Indigo) environments, drag and drop onto the Eclipse main toolbar and skip to step 5.
3. From the Eclipse toolbar select Help | Install New Software...
4. Fill in the Install dialog:
a. In the Work with field, type: http://toaddownload.quest.com/toadforcloud/eclipse/releases
b. Expand Toad Extension for Eclipse if Group items by category is selected.
c. Select Toad for Cloud Databases and click next.
5. Eclipse will analyze the Toad plugin to ensure all dependencies can be satisfied. (This step may take a few minutes.)
6. Accept the Quest Software license agreement.
7. The installation completes.
8. Restart Eclipse.
Install the Windows Data Hub
Follow these instructions to download and install the data hub to a Windows computer. The
data hub may be installed on the same machine as Toad for Cloud Databases or a machine
with a network connection to Toad for Cloud Databases.
Download the data hub installer to the Windows machine that will host the Data Hub.
1. Run the Data Hub installer.
2. Agree to the license agreement.
3. Indicate whether connection to the Internet is direct or via a proxy server. Provide details of the proxy server if applicable.
4. Make a note of the connecting port number. You will use it to connect to the data hub. The default Data Hub port number is 3566.
5. Create a password to connect to the data hub.
6. Accept or change the installation directory.
Install the Fedora Data Hub
Follow these instructions to download and install the data hub to a Fedora computer.
Run the following command as root:
rpm -Uvh http://toaddownload.quest.com/toadforcloud/yum/Fedora/toadforcloud-release-1.0-1.noarch.rpm
Run the following command as root:
yum install datahub
The data hub starts automatically on Fedora reboot. Following install, to start the data
hub without reboot enter the command service datahub start.
service datahub start
The Data Hub can be deployed to an Amazon EC2 Fedora 13 or Fedora 14 instance.
It is recommended to use one of the official Fedora AMIs.
Incoming connections on port 3566 must be allowed from the IP addresses of all Toad for Cloud Databases client(s), by appropriate use of security groups.