Skip to main content

Amazon Redshift

Setup an Amazon Redshift Cluster​

  • Login to your amazon console.
  • Search for Redshift service under services.

Redshift

  • Select create cluster.

Cluster

  • Fill in the details and select create (it will take a few minutes to create a new cluster).

creatingCluster

  • Go to properties in the cluster and enable your ip in security group inbound rule with a type Redshift.

Properties

EditInbountRules

saveRules

  • Go to editor tab in the cluster and create a new database connection specifying the database name and authorised user.

ConnectDatabase

insertCredentials

  • Now go back to clusters and click on actions tab and click modify publicly accessible setting.

Actions

Enable

  • Now click on enable checkbox and click save changes (Takes some time to reflect in the cluster).

Setting up your Amazon Redshift storage on CloudTDMS​

Open the storages tab and insert the following values for your new Amazon Redshift storage

  • Name: Name for the storage.
  • Hostname: Endpoint of your Redshift cluster.
  • Username: Redshift cluster username.
  • Password: Redshift cluster password.
  • Database: Redshift cluster database name.
  • Port: Redshift cluster port. (default is 5439)