Setting up access to your Amazon Redshift data warehouse is not very complicated and just takes a couple of simple steps. If you don't have an existing account on AWS, you can sign up for a free tier here.

Follow the steps below to set it up for yourself, if you are stuck somewhere, feel free to contact out support team at support@sarasanalytics.com. 

• First make sure that you meet all the Prerequisites.
• Then go to the destination and set up the resources.  
• Then come to Daton and set up the destination.

Prerequisites

Set up on Redshift

Task 1: Grant Cluster Access

Instructions to grant Redshift cluster access and (optionally) creating a user and schema for setting up Redshift as a destination in Daton:

• Access your Amazon Redshift Console.
• Click Clusters from the top left sidebar.
  
• Click on the specific Cluster.
  
• In the Configuration tab of the details page, note down the Redshift Hostname and Port from the Endpoint. This will be used on the Daton integration page.
• In the Configuration tab of the details page, under the VPC security groups, click the name of the security group.
  
• On the details page, click the Inbound tab, and click Edit.
  

IP Whitelisting

Make Instance Publicly Accessible

• Click on Actions and Modify publicly accessible setting and then set the instance to be publicly accessible

Task 2: Create a User and Schema for Daton

To enable Daton to write to a specific dataset, create a user for the relevant Amazon Redshift Dataset:

• Access your Amazon Redshift Console.
  Click the Query editor and run the below commands to grant privileges to Daton. Change the user, password, and db-name per your choice.
  

CREATE USER daton WITH PASSWORD 'yourpassword';

CREATE SCHEMA daton AUTHORIZATION daton;

GRANT CREATE ON DATABASE db-name to daton;

That's it, you're done configuring access — time to connect to Amazon Redshift.

Task 3: JDBC URL and other configuration parameters

• Click Clusters from the left menu and click on the cluster name to view the cluster details.

• Scroll down to see the JDBC URL details and note them. This URL is required along with the database username and password while integrating Redshift on Daton.

The steps laid out above are a pre-requisite before you start configuring Redshift as a destination in Daton.

Setup on Daton

1. Login to Daton web-app.

2. Click on the connectors tab, then go to destination.

3. Find Amazon Redshift & click on configure.  

4. Enter any integration name.

4. Enter the following details:

• JDBC URL: Check task 3, step 2 
• Redshift User: This is the same as master username, check task 3, step 2.
• Password: The password you created. 
• Use Tunnel: None
• Then click on next. 

5. Select the Schema of your choice.

6. Click finish to complete the setup.

Replication Guide

Daton has been built to handle multiple data warehouses. Since all data warehouses are not built the same, the choice of a data warehouse may impact how Daton loads data. This section tables some key capabilities and limitations of RedShift that impact how data looks in your data warehouse.