---
title: "Amazon Aurora"
slug: "amazon-aurora"
description: "Connect your data from any source to Amazon Aurora easily with Dataddo! Create secure and reliable data flows in 3 steps. Get started with your data insights."
tags: ["Data warehouse", "Data destination", "How-to guide"]
updated: 2025-08-06T20:01:44Z
published: 2025-08-06T20:01:44Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Amazon Aurora

**Amazon Aurora** (AWS Aurora) is a relational database service provided by Amazon Web Services (AWS). It is designed to be compatible with MySQL and PostgreSQL, offering high performance, scalability, and durability for applications that require a robust and fully-managed database solution in the cloud.

## Prerequisites

          
          

- You have configured AWS VPC.
- You have configured your [Aurora instance](/docs/amazon-aurora#create-an-aurora-instance) and set the network rules by [setting up a security group](/docs/amazon-aurora#set-up-security-group).

## Authorize Connection to Amazon Aurora

### Create an Aurora Instance

1. In the AWS management portal navigate to **RDS**.
2. Click on **Create database** and select **Amazon Aurora**.
3. Configure the settings for new Aurora instance, including the **DB instance identifier**, master **username**, and **password** (you will need this for interaction with [Aurora Shell](/docs/amazon-aurora#configure-aurora-shell)).

#### Set up Security Group

1. On the RDS dashboard, go to the **Security groups** section.
2. Click on **Create Security Group**, provide a name and description, and select the correct VPC for your database.
3. In the inbound rules, select **Add Rule**. For each [Dataddo IP](/docs/network-acl) set Custom TCP Rule. Use CIDR notation (e.g. `52.17.68.150/32`).
4. Click on **Modify** and select the security group to make sure that the Aurora instance is using the right security group.

### Configure Aurora Shell

After the Aurora instance is up and running, connect to it and create additional user to access it from Dataddo. You can use SQL commands similar to those used for MySQL or PostgreSQL.

#### Create an Aurora User

1. Log into Aurora Shell using the [master account credentials](/docs/amazon-aurora#create-an-aurora-instance).
2. Run a command to create a new user.

```
CREATE USER 'dataddo' IDENTIFIED BY '***';
```

#### Set Permissions

1. Log into Aurora shell using the [master account credentials](/docs/amazon-aurora#create-an-aurora-instance).
2. Grant the following privileges on the given database `CREATE`, `SELECT`, `UPDATE`, `INSERT`, `DELETE` on the given database.

```
GRANT CREATE ON database_name.* TO 'dataddo';
GRANT INSERT, UPDATE, DELETE ON database_name.* TO 'dataddo';
FLUSH PRIVILEGES;
```

Make sure to replace the `database_name` value with your actual database.

### In Dataddo

1. On the **Authorizers** tab, click on [Authorize new service](https://app.dataddo.com/service/new) and select **AWS Aurora**.
2. Fill the following fields
  - **DB Host**: Public IP or hostname of your MySQL.
  - **Database**: Name of the database.
  - **Username**: Your [Aurora username](/docs/amazon-aurora#create-an-aurora-user).
  - **Password**: Password to your Aurora user.
  - **Port**: Port to connect to Aurora, the default value is **3306**.
  - **TLS/SSL Setting**: We recommend using the `PREFERRED`, which will use the SSL connection when available. If you are using a self-signed certificate, use `SKIP VERIFY`.
3. [Optional] Configure your destination using an existing SSH tunnel or [create a new one](/docs/ssh-tunnelling).

## Create a New Amazon Aurora Destination

1. On the **Destinations** page, click on the [**Create Destination**](https://app.dataddo.com/destinations) button and select the destination from the list.
2. Select your ***authorizer*** from the drop-down menu.
3. Name your ***destination*** and click on **Save**.

          Need to authorize another connection?

          

Click on **Add new Account** in drop-down menu during ***authorizer*** selection and follow the on-screen prompts. You can also go to the **Authorizers** tab and click on [**Add New Service**](https://app.dataddo.com/service/new).

## Create a Flow to Amazon Aurora

1. Navigate to **Flows** and click on [**Create Flow**](https://app.dataddo.com/flow/new).
2. Click on **Connect Your Data** to add your ***source(s)***.
3. Click on **Connect Your Data Destination** to add the ***destination***.
4. Choose the [write mode](https://docs.dataddo.com/docs/data-storages#write-modes) and fill in the other required information.
5. Check the **Data Preview** to see if your configuration is correct.
6. **Name** your flow and click on **Create Flow** to finish the setup.

---

## Related Articles

- [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages)
- [Write Modes](https://docs.dataddo.com/docs/data-storages#write-modes)
- [Implementation of Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses)
- [Network Access Control List (ACL) Configuration](https://docs.dataddo.com/docs/network-acl)
- [SSH Tunnelling](https://docs.dataddo.com/docs/ssh-tunnelling)
- [Data Transformations](https://docs.dataddo.com/docs/data-transformations)
- [Data Quality Firewall](https://docs.dataddo.com/docs/data-quality-firewall)