Amazon Redshift

Connection Dialog

The following connection options are required for connecting to Amazon Redshift:

1.	Server - The name or IP address of the Redshift server to which to connect.

2.	Port - Number of a port to communicate with listener on the server. The default value is 5432;

3.	User Id - The Redshift login account.

4.	Password - The password for the Redshift login account.

5.	Database - The name of the database to connect to.

6.	Schema - The name of the schema to be used once a connection is opened. You can change it later if you need. By default it is schema 'Public'.

Entering these options is enough for reading data from Amazon Redshift and loading data to Amazon Redshift using normal Insert, Update, and Delete operations. If you want to use a highly efficient BulkInsert operation to quickly load large volumes of data to Amazon Redshift via the Redshift COPY command, you also need to switch to the Amazon Web Services tab of the connection editor and provide parameters to connect to Amazon S3:

1.	Access Key ID - the first part of your Amazon Web Services access key.

2.	Secret Key - the second part of your Amazon Web Services access key. Read more about AWS access keys.

3.	Security Token - an alternative to Access Key ID and Secret Key pair, Amazon Web Services Security token is a temporary, limited-privilege credential.

4.	Region - the AWS region, where your S3 storage is hosted.

5.	Bucket Name - here you may optionally specify the name of your S3 bucket to temporarily load CSV files with imported data to. If you leave it empty, Devart Redshift Destination will create a new bucket when importing or replicating data to Redshift and delete it after the operation is finished.

In addition to the required options, Advanced connection options may be set for more fine connection tuning.

Advanced Connection Options

The following table describes the options that you can include in the Connection String using the Advanced tab of Connection Editor dialog box:

Option

Description

AllowDateTimeOffset

Determines whether to use the DateTimeOffset type instead of DateTime when a timestamptz value is returned.

ApplicationName

Specifies the name of the application, associated with the connection string.

AWS Access Key ID

Specifies the first part of your Amazon Web Services access key.

AWS Secret Key

Specifies the second part of your Amazon Web Services access key. Read more about AWS access keys...

AWS Security Token

Specifies a temporary, limited-privilege Amazon Web Services security token, used as an alternative to the AWS Access Key ID and AWS Secret Key pair.

Character Set

Specifies a character set used by the client. When this property is enabled, the "SET NAMES <Charset>" query is executed on establishing a connection. The default value is an empty string, which means that no action is performed with charset on the client and on the server.

Connection Lifetime

Specifies the maximum lifetime (in seconds) of a connection. When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span exceeds the value specified by Connection Lifetime. The default value is 0.

Connection Timeout

Specifies the length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. The default value is 15.

Database

Specifies the name of the Redshift database you want to connect to.

Default Command Timeout

Specifies the default time in seconds to wait while trying to execute a command before terminating the attempt and generating an error. 0 indicates no limit.

Default FetchAll

Is ignored and should not be used.

Enlist

Determines whether the connection is automatically enlisted in the current distributed transaction. The default value is true.

Force IPv4

Determines whether authentication by an IPv6 address can be used, or an IPv4 address must always be used for authentication.

Host

Specifies the name or IP address of the host of the Redshift database to which to connect.

Ignore Unnamed Parameters

Determines whether to treat the '?' character in the command text as an unnamed parameter.

Initial Schema

Specifies the name of the schema to be used once a connection is opened. You can change it later if you need. By default it is schema 'Public'.

Initialization Command

Specifies a data source-specific command to execute immediately after the connection is established.

Integrated Security

Determines whether to use a secure authentication with single sign-on (GSSAPI or SSPI, depending on the server).

Join Statement Notices

Determines whether all the notices, raised during the statement execution, will be returned together in one InfoMessage event after the statement execution, or each notice will be returned as a separate InfoMessage event.

Keep Alive

Specifies whether to send TCP keep-alive packets and the interval at which they are sent in seconds. The default value is 0 indicating that the packets are not sent.

Keep Connected

Specifies the interval, in seconds, at which periodic ping requests are sent to Amazon Redshift while the connection is idle to prevent the connection from being closed. The default value is 0, indicating that the calls are disabled.

Max Pool Size

Specifies the maximum number of connections allowed in the pool. Setting the Max Pool Size value in the connection string can affect performance. The default value is 100.

Min Pool Size

Specifies the minimum number of connections allowed in the pool. The default value is 0.

Password

Specifies the password to login with.

Persist Security Info

Indicates if security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state.

Pooling

Specifies whether, by default, the connection is drawn from the appropriate pool or is created and added to the appropriate pool.

Port

Specifies the Redshift connection port. The default value is 5432.

Protocol

Specifies the Frontend/Backend Protocol version. Available values are Ver20 and Ver30. Set the parameter to Ver20 for the protocol version 2.0 or to Ver30 for protocol version 3.0.

Proxy Host

Specifies the host name or IP address of the proxy server.

Proxy Password

Specifies the password for the proxy server account.

Proxy Port

Specifies the port number of the proxy server. The default value is 3128.

Proxy User

Specifies the proxy server account name.

Run Once Command

Specifies a command to execute immediately after establishing the connection. Unlike Initialization Command, it is not executed for connections obtained from the connection pool.

S3 Bucket

Specifies the name of your S3 bucket to temporarily load the file with imported or replicated data to. If you leave it empty, Skyvia will create a new bucket when importing or replicating data to Redshift and delete it after the operation is finished.

To load data to Redshift with max performance, Devart Redshift Destination loads data as CSV files to Amazon S3, tells Redshift to import data from it, and deletes the CSV file after the import.

S3 Bucket Region

Specifies the AWS region, where your S3 storage is hosted.

SSH Authentication Type

Specifies the client's SSH authentication methods.

SSH Cipher List

Specifies the list of ciphers that client agrees to use, separated by colons. Two modes of block ciphering are supported: Cipher-block chaining (CBC) and Counter (CTR).

The following ciphers are available for SSH connections in the CBC mode:

•	3DES or 3DES(168) - Triple Data Encryption Algorithm. Key size 168 bits.

•	Blowfish - Symmetric-key block cipher, designed in 1993 by Bruce Schneier. Key size 128 bits.

•	AES(128) - Advanced Encryption Standard. Key size 128 bits.

•	AES(192) - Advanced Encryption Standard. Key size 192 bits.

•	AES or AES(256) - Advanced Encryption Standard. Key size 256 bits.

In the CTR mode the AES ciphers are used.

•	AES(128)-CTR - Advanced Encryption Standard. Key size 128 bits.

•	AES(192)-CTR - Advanced Encryption Standard. Key size 192 bits.

•	AES-CTR or AES(256)-CTR - Advanced Encryption Standard. Key size 256 bits.

You can use ALL keyword to indicate whole set of ciphers. To exclude certain cipher from the set use "-" sign. For instance, value of CipherList property "ALL-Blowfish" means that any cipher but Blowfish can be used.

SSH Host

Specifies the name or IP address of the SSH server.

SSH Host Key

Specifies the location of the public key on the client side to verify the server host key during establishing connection. OpenSSH or IETF SECSH key files are supported. You may use such utilities as 'ssh-keygen.exe' or 'puttygen.exe' for generation of the corresponding public/private key pair.

SSH KeyExchange Algorithms

Specifies the algorithms to securely establish a shared encryption key between the client and the server.

SSH MAC Algorithms

Specifies the algorithms to verify the integrity and authenticity of data exchanged between the client and the server.

SSH Passphrase

Specifies the client key passphrase.

SSH Password

Specifies the user password on the SSH server.

SSH Port

Specifies the number of the port on the SSH server to connect to.

SSH Private Key

Specifies the location of the client private key.

SSH Strict Host Key Check

Indicates whether the host key is verified during establishing connection.

SSH User

Specifies the user id on the SSH server.

SSL CA Cert

Specifies the location of the authority SSL certificate.

SSL Cert

Specifies the location of the client SSL certificate.

SSL Cipher List

Specifies the list of ciphers that client agrees to use.

SSL Key

Specifies the location of the user's private key.

SSL TLS Protocol

Specifies the preferred TLS protocol version, reported to the server when establishing a secure connection.

SSLMode

Specifies the SSL connection priority. May be Disable, Allow, Prefer, and Require. The default value is Disable, which means that only an unencrypted SSL connection will be attempted.

Target Session

Determines how the host to connect to is selected from the list when multiple hosts are specified in the Host connection string parameter.

Transaction Error Behavior

Determines how the driver handles errors that occur within a transaction.

Transaction Scope Local

Determines whether Devart SSIS Data Flow Components uses only one connection internally when there are several connections with the same connection string (which includes "Transaction Scope Local=true;") within a scope of TransactionScope. The default value is false.

Unicode

Sets the client charset to UTF8 and converts client data according to this charset if true, which is the default value.

UnpreparedExecute

Uses unprepared execute mode by default if true.

Use Session Timezone

Determines whether the current session's time zone is used to convert requested Amazon Redshift date/time values.

User ID

Specifies the user name to login with.

Validate Connection

Specifies whether to validate connections that are being got from the pool.