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
UseClientCertificate UseClientCertificate
ClientCertificateStorageType CertificateStorageType

Available Options (Use numeric value listed in bracket if you have to define expression on this property (for dynamic behavior).

Option Description
NotSet [0] <Not set>
LocalMachine [1] Stored in LocalMachine Storage Area
CurrentUser [2] Stored in User Storage Area
PfxFile [3] Disk File - PFX (PKCS12) format
ClientCertificateStoreName CertificateStoreName

Available Options (Use numeric value listed in bracket if you have to define expression on this property (for dynamic behavior).

Option Description
NotSet [0] <Not set>
AddressBook [1] AddressBook
AuthRoot [2] AuthRoot
CertificateAuthority [3] CertificateAuthority
Disallowed [4] Disallowed
My [5] My
Root [6] Root
TrustedPeople [7] TrustedPeople
TrustedPublisher [8] TrustedPublisher
ClientCertificateThumbPrint CertificateThumbprint
ClientCertificatePath CertificatePath
ClientCertificatePassword Password for X509 Client certificate
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
TcpKeepAlive Enables TCP KeepAlive timer with system defaults if overrides isn't specified (Set TcpKeepAliveTime=0 to use system default). This feature is useful to keep connection alive, if you have long running query / large data load and your connection is being dropped by firewall / network hardware or other restrictions then enable this feature to avoid connection drop.
TcpKeepAliveTime Specifies the timeout, in seconds, with no activity until the first keep-alive packet is sent. Once this timeout is reached small packets are sent every N seconds specified in this property. Set this to 0 to use system default (5 mins - i.e. Send Keep-Alive Packet Every 5 mins).
TcpKeepAliveInterval Specifies the interval, in seconds, between when successive keep-alive packets are sent if no acknowledgement is received (i.e. Retry Interval for No ACK).
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.
ConnectByProxy

Setting UI

Amazon Redshift Connection - Setting UI

See Also

References

Copyrights reserved. ZappySys LLC.