User guide

2. Go to the Installing and starting SQL Workbench/J page. Follow the instructions for installing SQL
Workbench/J on your system.
Note
SQL Workbench/J requires the Java Runtime Environment (JRE) be installed on your system.
Ensure you are using the correct version of the JRE required by the SQL Workbench/J
client. To determine which version of the Java Runtime Environment is running on your
system, do one of the following:
• Mac: In the System Preferences, click the Java icon.
• Windows: In the Control Panel, click the Java icon.
• Any system: In a command shell, type java -version.You can also visit http://
www.java.com, click the Do I Have Java? link, and click on the Verify Java button.
For information about installing and configuring the Java Runtime Environment, go to http://
www.java.com.
Connect to Your Cluster over a JDBC Connection in SQL Workbench/J
Before you perform the steps in this procedure, make sure that your client computer or Amazon EC2
instance has the recommended Amazon Redshift JDBC driver. For more information, see Configure a
JDBC Connection (p. 140).
To use a JDBC connection in SQL Workbench/J
1. Open SQL Workbench/J.
2. Click File, and then click Connect window.
3. Click Create a new connection profile.
4. In the New profile box, type a name for the profile. For example, examplecluster_jdbc.
5. Click Manage Drivers. The Manage Drivers dialog opens. In the Name box, type a name for the
driver.
Click the folder icon next to the Library box, navigate to the location of the driver, click it, and then
click Open.
API Version 2012-12-01
163
Amazon Redshift Management Guide
Connecting to Clusters From Client Tools and Code