Page History

DBSync Cloud Replication (Source

...

Apps with Amazon Redshift)

Most of the features of DBSync Replication will work the same irrespective of the database. The general process of Replication Source apps to Database and Database to Source apps is explained in the below links.

http://help.mydbsync.com/docs/display/CloudReplication/4-Source appsApps+to+Database

http://help.mydbsync.com/docs/display/CloudReplication/5-Database+to+Source appsApps

The functionality that is specific to Redshift database Replication is mentioned below.

...

The following details should be entered in DBSync Replication console. Connection can be tested by clicking on Test Connection button. Click on Save to save database details in your profile.

Image Added

Database Username: Amazon Redshift username

Database Password: Amazon Redshift Password

Database URL: Database URL will auto populate once you update the below details

Type: Redshift

Host: Redshift Hostname/IP Address
(Ex: dbsync-replication.cc9kpgwxioda.us-east-1.redshift.amazonaws.com)

Port: Redshift Port Number (Ex: 5439)

Database: Redshift Master Database Name (Ex: dbsync)

Schema(Redshift):

• Redshift Schema Name (Ex: dbsynctest)

• Schema name is dbsync by default. User can modify this field with existing schema name or new Schema name.

• Schema Name is mandatory for sync process.

• To Test Redshift Database connection, Schema Name is not required.

• Added Validation on Schema Name. User cannot save the Database Details without Schema Name.