Connecting to Amazon Redshift

Amazon Redshift-Specific Features and Limitations

Skyvia has the following limitations for Amazon Redshift:

Synchronization is not supported for Amazon Redshift.
UPSERT operation in import is not supported for Amazon Redshift.

 

Amazon Redshift Connections

To connect to Redshift, you need to specify the server host name or IP address, the port the server is listening, the user name and password to login, and the database name. If you need to import data to Redshift via Skyvia or perform replication to it, you will need to specify additional advanced parameters, described below.

redshift-connection-new

You need to specify the following parameters for Amazon Redshift connection:

Name - connection name that will be used to identify the connection on the Connections page and when selecting a connection for a package.
Server - the name or IP address of the Redshift host to which to connect.
Port - Redshift connection port; default value is 5432.
User Id - the user name to login with.
Password - the password to login with.
Database - the name of the Redshift database you want to connect to.
Schema - the name of the Redshift schema you want to connect to.

If you want to execute Import packages, inserting data to Redshift, or Replication packages via this connection, you need to click the Advanced button and set parameters for connecting to Amazon S3 storage service. This is necessary, because for these operations Skyvia uses Redshift data import from Amazon S3. It loads data as CSV files to Amazon S3, tells Redshift to import data from it, and deletes the CSV file after the import. Thus, you need to specify the S3 region to use and either AWS Security Token or AWS Access Key ID and AWS Secret Key. You may also optionally specify the S3 Bucket Name to upload file to. Here are the descriptions of these parameters:

AWS Access Key ID - the first part of your Amazon Web Services access key.
AWS Secret Key - the second part of your Amazon Web Services access key. Read more about AWS access keys...
AWS Security Token - an alternative to AWS Access Key ID and AWS Secret Key pair, Amazon Web Services Security token is a temporary, limited-privilege credential.
S3 Region - the AWS region, where your S3 storage is hosted.
S3 Bucket Name - here you may specify 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.

In the Advanced parameters you can also select the Unicode check box to use Unicode encoding for the connection and specify the Command Timeout interval. The latter specifies the wait time before terminating an attempt to execute a command and generating an error. Note that it is the time to wait for any server reply since the command was sent to a server, and it doesn't include the time necessary to fetch data if the command selects some data.

Additionally the Advanced parameters include the Connection Timeout parameter. This parameter determines the time (in seconds) to wait while trying to establish a connection before terminating the attempt and reporting an error. Generally you don't need to modify it, but in some specific cases when a connection to the database server is not good you may try increasing its value.

 

SSL Connections

If you want to use SSL connection, additionally yo may set the following Advanced parameters:

SSL Mode - this mode determines the priority of using secure SSL connection. You can select any of the following modes:
oAllow - try first a non-SSL connection, then if that fails, try an SSL connection.
oDisable - establish only an unencrypted SSL connection. If this mode is selected, SSL is not used, and other SSL parameters are not available. This mode is selected by default.
oPrefer - try first an SSL connection, then if that fails, try a none-SSL connection.
oRequire - establish only a secure SSL connection.
SSL CA Cert - the authority certificate. Paste the content of the certificate file into the box or click the button to open a multiline editor and paste the content of the certificate file there.
SSL Cert - the client certificate. Paste the content of the certificate file into the box or click the button to open a multiline editor and paste the content of the certificate file there.
SSL Key - the client private key. Paste the content of the key file into the box or click the button to open a multiline editor and paste the content of the key file there.