---
title: "Connecting to Amazon Redshift"
slug: "connecting-to-amazon-redshift"
updated: 2024-07-02T17:31:15Z
published: 2024-07-02T17:31:15Z
---

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

# Connecting to Amazon Redshift

## Overview

**Amazon****Redshift**is an **Amazon****AWS**-based **Cloud****Data** **Warehouse**that can be leveraged to gain an understanding of an organization and its customer base. Through the use of an **ODBC****Connection**, users may establish a connection with and integrate with an Amazon Redshift Account.

---

## Example

The following example discusses and demonstrates how to properly establish Integration with Amazon Redshift.;

Prerequisite 

- Pre-existing Amazon Web Services (AWS) Account. To create a new AWS account, navigate to [AWS Console - Signup](https://portal.aws.amazon.com/billing/signup#/start)
- Amazon Redshift Driver. To download the Amazon Redshift Driver, navigate to [64-bit ODBC driver version 1.4.34.](https://s3.amazonaws.com/redshift-downloads/drivers/odbc/1.4.34.1000/AmazonRedshiftODBC64-1.4.34.1000.msi) For more information on configuring an ODBC connection on an Amazon Redshift Cluster, see   [Configuring an ODBC connection - Amazon Redshift](https://docs.aws.amazon.com/redshift/latest/mgmt/configure-odbc-connection.html)

1. Navigate to **System > Integrations > Databases**, then select CREATE CONNECTION on the **Global Action Bar**.
2. From the **Database****Integration**window, provide a **Connection** **Name**. Then from the **Database****Type**options, select **ODBC**. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-02_13h29_12.png)
3. Provide the **Connection****String**in the following format while making sure that each value following an equal sign corresponds with the **Cluster**'s****values:

```actionscript
Driver={Amazon Redshift (x64)}; Server=examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com; Database=dev; UID=masteruser; PWD=insert_your_master_user_password_here; Port=XXXX
```
4. Click the PICK OR CREATE ODBC DB TYPE button, then select and PICK the corresponding **Connection Flow**. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-02_13h29_53.png)
5. Click TEST to ensure that the connection is properly set up, then click OK to save the Integration and exit. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-02_13h30_44.png)