Allowing Xplenty direct access to relational databases on Amazon Web Services RDS

This article walks you through the process of allowing Xplenty direct access to your databases on RDS. If you'd like to use an SSH tunnel, click here to read more.

You can watch this short video that demonstrates setting up a connection to MySQL RDS in VPC or read below for textual instructions.

 
The security rules are setup with either a VPC or an EC2 instance to provide Xplenty access to the database IP address and port. The default ports for supported databases are:
  • mysql - 3306
  • SQL Server - 1433
  • PostgreSQL - 5432
To verify or modify the security rules of an instance on VPC:

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

  1. View the instance in the RDS Dashboard and click on the Security Group listed in the Security and Network section of the DB Instance pane.

  2. In the Security Group screen, select the Inbound tab.
  3. Add rules for the relevant IP addresses listed here. In each rule select the type of database and enter the port used by the database.
  4. If not, click Edit to change an existing rule or click Add Rule to add the rules.



To configure your database to only accept SSL encrypted connections see http://aws.amazon.com/rds/faqs/#53 for more information.

To verify or modify the security rules of an instance on EC2-classic (RDS not on a VPC):
  1. Open the instance and click on the Security group listed in the Security and Network section of the DB Instance pane.

  2. In the Security Groups screen select the Inbound tab and click Edit.

  3. Modify a rule or Click Add Rule to add each rule.

    Add new rules for each IP address listed in Xplenty's IP addresses list:

    • In the "Type" dropbox, choose Custom TCP rule.
    • In the port range, add the port that your database listens to.
    • In the source dropbox select Custom IP and enter one of the IP addresses.

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