> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/databases/amazon-redshift/how-to-integrate-amazon-redshift-with-daton.md).

# How to Integrate Amazon Redshift with Daton

### Prerequisites

Before we get started, make sure you have:

* An AWS and Daton account
* Database name, Hostname, and Password
* Port Number (usually `5439`)

### Integrate your Amazon Redshift 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="/files/JukIIKXOd1vQfcsRkDfJ" 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 Redshift Database Schema(s) data to be replicated. For the same, provide the following Redshift credentials and click **Next.**&#x20;

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

   <figure><img src="/files/nBJ8z5i9Wgdoz2CvjdQ3" alt=""><figcaption></figcaption></figure>

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

   <figure><img src="/files/Mb2rsGyxDRuaE1Jc4ncv" alt="" width="375"><figcaption></figcaption></figure>

   To know more read, [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="/files/SyrlyQAilYZD58wrRcNQ" 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="/files/upqjHyFN5TTyeSAe8wzf" 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.
   * Select all the Columns you require for each table and **Submit** the integration. <br>

     <figure><img src="/files/kTJzHlwBRA3tfGo77gge" 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](/daton/platform/features/data/data-replication-in-daton/replication-fields.md) here.

     <figure><img src="/files/xgbWCEtg7VDWUXyxE51j" alt="" width="375"><figcaption></figcaption></figure>

     \
     **Note** that you will be prompted to select the destination for your Database.
6. 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 Reload access buttons.&#x20;