Ultimate

Connect your Amazon Redshift account using the sources workspace

IMPORTANT
The Amazon Redshift source is available in the sources catalog to users who have purchased Real-Time Customer Data Platform Ultimate.

This tutorial provides steps on how to connect your Amazon Redshift (hereinafter referred to as “Redshift”) account to Adobe Experience Platform using the user interface.

Getting started

This tutorial requires a working understanding of the following components of Experience Platform:

If you already have a valid Redshift connection, you may skip the remainder of this document and proceed to the tutorial on configuring a dataflow.

Gather required credentials

In order to access your Redshift account on Experience Platform, you must provide the following values:

Credential
Description
Server
The server associated with your Redshift account.
Port
The TCP port that a Redshift server uses to listen for client connections.
Username
The username associated with your Redshift account.
Password
The password associated with your Redshift account.
Database
The Redshift database you are accessing.

For more information about getting started, refer to this Redshift document.

Once you have gathered your required credentials, you can follow the steps below to link your Redshift account to Experience Platform.

Connect your Redshift account

NOTE
The default encoding standard for Redshift is Unicode. This cannot be changed.

Log in to Adobe Experience Platform and then select Sources from the left navigation bar to access the Sources workspace. The Catalog screen displays a variety of sources for which you can create an account with.

You can select the appropriate category from the catalog on the left-hand side of your screen. Alternatively, you can find the specific source you wish to work with using the search option.

Under the Databases category, select Amazon Redshift. If this is your first time using this connector, select Configure. Otherwise, select Add data to create a new Redshift connector.

The Connect to Amazon Redshift page appears. On this page, you can either use new credentials or existing credentials.

New account

If you are using new credentials, select New account. On the input form that appears, provide a name, an optional description, and your Redshift credentials. When finished, select Connect and then allow some time for the new connection to establish.

Existing account

To connect an existing account, select the Redshift account you want to connect with, then select Next to proceed.

Next steps

By following this tutorial, you have established a connection to your Redshift account. You can now continue on to the next tutorial and configure a dataflow to bring data into Experience Platform.

recommendation-more-help
337b99bb-92fb-42ae-b6b7-c7042161d089