Connecting an Amazon Relational Database Service (RDS) Database
If your database is stored on Amazon RDS there are a few extra considerations you'll have to take in connecting it to Chartio. First, you cannot use the Chartio connection client—you'll need to use the direct connection method instead. Second, Amazon has some unique security group settings that mean you'll need to explicitly enable access to a Chartio server. The following documentation will walk you through those steps.
RDS Security Groups
In order for Chartio to connect to your database, your RDS security group needs to be modified in order to white-label Chartio's inbound IP address. To view your security groups, access your RDS Dashboard.
Navigate to DB Security Groups from the left sidebar and select one of your security groups. A form for a CIDR will be presented. Paste the Chartio CIDR: 18.104.22.168/32 into the form and click Add to add Chartio to your security group.
Note to VPC Users: If you're using the Amazon Virtual Private Cloud (VPC) you'll need to set up an elastic IP for your RDS instance to make it accessible to Chartio's servers outside your VPC.
You will use your Amazon RDS endpoint and port number from the Instances section of your RDS Dashboard in the Host and Port fields when connecting your data source.
Connecting Your Data Source
Adding Chartio's external IP to your Security Group will allow our server to connect to your RDS instance. However, you will still need to provide read-only credentials for authentication. Please follow the individual instructions for your database platform MySQL, PostgreSQL, SQL Server, or Oracle.