# How to Integrate Amazon Aurora with Daton

### Prerequisites

Before we get started, make sure you have:

* An AWS Aurora and a Daton account
* AWS Aurora Host Name
* AWS Aurora Port Number
* AWS Aurora User Name
* AWS Aurora User Password
* AWS Aurora Database Name

### Integrate your Amazon Aurora MySQL Database with Daton

1. [Log in](https://daton.sarasanalytics.com/login) to your existing Daton account and search for Amazon Redshift in the list of Connectors, then click **Configure**.
2. Enter the following details and click **Authenticate**: 

   * Integration Name 
   * Replication Frequency 
   * Replication Start Date 

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2Fypl67o3l61SaWLt60LB1%2F1Aurora%20Source.png?alt=media&#x26;token=1c735cfc-3c47-4515-8a27-4c996195f4bd" alt=""><figcaption></figcaption></figure>

   **Note** that the Integration Name will be used to create the integration tables and cannot be modified later.
3. **Select** your Amazon Aurora Database Schema(s) data to be replicated. For the same, provide the following credentials and click **Next.**&#x20;

   * AWS Aurora Host Name
   * AWS Aurora Port Number
   * AWS Aurora User Name
   * AWS Aurora User Password
   * AWS Aurora Database Name

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FQbvLAVbkYu8OgbYU6n2k%2F2Aurora%20Source.png?alt=media&#x26;token=2a15dcdb-1309-490c-af7e-a7bd1a532e72" alt=""><figcaption></figcaption></figure>

   You can also secure your authentication by SSH tunneling.&#x20;

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FFoUCNqTyboly9QupkXIf%2F6Redshift%20Source%20SSH.png?alt=media&#x26;token=20ac1c78-cf96-4f77-b9da-100c530fa59c" alt="" width="375"><figcaption></figcaption></figure>

   For further information, refer to the FAQs section on ["How to Enable SSH Tunneling during a Database Source Authentication?"](https://daton-sarasanalytics.gitbook.io/daton/faqs/faqs/how-to-enable-ssh-tunneling-during-a-database-source-authentication)
4. Post Database Authentication, you will be prompted to choose schemas from the list. **Select** the desired Schemas and click **Next.** &#x20;

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FXtPMg5xIoutXi32Dw2GE%2F3Aurora%20Source.png?alt=media&#x26;token=9798eb11-3bac-4331-b8d0-812a94afad64" alt=""><figcaption></figcaption></figure>
5. **Select** all the Tables as per requirement and **Configure** the schema that you wish to create in the destination before clicking the **Next** button.&#x20;

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FvS3XSrkZsxUvnb85lg90%2F4Aurora%20Source.png?alt=media&#x26;token=0324fa58-b5ec-4635-86dc-3e30007f4bda" alt=""><figcaption></figcaption></figure>

   Note:&#x20;

   * You will have to check at least one Table from each of the previously selected Schemas to proceed further.&#x20;
   * You can also customize the replication frequency and replication start date of each desired table separately. You may find this functionality under the advanced settings of every selected table.
6. Select all the Columns you require for each table and **Submit** the integration. <br>

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FjMyAdbaMVOQHnywR4UJm%2F5Aurora%20Source.png?alt=media&#x26;token=ef8d5b50-9bcf-4147-8147-7551cbec9e26" alt=""><figcaption></figcaption></figure>

   It's recommended to select a replication field for each of the tables. Selecting **'None'** will lead to full table replication. Learn more about [Replication Fields](https://daton-sarasanalytics.gitbook.io/daton/platform/features/data/data-replication-in-daton/replication-fields) here.

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FLKk3uVWN3etl29L1MAk0%2FRedshift%20Source.png?alt=media&#x26;token=09b5d5ed-79d9-4ab8-9d0e-b511e49afe0f" alt="" width="375"><figcaption></figcaption></figure>

   \
   **Note** that you will be prompted to select the destination for your Database.
7. Select the destination for your source and click **Confirm**. An integration successful message will be displayed.

## Important Note

* Integrations would begin in the Pending state and change to the Active state once the first job successfully loaded data into the configured warehouse.&#x20;
* Users can check job status and process logs from the integration details page by clicking on the integration name in the active list.&#x20;
* Users can Re-Authenticate, Edit, Clone, Pause, or Delete the integration at any moment by clicking on settings. You can also adjust the frequency and history of the integration.&#x20;
* On the Sources page, click Integration to access each table in your integration. The page also shows the state of each table, the last replicated time, and the Reload access buttons.&#x20;