Set up Instructions for RDS PostgreSQL Destination

This subtopic provides step-by-step instructions to integrate an Amazon RDS for PostgreSQL database with Daton as a destination, detailing the prerequisites and the integration process.

Set up Instructions for RDS PostgreSQL Destination

This subtopic provides step-by-step instructions to integrate an Amazon RDS for PostgreSQL database with Daton as a destination, detailing the prerequisites and the integration process.

Setting up access to your PostgreSQL data warehouse is not very complicated and just takes a couple of simple steps.

Follow the steps below to set it up for yourself, if you are stuck somewhere, feel free to contact out support team at support@sarasanalytics.com.

First make sure that you meet all the Prerequisites

Then go to the destination and set up the resources.

Then come to Daton and set up the destination.

Prerequisites

Before you get started, ensure you have the following:

Active Daton and AWS account
Administrative user for your AWS account to create or configure a Daton-specific RDS PostgreSQL database

Set up on PostgreSQL

Task 1: Configure a VPC security connection for Amazon RDS PostgreSQL

Log in to your AWS account.
On the VPC dashboard, choose Create VPC.
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.
Your VPC connection is set.

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

Create a Subnet group for the database

Navigate to the RDS in the Amazon Console.
Navigate to the Subnet groups section and click Create DB subnet group.
On the DB subnet creation page, perform the following:
1. Provide your Subnet group name and description.
2. Select the above-created VPC identifier.
3. Add Availability zones and Subnets, and click Create.
  While choosing the Subnets, please ensure to exclusively select the private subnets.
A Subnet group has been created.

Create a PostgreSQL Database

In the Amazon RDS navigation pane, choose Databases.
Choose Create database and perform the following:
1. Select the Engine type as PostgreSQL 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,
  - Select Don't connect to an EC2 compute resource
  - Select the above-created VPC and DB subnet groups
  - Set the Public access to No
  - Create a new VPC security group for firewall purposes, Name it, and Select an Availability Zone according to your preferences.
  - 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 PostgreSQL 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 PostgreSQL & click on configure.

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

5. Enter the following credentials to configure your warehouse:

RDS PostgreSQL JDBC URL in the format: jdbc:postgresql://AmazonRDSPostgreSQL_Database_Endpoint:3306/your_db_name
RDS PostgreSQL Master Username and Password.

Select Use Tunnel as None.
Click on next.

6. Select the Schema of your choice.

7. Now hit Submit to complete the setup.

Table of Contents

Prerequisites Set up on PostgreSQL Task 1: Configure a VPC security connection for Amazon RDS PostgreSQL Task 2: Create and Connect to an RDS PostgreSQL Database Instance Create a Subnet group for the database Create a PostgreSQL Database Note Set up on Daton

Set up Instructions for RDS PostgreSQL Destination

Saras Pulse

Saras Daton