Check out our step-by-step video showing how to connect Amazon RDS to Chartio:

RDS Security Groups

For Chartio to connect to your Amazon RDS database, you’ll need to modify your RDS Security Group to whitelist Chartio’s inbound IP address. To view your Security Groups, access your RDS Dashboard.

Add a new Inbound Rule

  1. From the AWS Management Console, click Services > EC2 > Network & Security > Security Groups.
  2. Next, you’ll need to edit the Security Group you want to use.
    • If you have an existing Security Group you’d like to modify…
      Select it from the list then click Actions > Edit Inbound Rules.
    • If you don’t have a Security Group yet
      Click Create Security Group to add a new one.
  3. Select the Inbound tab then click Add Rule, completing the CIDR (Classless Inter-Domain Routing) form and allowing incoming connections.
    • For the Port Range, use the corresponding port number for your database type:
      • MySQL or MariaDB: 3306
      • Postgres: 5432
      • SQL Server: 1433
      • Oracle: 1521
    • For the IP address, use 52.6.1.1/32
  4. Click Apply (for existing Security Groups) or Create (for new Security Groups) to save your new rule.

Connect your new Security Group to your RDS database

If you created a new Security Group, you need to apply it to your RDS database.

  1. Click Databases > {your database instance name} > Modify.
  2. Scroll to the Network & Security section.
  3. Select your newly created Security Group from the list to add it.
  4. Click Continue.
  5. Under Scheduling of modifications, select when you’d like to apply your changes:
    1. If you choose Apply immediately, your changes are applied right away.
    2. If you choose Apply during the next scheduled maintenance window, you can minimize the risk of possible downtime to your database instance.
  6. Click Modify DB Instance to apply your changes. You’ll be taken back to your database instance’s summary page, where your newly added Security Group should appear under the VPC security groups.

Endpoint and port number

From your database instance’s summary page, copy the RDS endpoint and port number from the Connectivity & security tab. You’ll need this information to complete Chartio’s RDS data source connection form.

RDS dashboard provides needed details

Create a read-only user

Adding Chartio’s external IP to your Security Group allows our server to connect to your RDS instance; however, you still need to provide read-only credentials for authentication. The steps for creating this read-only user depends on your database type. In our video example above, we create a read-only user for a MySQL database.

Connect your data source to Chartio

You’re nearly done! Now that you have all the info, provide the required information to the RDS data source connection form. Paste the endpoint and port number you copied previously and supply the credentials for your read-only user. As you complete each field, Chartio verifies the information you’ve provided with your server. If there are any problems, Chartio displays an error to help you troubleshoot.

After you’ve provided the required fields, click Connect.

The final step in connecting your RDS data source is to apply your schema. Go to the Schema tab, review the schemas, make changes as needed, then click Apply when you’re done.

Now you can start exploring the data of your RDS instance in Chartio!