Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

Sqlways.ini File - Section [Redshift]

This article describes sqlways.ini file [Redshift] section and options it contains.

Option name Description
HOST This option sets the host name where import will be done.
DATABASE This option sets the database name where import will be done.
USER This option sets user account that will be used to connect to Amazon Redshift database.
PWD This option sets password that will be used together with the user account to connect to Amazon Redshift database.
PORT This option sets port number that will be used to connect to Amazon Redshift database.
TARGET_VERSION This option sets the version number of the database where import will be done.
CLOUD_PATH This option required to specify path on the cloud, where data files will be placed. If value is not set will be used path to the current export folder by default.
ACCESS_KEY_ID This option sets the access key id that is used to get access to the data files stored on cloud.
SECRET_ACCESS_KEY This option sets the secret access key that is used to get access to the data files stored on cloud.
BIN This option sets the path to the native utility (psql.exe) that will be used by SQLWays Wizard tool to make an import into the Amazon Redshift database.

Example:

[REDSHIFT]
HOST=hostname
DATABASE=test
USER=postgres
PORT=4444


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/command-line/sqlways-ini/redshift-section.txt · Last modified: September 26, 2016, 01:49:37 AM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement