Amazon Redshift User Manual

• JDBC http://jdbc.postgresql.org/download/postgresql-8.4-703.jdbc4.jar
• ODBC (versions below or later)
• 32-bit http://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_08_04_0200.zip
• 64-bit http://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_09_00_0101-x64.zip
To use SQL Workbench/J with a JDBC driver
1. Launch SQL Workbench/J with the 32-bit or 64-bit version that matches your operating system
version.The Select Connection Profile dialog appears.
2. Type a name for your connection profile that will appear in the navigation pane.
3. In the Driver box, click PostgreSQL (org.postgresql.Driver).
4. When a message appears saying that the library for the driver is not available, click Yes.
5. Click the browse icon [...] next to the Library box, navigate to the location of the driver, and then
click it. SQL Workbench/J automatically completes the Classname box. Leave the Sample URL
box blank, and then click OK.
6. In the Amazon Redshift console, locate the connection string that corresponds to the driver you've
selected. In this example, we're using the JDBC driver. Copy the JDBC URL. In the Select Connection
dialog box, in the URL box, paste the JDBC URL.
API Version 2012-12-01
97
Amazon Redshift Management Guide
Setting Up the SQL Workbench Client

Amazon Redshift Specifications

General

Provider	Amazon Web Services (AWS)
Query Language	SQL
Data Storage	Columnar storage
Security	Encryption at rest and in transit, VPC, IAM
Backup	Automated and manual snapshots
Deployment	Cloud-based
Type	Cloud-based data warehouse service
Primary Use	Data warehousing, analytics
Integration	Integrates with AWS services, BI tools, and ETL tools
Pricing Model	On-demand and reserved instance pricing
Data Compression	Columnar storage with data compression
Performance Optimization	Query optimization