Using the Amazon RedShift Connection Manager

The Amazon RedShift Connection Manager is an SSIS connection manager component that can be used to establish connections with Amazon RedShift.

To add a Amazon RedShift connection to your SSIS package, right-click the Connection Manager area in your Visual Studio project, and choose "New Connection..." from the context menu. You will be prompted the "Add SSIS Connection Manager" window. Select the "Amazon RedShift" item to add the new Amazon RedShift Connection Manager.

New Connection

Add Amazon RedShift Connection

The Amazon RedShift Connection Manager contains the following two pages which configure how you want to connect to Amazon RedShift.

  • General
  • Advanced

General

The General page of Amazon Redshift Connection Manager allows you to specify the server host details and credentials for authentication.

Amazon RedShift Connection Manager

Server
Host

The host's domain name or the address for the instance.

Port

The port number of the instance.

Timeout

The Timeout (secs) option allows you to specify a timeout value in seconds for the connection. The maximum value for timeout is 600 seconds.

Authentication
Username

The username of the account which will be used to connect to the database instance.

Password

The password of the provided user account.

Database
Database

The databases that are accessible by the credentials provided above would be available in this field.

Advanced

The Advanced page contains the possible settings for Amazon Redshift connection. Clicking on a specific setting will display a description for the selected property at the bottom of the Advanced page.

Amazon RedShift Connection Manager

It has the below sections which you can work with:

  • General
  • Miscellaneous
  • Performance
  • Pooling
  • Security and Encryption

For details on Timeouts and KeepaliveYou, refer to the following link regarding each connection property: Connection String Parameters