Connecting to Amazon Redshift

Contents[Hide]

1. Overview

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

2. AWS Account

In order to connect to Amazon Redshift data, you need an AWS account.

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

From the Navigation Pane on the left, click Clusters.

Click on your cluster to open it.

Under Cluster Database Properties, go to the Configuration Tab and copy the connection string under ODBC URL.

Save the highlighted values from Amazon Redshift Console.
Save the highlighted values from Amazon Redshift Console.

3. Dundas BI Data Connector

Set up a Data Connector in Dundas BI to connect to Amazon Redshift.

From the Main Menu, click New, and the select Data Connector.

In the New Data Connector dialog, click inside the File Name box and enter a name for your Data Connector.

Click the Data Provider dropdown and choose Amazon Redshift.

Next, supply the required credentials:

  1. Enter the copied ODBC connection string in the Connection String field.
  2. The Password will be the Password for the AWS account.

Create a new Data connector for Amazon Redshift database
Create a new Data connector for Amazon Redshift database

Click Test Connection to check the connection to your AWS account.

If the test is OK, click Submit to create the Data Connector and perform data discovery.

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: 7am-6pm, ET, Mon-Fri