Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Connecting Amazon Relational Database Service (RDS)

Important!
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.

Amazon Relational Database Services (RDS) is a managed database service that runs on database engines that you're probably already familiar with, like MySQL and PostgreSQL.

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:

  1. Authorize Stitch to access your RDS instance
  2. Create a Linux user for Stitch
  3. Create a database user for Stitch
  4. Enter the connection info into Stitch
  5. Define the Replication Frequency
  6. Select tables and columns to sync

Authorizing Stitch to Access 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:

The Edit Inbound Rules window.
  1. In the management page for the security group, click the Inbound tab.
  2. Click the Edit button. This will display the Edit Inbound Rules window - click the image to the right for a closer look.
  3. In the Type field, select the Custom TCP Rule option.
  4. In the Port Range field, enter the port your database uses. For example, 3306.
  5. In the CIDR, IP or Security Group field, enter the IP address. Below are all the IP addresses that must be added to the security group:
    • 54.88.76.97/32
    • 52.23.137.21/32
    • 52.204.223.208/32
    • 52.204.228.32/32
    • 52.204.230.227/32
  6. To add another rule, click the Add Rule button.
  7. Repeat steps 3-6 until all the Stitch IP addresses have been added.
  8. Click the Save button.

Here's how the security group should look when you're done:

The completed Security Group setup.
Click for a closer look.

Creating a Linux User for Stitch

Need some help?
If you need some help creating the Linux user, refer to these tutorials:

MySQL via SSH
PostgreSQL via SSH

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.

Creating a Database User for Stitch

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.

Entering the Connection Info into Stitch

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:

  • Integration Name - This is the name that will display on the Stitch dashboard for the integration; it’ll also be used to create the schema in your data warehouse.

    For example, the name “Postgres Marketing” would create a schema called postgres_marketing in the data warehouse.
  • Host - This is the public address of your RDS instance. You can find this info in the AWS management console.
  • Port - Some databases have a default port, which will automatically populate the Port field. This info can also be found in our setup documentation for each database. 
  • Database User & Password - This is the username and password of the Stitch database user.

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.

  • Remote address - This is the IP address or hostname of the server we'll SSH into.
  • SSH Port - This is the port of the SSH server.
  • SSH User - This is the username of the Linux (SSH) Stitch user.

In the next step, you'll define the integration's replication frequency and save the connection.

Defining the Replication Frequency

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.

Selecting Tables and Columns to Sync

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.

RELATED

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!