Connecting with SQL Workbench/J - Amazon Redshift

Connecting with SQL Workbench/J

You can connect to a database using SQL Workbench/J, a free, DBMS-independent, cross-platform SQL query tool.

Amazon Redshift doesn't provide or install any third-party SQL client tools or libraries, so you must install any that you want to use with your database. To install SQL Workbench/J, follow the instructions in the SQL Workbench/J documentation (SQL Workbench/J). In general, to use SQL Workbench/J, you do the following:

  • Review the SQL Workbench/J software license.

  • Download the appropriate SQL Workbench/J package for your operating system on your client computer or Amazon EC2 instance.

  • Install SQL Workbench/J on your system.

    Have the Java Runtime Environment (JRE) installed on your system. Ensure you are using the correct version of the JRE required by the SQL Workbench/J client.

  • Connect to your database over a JDBC connection in SQL Workbench/J.

    Make sure that your client computer or Amazon EC2 instance has the recommended Amazon Redshift JDBC driver. For links to download the latest drivers, see Download the Amazon Redshift JDBC driver, version 2.1. Also, make sure you have configured firewall settings to allow access to your database. For more information, see Step 4: Authorize access to the cluster in the Amazon Redshift Getting Started Guide.

  • Create a new connection profile in SQL Workbench/J that uses the Amazon Redshift driver.