Connecting to Amazon Redshift

Contents[Hide]

1. Overview

This article shows you how to set up a data connector for connecting to Amazon Redshift.

2. AWS account

Use your AWS account to set up Amazon Redshift and find its connection details.

Sign in to your AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

Open the details for your cluster and find and copy the ODBC URL, which contains the connection string. For details, see Amazon Redshift's getting started guide on how to get your connection string.

3. New data connector

Once you have your connection string, you can set up a data connector in Dundas BI.

From the main menu, click New, then Data Connector.

In the New Data Connector dialog, enter a Name for your data connector, then set Data Provider to Amazon Redshift.

Create a new data connector for Amazon Redshift
Create a new data connector for Amazon Redshift

Next, paste the Connection String, and enter the Password if not already included in the connection string.

Additional options such as Search Path for specifying schemas are available by clicking on the expandable sections below. You can also click Test connection to check your connection.

Click the Submit button at the bottom of the dialog to save and check in the data connector, and automatically discover the available data structures.

4. See Also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri