Configuring an Amazon RDS Data Source
Introduction
Amazon RDS is a cloud database service. This service allows you to host a relational database in the cloud. The type of database (RDBMS) is one of:
- MySQL
- PostgreSQL
- Oracle
- SQL Server
Explore Analytics supports all four. To configure an RDS database you should follow the corresponding instructions for configuring a data source for one of these types of databases.
When configuring a data source, choose the "Direct" connection method. It means that Explore Analytics will connect to the database directly.
In this page, we discuss technical aspects that are unique to RDS, and provide instructions to make your installation successful.
Before Setting Up the Data Source
Before setting up the data source in Explore Analytics, you must authorize Explore Analytics to connect to your database. To do that you need to add a rule in your database security group to allow access from Explore Analytics.
Using the Amazon AWS Console, go to RDS and find the DB Security Group. The security groups define connections that are permitted to your database. To authorize Explore Analytics, you'll need to add a new connection. For "Connection Type", select "EC2 Security Group". Explore Analytics runs on Amazon AWS. In the next column, where it shows the account id, click change and enter the account id of Explore Analytics (966092105153