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.

When working with an application that uses Redshift as both a data source and target, ensure the following points are met:

  • The region of the Redshift data source connection and the S3 bucket used for staging data must be the same.

  • The S3 bucket used for staging data can belong to a different AWS account, but for the data source, it must be in the same region as the Redshift connection.

  • The same S3 connection used in the Redshift data source for staging data must also be used in the Redshift target configuration. Using different connections will cause the application to fail.

  • If the S3 connection is Role ARN-based, it should only be used if deployment preference is Gathr cluster and not any other registered environments.

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.

Scope

Define the connection scope to customize their accessibility.

  • Organization: Accessible to organization users across all Gathr projects for usage in applications.

  • Project: Accessible to organization users limited to projects that are specified by the connection owner for usage in applications.

  • Private: Accessible only to the connection owner for usage in applications.

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”.

If you have any feedback on Gathr documentation, please email us!

← Redis ETL Target
Redshift Ingestion Source →