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 |
|