• Home
• Download
• Features
• Purchase
• Screen Shots/Videos
• Support
• Contact

Redshift Connection Help

RazorSQL ships with the JDBC drivers necessary to connect to Redshift databases. It ships with the PostgreSQL JDBC driver and can download and install the Redshift JDBC driver. Both drivers support connecting to Redshift.

NOTE: Amazon databases like Redshift or other databases supported by Amazon RDS require certain security configurations to allow an end-user to make a connection to the database. This includes allowing the IP address of the end-user's machine access to the Redshift database. This configuration can be done via the security groups section of the AWS control panel.

Connecting to Redshift via JDBC

To connect to a Redshift database, select the JDBC (PostgreSQL Native Driver) or JDBC (Redshift Driver) connection type from the connection type list.

NOTE: To connect to Redshift using AWS IAM credentials such as an access key, secret key, and/or session token, the Redshift JDBC driver needs to be used. The PostgreSQL JDBC driver does not support connecting to Redshift via the AWS IAM credentials. NOTE: Version 8 or later of RazorSQL is required to connect to Redshift via IAM credentials.

Connecting to Redshift using a Redshift User and Password

Both the PostgreSQL driver that ships with RazorSQL and the Redshift driver that RazorSQL provides an auto-download option for can be used to connect to Redshift with a Redshift user and password.

To connect, enter any login information if applicable, and then enter the host or ip address of the Redshift server, and the port the Redshift server is listening on. The default port is 5439. Next, enter the name of the Redshift database to connect to. If you would like SSL encryption to be used between your machine and the Redshift database, select the "True" value in the "Enable SSL Encryption" drop-down.

Connecting to Redshift using AWS IAM Security Credentials

NOTE: Version 8 or later of RazorSQL is required to connect to Redshift via IAM credentials.

To connect to Redshift using AWS IAM security credentials like an access key, secret key, or optional session token, the Redshift JDBC driver must be used. The Redshift driver is the second option in the "Connection Type" list in RazorSQL.

After selecting the Redshift driver as the connection type, Click the "Auto-Download" driver if RazorSQL has not yet downloaded and installed the Redshift driver on your machine.

For the Authentication Type, select the "AWS IAM Credentials" radio button. Enter the access key and secret key. If the AWS credentials are temporary credentials, the session token is also required. The Database User field is also required if using AWS credentials. This needs to be the user name of an actual user configured on the Redshift database that the IAM credentials provide access to.

Next, enter the host or ip address of the Redshift server, and the port the Redshift server is listening on. The default port is 5439. Next, enter the name of the Redshift database to connect to. If you would like SSL encryption to be used between your machine and the Redshift database, select the "True" value in the "Enable SSL Encryption" drop-down.