Amazon Redshift Connection Manager
PreviousNext

Amazon Redshift Connection Manager can be used along with Redshift DataTransfer Task and Redshift ExecuteSql Task. This connection can be used to connect Amazon Redshift database from SSIS.

Download SSIS PowerPack

Content

Video Tutorial

Coming soon...

Step-By-Step

In this tutorial we will learn how to create Amazon Redshift Connection. You can create multiple connection.
  1. In order to connect to Amazon Redshift Storage from SSIS you will need Credentials. You can click here to get credentials.
  2. Now, You need to Download and Install SSIS ZappySys PowerPack.
  3. Once you finished above steps, Open Visual Studio and Create New SSIS Package Project.
  4. Right click in the Connection Manager panel and click on New Connection.
    SSIS Create New Connection
  5. Select ZS-REDSHIFT Connection Manager from the Connection Managers list and Click on Add Button
    Amazon Redshift Connection Manager Add
  6. In the connection manager UI, Enter host name, check on Enable SSL, enter user name, password and database name.
    Amazon Redshift Connection Manager UI
  7. Click on Test Connection to check configure correct or not.
  8. Click on OK button to save Amazon Redshift Connection Manager configure setting UI.
  9. Once you finished, you will see Amazon Redshift Connection in Connection Manager panel.
    Amazon Redshift Connection - Success

Properties

Property Name Description
Host
Port
Database
UserName
CommandTimeout Timeout for command execution
ApplicationName
Pooling Connection polling for better performance management. Set to false to disable connection polling
Password
Timeout Timeout for connect
EnableSsl
ConnectionString
RetainSameConnection When you set this to True it keeps connection open until package is running. By default connection is released when task using Redshift connection is done executing. But when you need something where multiple tasks utilizing same open connection then set this property.

Setting UI

Amazon Redshift Connection - Setting UI

See Also

References


Copyrights reserved. ZappySys LLC.