# 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="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FMVfarOte8TuukSAkrcqa%2F1Redshift%20Source.png?alt=media&#x26;token=224af7bc-be98-426d-9730-a22b811fb67b" 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="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FEx5B8hStPHm90qLizYFK%2F2Redshift%20Source.png?alt=media&#x26;token=68157150-1603-4e3a-8624-05f54de3ec5f" 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>

   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="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FkJ1MlUmtHfCBoZfWRljM%2F3Redshift%20Source.png?alt=media&#x26;token=1c8c5767-a89b-4ab0-ab87-57f2a1c6cc2c" 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%2FSnUguiTLtKabjgQ8AWkV%2F4Redshift%20Source.png?alt=media&#x26;token=985d51f7-9b63-4256-b580-4454c54e7e91" 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="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FVQg3Cg4hxFc2jF7wuJhA%2F5Redshift%20Source.png?alt=media&#x26;token=c26464bf-ff24-45ff-908b-58c56d0b0a06" 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.
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;