This doc describes how to connect an RDS instance as an input data source. If you'd like to connect Postgres as a data warehouse, please refer to the Connecting a Postgres-RDS Destination guide.
The steps for connecting your RDS instance vary slightly depending on the type of database you're using - use the links in the previous paragraph for detailed instructions for each database - and whether or not you're using an encrypted connection (like an SSH tunnel for MySQL), but we'll cover the gist of it in this article.
Some steps require some tech expertise and familiarity with the AWS management console. So, if you're not too tech savvy, we recommend looping in someone who is. You'll need to complete the following to connect your RDS instance:
For Stitch to successfully connect with your RDS instance, you'll need to add our IP addresses to the appropriate database security group via the AWS management console. The IP addresses can be added to an existing group or you can create a new one. The important thing is that the group is authorized to access the instance you want to connect to Stitch.
To do this, an inbound security rule must be created for each of our IP addresses:
Here's how the security group should look when you're done:
This step is only required if you're using an encrypted connection. For instructions on how to retrieve our Public Key and create the user, refer to the setup article for the database you're using (ex: MySQL). The Linux user will allow us to create an SSH tunnel, which is the safest method of sending data over the internet.
This is the part of the process where the steps will vary depending on the database you're using. The idea is the same, though: you'll create a user for Stitch which we'll use to access your database. Instructions for creating a database Stitch user can be found in the setup article for the database you're connecting.
After you've granted Stitch access to your RDS instance and created a user for us, the last thing you'll need to do is enter the connection info into Stitch.
To do this, begin by clicking the Add an Integration button on the Stitch dashboard page.
When the list of integrations displays, click the icon for the database you're using.
To finish creating the connection, here's what you need to enter in the credentials page:
postgres_marketingin the data warehouse.
Additionally, if you're using an encrypted connection, select the SSH option from the Encryption Type dropdown. This will display additional fields for setting up the encryption.
In the next step, you'll define the integration's replication frequency and save the connection.
The Replication Frequency controls how often Stitch will attempt to replicate data from your data warehouse. By default, the frequency is set to 30 minutes, but you can change it to better suit your needs:
When you're finished, click the Save Integration button to complete the setup.
Now that your RDS instance is connected to Stitch, the next step is selecting the tables and fields you want to sync.
If you're missing tables or some have a Sync Status of Unsupported, try these troubleshooting tips.