Redshift as Target

General Parameters

• database – The only appropriate value is target
• dbtype – The appropriate value is redshift
• generatesql –This parameter is to identify if database objects are to be created immediately (0 - value, default), or the SQL script creating these objects should be generated (1 value).

Database Connectivity

• server – Host name or IP address of the database server
• port – Database port
• dbname – Database name
• user – Database User name
• password – Database User password

Web UI

To prepare database on the “Database Settings” form provide connectivity setting and click “Test connection”.

 Click “Prepare for Replication” to prepare the Target database:

Clicking on the “Show Prepare SQL” will generate script creating necessary replication objects.