Connecting to Amazon Redshift

Amazon Redshift is a cloud data warehouse service used for business intelligence. Use Analytics's data connector to import your organization's Amazon Redshift data.

Before you start

To connect to Amazon Redshift, you must gather the following:

  • the server and database name from the ODBC URL of the Amazon Redshift cluster
  • username of the user account that has permission to connect to the database
  • password of the user account that has permission to connect to the database
  • the port number that was specified when the cluster was launched (ensure the port is open if you have a firewall)

Note

When gathering the required connection information:

  • you can obtain the ODBC URL from the AWS Management Console by looking at the database properties for your cluster
  • verify that the connecting account has database permissions, not just Amazon Redshift permissions

For more information about configuring an ODBC connection, see the online Amazon AWS documentation.

For help gathering the connection prerequisites, contact the Amazon Redshift administrator in your organization. If your administrator cannot help you, you or your administrator should contact Amazon Redshift Support.

Create an Amazon Redshift connection

  1. From the Analytics main menu, select Import > Database and application.
  2. From the New Connections tab, in the ACL Connectors section, select Amazon Redshift.

    Tip

    You can filter the list of available connectors by entering a search string in the Filter connections box. Connectors are listed alphabetically.

  3. In the Data Connection Settings panel, enter the connection settings and at the bottom of the panel, click Save and Connect.

    You can accept the default Connection Name, or enter a new one.

The connection for Amazon Redshift is saved to the Existing Connections tab. In the future, you can reconnect to Amazon Redshift from the saved connection.

Once the connection is established, the Data Access window opens to the Staging Area and you can begin importing data. For help importing data from Amazon Redshift, see Import data using the Data Access window .

Analytics 14.1 Help