Revsure Redshift Integration Implementation Guide
Learn how to set up a new AWS Redshift data source connection in RevSure. This guide also walks you through creating a new job workflow to fetch tables from Redshift.
Navigate to RevSure App
Click "Data Hub"
Click "Data Sources"
.png)
Click "Add New"
.png)
Select Amazon Redshift from the list of sources
.png)
Set the "Connection Name" field.
.png)
Set the AWS Region
.png)
Select The Redshift Type
.png)
Set the "Cluster Identifier"
.png)
Set the "Database Name " field.
.png)
Set the "Database User " field.
.png)
Set the "S3 Staging Bucket *" field.
.png)
Fill in the "Redshift IAM Role ARN *" field.
.png)
Set the "AWS Access Key ID *" field.
.png)
Set the "AWS Secret Access Key *" field.
.png)
Click "Connect"
.png)
The Connection is created, we can check the Configuration (Credentials)
.png)
Next Step - To Set up Workflow
Go to the "Workflow" Tab
.png)
Click "New Workflow"
.png)
Select the Data base for Extraction
.png)
Select the table
.png)
Click this checkbox.
.png)
Select the columns
.png)
Give the Workflow a name, Historical date and Schedule
.png)
Click "Save"
.png)