---
title: "Connecting to Amazon Redshift"
slug: "connecting-to-amazon-redshift"
description: "Learn how Amazon Redshift, an Amazon AWS-based Cloud Data Warehouse, can be leveraged to gain an understanding of an organization and its customer base. A connection may be established with an Amazon Redshift Account via and ODBC Connection."
updated: 2026-07-02T14:14:52Z
published: 2026-07-02T14:14:52Z
canonical: "documentation.decisions.com/connecting-to-amazon-redshift"
---

> ## 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/image-1783001642035.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/image-1783001662213.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/image-1783001682583.png)