User guide

Configure a JDBC Connection
You can use a JDBC connection to connect to your Amazon Redshift cluster from many third-party SQL
client tools.To do this, you need to download a JDBC driver. Follow the steps in this section if you want
to use a JDBC connection.
Topics
• Download the Amazon Redshift JDBC Driver (p. 140)
• Obtain the JDBC URL (p. 140)
• JDBC Driver Configuration Options (p. 142)
Download the Amazon Redshift JDBC Driver
Amazon Redshift offers drivers for tools that are compatible with either the JDBC 4.0 API or the JDBC
4.1 API. For information about the functionality supported by these drivers, go to the Amazon Redshift
JDBC Driver Release Notes.
Download one of the following, depending on the version of the JDBC API that your SQL client tool or
application uses:
• JDBC 4.1–compatible driver: https://s3.amazonaws.com/redshift-downloads/drivers/
RedshiftJDBC41-1.1.2.0002.jar
The class name for this driver is com.amazon.redshift.jdbc41.Driver.
• JDBC 4.0–compatible driver: https://s3.amazonaws.com/redshift-downloads/drivers/
RedshiftJDBC4-1.1.2.0002.jar
The class name for this driver is com.amazon.redshift.jdbc4.Driver.
Then download and review the Amazon Redshift JDBC Driver License Agreement. If you need to distribute
these drivers to your customers or other third parties, please email [e-mail] to arrange
an appropriate license.
Previous JDBC Driver Versions
Download a previous version of the Amazon Redshift JDBC driver only if your tool requires a specific
version of the driver. For information about the functionality supported in previous versions of the drivers,
go to the Amazon Redshift JDBC Driver Release Notes.
These are previous JDBC 4.1–compatible drivers:
• https://s3.amazonaws.com/redshift-downloads/drivers/RedshiftJDBC41-1.1.1.0001.jar
• https://s3.amazonaws.com/redshift-downloads/drivers/RedshiftJDBC41-1.1.0.0000.jar
These are previous JDBC 4.0–compatible drivers:
• https://s3.amazonaws.com/redshift-downloads/drivers/RedshiftJDBC4-1.1.1.0001.jar
• https://s3.amazonaws.com/redshift-downloads/drivers/RedshiftJDBC4-1.1.0.0000.jar
Obtain the JDBC URL
Before you can connect to your Amazon Redshift cluster from a SQL client tool, you need to know the
JDBC URL of your cluster. The JDBC URL has the following format:
API Version 2012-12-01
140
Amazon Redshift Management Guide
Configuring Connections in Amazon Redshift