Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. You can connect Quantive to your Redshift instance to sync data from the Redshift data warehouse to build Gtmhub Insights for use in dynamic KRs.
Before you connect to Redshift you must make sure of the following:
Your cluster must be publicly accessible.
Create a database user for Quantive with permission to read database schema and data.
If your Redshift Cluster is part of a VPC you must allow inbound traffic to your VPC from the IP address which Quantive uses to handle data syncs. To do so in your AWS Console go to VPC and then to Security Groups. Find the security group to which your Redshift cluster belongs and add the following inbound rule:
Type: Redshift (5439)
Protocol: TCP (6)
Source: Contact us for information on Quantive's outbound IPs for your account.
How to connect
In Quantive, navigate to Settings > Data Sources screen
Click the Select data source button
From the Choose a connector dialog, select the Databases tab and then Amazon Redshift
Fill in the necessary details. To get your instance address you can check the Endpoint value in your Redshift cluster's dashboard. Take everything up to the port value:5439