Connecting to Amazon Redshift

Amazon Redshift is a cloud data warehouse service used for business intelligence. Use the Amazon Redshift 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)

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 Working with the Data Access window.

Connection settings

Basic settings

Setting	Description	Example
Server	Host name or IP address of the Redshift cluster. You can obtain this value from the AWS Management Console.
Port	The TCP port number of the Amazon Redshift server.	5439
Database	Name of the Redshift database. If you do not specify database, the connection uses the user's default database.
User	The user name to access the Redshift server. If you are using keys to set driver options, UID takes precedence over Username.
Password	The password used to authenticate the user.
SSL Authentication	The SSL certificate verification mode to use when connecting to Redshift. The values available are as follows: allow - By default, connect without using SSL. If the server requires SSL connections, then use SSL. disable - Connect without using SSL. prefer - Connect using SSL if available. Otherwise, connect without using SSL. require - Connect only using SSL. verify-ca - Connect only using SSL and a trusted certificate authority. verify-full - Connect only using SSL, a trusted certificate authority, and a server name that matches the certificate.	require
Enable HTTP Proxy Connection	Specifies whether the driver can pass the IAM authentication processes through a proxy server.
Proxy Server	The host name or IP address of a proxy server through which to pass IAM authentication processes.
Proxy Port	Port number that the proxy server uses to listen for client connections.

Advanced settings

Setting	Description	Example
Use Unicode	Specifies whether the driver returns Redshift data as Unicode or regular SQL types.
Show Boolean Column As String	Specifies the SQL data type that the driver uses to return Boolean data. If enabled, the driver returns Boolean columns as SQL_VARCHAR data with a length of 5, else as SQL_BIT data.
Text as LongVarChar	Specifies the SQL data type that the driver uses to return Text data. If disabled, the driver returns text columns as SQL_VARCHAR data.
Max Varchar	The maximum data length for VARCHAR columns.	255
Max LongVarChar	The maximum data length for LongVarChar columns.	8190
Max Bytea	The maximum data length for Bytea columns.	255