---
title: "Connecting to Redshift"
description: "You can establish a direct connection to Redshift to pull in data into xP&A.\n\nIt is possible to use an SSH tunnel for the connection."
source_url: https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-redshift
language: en
last_updated: 2023-08-16
---
# Connecting to Redshift

## Overview

You can establish a direct connection to Redshift to pull in data into xP&A. It is possible to use an SSH tunnel for the connection.

This article contains a description of the prerequisites and the individual steps of the set-up process.

{% info-box %}
The fields that are pulled in must be defined during the set-up process using a database query. For a detailed instruction on how to structure such a query, see [Defining Database Queries](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/defining-database-queries.md).
{% /info-box %}

## Prerequisites for the Setup

To allow xP&A to connect to your Redshift database, you have to take the following actions upfront:

### Whitelist IP Address in Redshift

You have to whitelist the following static IP address before connecting Redshift with xP&A: **52.59.129.235**

You need to make sure that your Redshift database is only accessible with a strong username and password combination when white listing these IP addresses. Proceed as follows:

{% stepper %}
{% stepper-step %}
Open the **Properties** of your **Redshift Cluster**.
{% /stepper-step %}
{% stepper-step %}
Under **Network and security settings**, click the **VPC security group**:

VPC security group settings
{% /stepper-step %}
{% stepper-step %}
Open the **Inbound rules** tab and click **Edit inbound rules**:

'Inbound rules' tab
{% /stepper-step %}
{% stepper-step %}
As **Type**, select **Redshift**, and enter your external **IP address** under **CIDR blocks** and click **Save rules**.

Enter the IP address
{% /stepper-step %}
{% /stepper %}

### Make Your Redshift Database Publicly Accessible

To allow xP&A to connect to your Redshift database, you need to make your database publicly accessible. Proceed as follows:

{% stepper %}
{% stepper-step %}
Open the **Properties** of your **Redshift Cluster**.
{% /stepper-step %}
{% stepper-step %}
Under **Network and security settings**, make sure that the option **Publicly accessible** is activated.

Redshift network and security settings
{% /stepper-step %}
{% stepper-step %}
If it is not activated, click **Edit** and activate the option **Turn on Publicy accessible**

Option 'Publicly accessible'
{% /stepper-step %}
{% /stepper %}

{% stepper %}
{% stepper-step %}
Choose one of the following options:

- Open the **Data** workspace from the overview on the start page and click **\+ New.**

New data source connection from the Data workspace

- Open the model into which you would like to integrate the data, click the **+** sign next to **Data** in the overview, and choose **New data source**:

New data source connection from within a model
{% /stepper-step %}
{% stepper-step %}
In the **Data sources** dialog, open the **BI/Database** tab and choose **MySQL:**

'BI/Database' tab
{% /stepper-step %}
{% stepper-step %}
The **New Data Source** dialog is displayed as follows:

'New Data Source' dialog for a Redshift connection
{% /stepper-step %}
{% stepper-step %}
Configure the steps as described in the following section.
{% /stepper-step %}
{% stepper-step %}
Click **Create data source**.
{% /stepper-step %}
{% /stepper %}

### Set-up Steps

The following steps are required to set up the data source:

#### Choose a connection

Choose an existing connection, or, if you have not configured a connection yet, click **New Connection** and enter the following in the **New Redshift connection** dialog:

- Redshift **Cluster endpoint host name** without port and database
- Cluster **endpoint port**
- **Name of the database** to which you want to connect
- **Database user name** and **password\
\
** The user credentials are specific to the Redshift cluster and not AWS services. For more information about creating and managing database users in Redshift cluster, see [Redshift documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_Users.html)

#### Complete the query form

Enter the following:

- **Data Source Name**
- **Query** to define the fields which are to be pulled in. For more information, see [Defining Database Queries](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/defining-database-queries.md).
- Name of the **Date column**, which must be one of Redshift's date formats
- Names of the columns that contain **variables** (which must have a **numeric** data type.)

{% idea-box %}
Any remaining columns will be treated as dimensions, and must have a **string** data type.

An exception is the **cohort** dimension, which must be a date, with the column header explicitly labelled **Cohort**.
{% /idea-box %}