Skip to main content
This article walks you through the process of allowing Integrate.io ETL 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 Integrate.io ETL access to the database IP address and port. To verify or modify the security rules of an instance on VPC:
1
Open the instance in the RDS Dashboard in the Connectivity & Security section of the DB Instance pane.
2
Verify that Publicly Accessible is set to the default value Yes.
3
Click the Security Group listed.
RDS instance Connectivity and Security section with security group link
4
In the Security Group screen, select the Inbound tab. Then click Edit inbound rules.
Security Group inbound rules tab with Edit inbound rules button
5
Click Add rule to add the IP addresses listed here. Create a rule for each of the IP addresses: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.The default ports for supported databases are:MySQL - 3306
SQL Server - 1433
PostgreSQL - 5432.
6
Click Save rules.
Inbound rules configured with custom TCP rules for Integrate.io IP addresses
To configure your database to only accept SSL encrypted connections see https://aws.amazon.com/rds/faqs/#53 for more information.
Last modified on May 22, 2026