Redshift Connection

Redshift is a cloud-based data warehousing service provided by Amazon Web Services (AWS).

It is particularly useful for businesses and organizations that deal with vast amounts of data and need fast and scalable solutions for data storage and analysis.

Establish a connection between Gathr and Redshift. Configure the necessary connection parameters to establish a secure and reliable connection to the Redshift database.

Connection Configuration #

Each connection property available in the Redshift connector is explained below.

Connection Name #

The name of the connection to be created should be provided. This is the name that will display on the list of available connections.

Connection Type #

Option to choose between either connecting securely using SSH Tunnel or, proceed with a Direct Connection when connecting to Redshift.

If Connection Type value is SSH Tunnel, additional fields will be displayed.

To know more about SSH Tunneling with Gathr, see SSH Tunneling

SSH Tunnel #

If SSH Tunnel is selected, additional configuration parameters will get listed.

SSH Key #

The SSH key should be provided to authenticate the associated SSH host and SSH user.

SSH Host #

Public IP address of your SSH host.

SSH User #

Default SSH username.

If Connection Type value is Direct Connection, then proceed by updating the following fields.

Driver Type #

The version of the JDBC (Java Database Connectivity) driver to be used for establishing the connection with Redshift.

The available options are: JDBC 4.0, JDBC 4.1, and JDBC 4.2.

Choose the suitable JDBC driver version. Ensure that the JDBC driver version chosen is compatible with the version of the Redshift cluster to be connected.

Enable SSL #

When checked, this option enables SSL encryption for the connection between Gathr and Redshift.

SSL encryption adds an extra layer of security by encrypting data transmitted between Gathr and Redshift server.

Upload Keystore File #

If SSL is enabled, upload the keystore file required for SSL encryption.

The keystore file contains cryptographic keys and certificates necessary for establishing a secure SSL connection with Redshift.

Database Name #

Specify the name of the database in Redshift that you want to connect to. This should be the name of the database where your tables and data reside.

Host Name #

Enter the hostname or the endpoint of your Redshift cluster.

This is the network address of your Redshift cluster where Gathr will establish the connection.

Port Number #

Provide the port number used by your Redshift cluster for incoming connections.

The default port for Redshift is 5439, but ensure it matches the configuration of your specific Redshift cluster if it’s been modified.

Username #

Provide the username associated with your Redshift account.

This username should have the necessary permissions to access the specified database and perform the required operations.

Password #

Enter the password corresponding to the username provided above.

After entering all the details, click on the TEST button.

If the connection service identification and authentication details are provided correctly, a success message stating “connection available” is generated. Click on the CREATE button to save the changes.

If the details are incorrect or the server is down, you will get a message “Connection unavailable”.