FAQs/Integrations & tracking/Revsure Redshift Integration Implementation Guide
Integrations & tracking · RevSure FAQs

Revsure Redshift Integration Implementation Guide

Short answer

This guide connects Amazon Redshift to RevSure. In Data Hub, add a Redshift source and enter the connection name, AWS region, Redshift type, cluster identifier, database name, and database user, then connect. This links your Redshift warehouse data into RevSure.

1. Navigate to Revsure App

Revsure Redshift Integration Implementation Guide (figure 1)

2. Click "Data Hub"

Revsure Redshift Integration Implementation Guide (figure 2)

3. Click "Data Sources"

Revsure Redshift Integration Implementation Guide (figure 3)

4. Click "Add New"

Revsure Redshift Integration Implementation Guide (figure 4)

5. Select Amazon Redshift from the list of sources

Revsure Redshift Integration Implementation Guide (figure 5)

6. Set the "Connection Name *" field.

Revsure Redshift Integration Implementation Guide (figure 6)

7. Set the AWS Region

Revsure Redshift Integration Implementation Guide (figure 7)

8. Select The Redshift Type

Revsure Redshift Integration Implementation Guide (figure 8)

9. Set the "Cluster Identifier"

Revsure Redshift Integration Implementation Guide (figure 9)

10. Set the "Database Name *" field.

Revsure Redshift Integration Implementation Guide (figure 10)

11. Set the "Database User *" field.

Revsure Redshift Integration Implementation Guide (figure 11)

12. Set the "S3 Staging Bucket *" field.

Revsure Redshift Integration Implementation Guide (figure 12)

13. Fill in the "Redshift IAM Role ARN *" field.

Revsure Redshift Integration Implementation Guide (figure 13)

14. Set the "AWS Access Key ID *" field.

Revsure Redshift Integration Implementation Guide (figure 14)

15. Set the "AWS Secret Access Key *" field.

Revsure Redshift Integration Implementation Guide (figure 15)

16. Click "Connect"

Revsure Redshift Integration Implementation Guide (figure 16)

17. The Connection is created, we can check the Configuration (Credentials)

Revsure Redshift Integration Implementation Guide (figure 17)

18. Next Step - To Set up Workflow
Go to the "Workflow" Tab

Revsure Redshift Integration Implementation Guide (figure 18)

19. Click "New Workflow"

Revsure Redshift Integration Implementation Guide (figure 19)

20. Select the Data base for Extraction

Revsure Redshift Integration Implementation Guide (figure 20)

21. Select the table

Revsure Redshift Integration Implementation Guide (figure 21)

22. Click this checkbox.

Revsure Redshift Integration Implementation Guide (figure 22)

23. Select the columns

Revsure Redshift Integration Implementation Guide (figure 23)

24. Give the Workflow a name, Historical date and Schedule

Revsure Redshift Integration Implementation Guide (figure 24)

25. Click "Save"

Revsure Redshift Integration Implementation Guide (figure 25)
Related answers
Configure Marketo Integration for Agent WritebackReadConversion TrackingReadHow to Add Objects in RevSure Salesforce Data ConnectionRead
Ready when your stack is

Still stuck? Bring it to the session

A RevSure engineer walks your exact setup on a 30-minute working session.

Book a DemoAll FAQs