1. Log in to your AWS account.

2. On the VPC dashboard, choose Create VPC.

3. For Resources to create, choose VPC and more and perform the following:

1. Name the VPC. 
2. Provide the details according to custom requirements and set the rest to default.
   You will now be able to visualize the relationships between the VPC resources you've configured.
3. When you are finished configuring your VPC, choose Create VPC.

 4.Your VPC connection is set. 

Task 2: Create and Connect to an RDS MySQL Database Instance

Create a Subnet group for the database

1. Navigate to the RDS in the Amazon Console.

2. Navigate to the Subnet groups section and click Create DB subnet group. 

3. On the DB subnet creation page, perform the following:

• Provide your Subnet group name and description.
• Select the above-created VPC identifier.
• Add Availability zones and Subnets, and click Create. 
  While choosing the Subnets, please ensure to exclusively select the private subnets.

 4. A Subnet group will be created. 

Create a MySQL Database 

1. In the Amazon RDS navigation pane, choose Databases.

2. Choose Create database and perform the following:

1. Select the Engine type as MySQL and the Template as Free tier.
2. Provide a Name in the DB instance identifier, a Master username, and create a Master Password.
3. In the Instance configuration section, set Burstable classes to db.t3.micro. 
   This can be configured as per your specific requirements.
4. In the Storage section, select the fields as per requirement. 
   It is recommended to set the Storage Type to General Purpose SSD (gp2).
5. In the Connectivity section, 
   1. Select Don't connect to an EC2 compute resource
   2. Select the above-created VPC and DB subnet groups
   3. Set the Public access to No
   4. Create a new VPC security group for firewall purposes, Name it, and Select an Availability Zone according to your preferences.
   5. Check the Create an RDS Proxy checkbox.
      Keep the rest as default or customize according to your requirements.
       vi. Select your Database Authentication method, Monitoring preferences, and Additional Configuration as per your requirements.
       

3. Now check your Estimated Monthly cost and click on Create Database. A new Database will be successfully created.

---

The steps laid out above are a pre-requisite before you start configuring RDS MySQL as a destination in Daton.

Note

If you wish to connect the destination using Proxy Server or SSH Tunnel, from here on, follow the steps mentioned in this document instead: 

Connecting Database using Proxy Server or SSH Tunnel

 

Set up on Daton

1. Login to Daton web-app.

2. Click on the connectors tab, then go to destination.

3. Find RDS MySQL & click on configure.  

4. Enter any integration name, then click on next.

Note: You don't have to change the VARCHAR size. 

5. Enter the following credentials to configure your warehouse:

1. RDS MySQL JDBC URL in the format: jdbc:MySQL://AmazonRDSMySQL_Database_Endpoint:3306/your_db_name
2. RDS MySQL Master Username and Password.
3. Select Use Tunnel as None.
4. Choose the records column according to your requirement.  
5. Click on next.

6. Select the Schema of your choice.
7. Now hit Submit to complete the setup.