Allowing Xplenty access to my Redshift cluster

Connect Xplenty to your Redshift cluster in order to write data to it, or read data from it. Watch this short video tutorial or read below for further instructions:

In Redshift console


Start by verifying or modifying the security rules of an instance on VPC:

Note: You must provision the cluster with Publicly Accessible set to the value Yes.

  1. View the instance in the Redshift Dashboard and click on the Security Group.
  2. In the Security Group screen, select the Inbound tab.
  3. There should be rules for the IP addresses listed here. In each rule select the type of database and enter the Redshift port.
  4. If not, click Edit to change an existing rule or click Add Rule to add the rules.

To configure your cluster to only accept SSL encrypted connections:

If you created the cluster with a default parameter group, create a new parameter group and modify the cluster to associate to that parameter group. Then access the parameter group and edit it to set require_ssl to true.

To verify or modify the security rules of an instance on EC2-Classic (without VPC):

In your Redshift Cluster Security Group, modify a rule or add a new rule for each IP address listed here:

  • In the Connection Type dropbox, choose CIDR/IP.
  • In the CIDR/IP to Authorize field, enter the IP addresses from this list.

Create a Redshift user

  • Create a Redshift user.
  • Grant it the following permissions:
    • If you intend to only append data into a table, give the user minimal permissions required to execute the COPY command.
    • If you intend to merge data into a table, give the user minimal permissions required to execute the COPY command, create a table, and insert and update to your target tables.
    • Note that truncate requires Xplenty to either be the owner of the target table or have supseruser access
    • .

To define a connection in Xplenty to Amazon Redshift

  1. Click your avatar, then click Account settings.
  2. Click Connections, then click new connection and click Amazon Redshift.
  3. Type a name for the connection.
  4. If you allow direct access from Xplenty's IP addresses, enter the hostname and port. If direct access it not allowed, read more about setting a tunnel connection here.
  5. Enter the user name and password you created for Xplenty to use.
  6. Enter the default database to use. If you leave it empty, the user's default database will be used.
  7. Set the region to the AWS region in which the Redshift cluster was created. If the region requires AWS Signature v4 (see list here) you may need our support team's help with allowing Xplenty access to read from this Amazon Redshift connection.
  8. Click test connection. If the credentials are correct, a message that the cloud storage connection test was successful appears.
  9. The connection is created and appears in the list of connections.

Connectivity And Security

  1. Allowing Xplenty access to data on Amazon S3
  2. Allowing Xplenty access to my Redshift cluster
  3. Allowing Xplenty access to my data on Google AdWords
  4. Allowing Xplenty access to my data on Google Analytics
  5. Allowing Xplenty access to my Google BigQuery dataset
  6. Allow Xplenty access to my Google Cloud Spanner instance
  7. Allow Xplenty access to my data on Google Cloud Storage
  8. Allowing Xplenty access to my data on Hadoop Distributed File System (HDFS)
  9. Allowing Xplenty access to my server behind a firewall
  10. Allowing Xplenty direct access to relational databases on Amazon Web Services RDS
  11. Allowing Xplenty access to MongoDB
  12. Importing Heroku Connections
  13. Allowing Xplenty access to my data on Bing Ads
  14. Allowing Xplenty access to Azure SQL Databases
  15. Allowing Xplenty access to my data on Secure File Transfer Protocol (SFTP)
  16. Allowing Xplenty access to Facebook Ads Insights data (Beta)
  17. Allow Xplenty access your data on Salesforce
  18. Allowing Xplenty access to NetSuite
  19. Allowing Xplenty access to my data on Intercom
  20. Set up a reverse SSH tunnel from Windows
  21. Allowing Xplenty access to my data on Xero (Beta)
  22. Allow Xplenty access to my data on Azure Blob Storage
  23. Allowing Xplenty access to my Snowflake account
  24. Allowing Xplenty access to my data on YouTube
  25. Allowing Xplenty access to my data on Google Sheets
  26. Allowing Xplenty access to my data on Linkedin
  27. Allowing Xplenty access to my data on Instagram
  28. Allowing Xplenty access to my data on Shopify
  29. Allowing Xplenty access to my data on Pinterest
  30. Allowing Xplenty access to my Amazon Athena instance
  31. Allowing Xplenty access to my data on Xero

Feedback and Knowledge Base