Redshift Connection

This is a step-by-step tutorial for creating a Redshift connection.

Prerequisite

To connect to Redshift, you must whitelist our IPs.

Connection Procedure

1. Type in the Connection Name.
2. Enter your Host name.
3. Fill in your Port.
4. Enter your Username and Password.
5. Use the Test Connection function to see if your connection is up to the task.
6. If the connection succeeded, you can now use this connection in Rivery.

SSL Options

Key File

To establish an SSL connection and authenticate your Redshift user, you have the option to use a key file (.pem).

SSH (Optional)

Secure Shell Protocol (SSH) is used to provide secure and encrypted access to internal databases from Rivery servers in order to retrieve data.

Configure your SSH Tunnel server in your network to use SSH Tunneling via Rivery. This server will be able to connect to your database server via the internal IP or address, and will accept SSH connections from Rivery IPs. Rivery uses a key file to connect to the SSH server.