# Amazon Redshift

* DBSync Cloud Replication (Salesforce with Amazon Redshift)
* Amazon Redshift Database details in DBSync Replication Profile

### DBSync Cloud Replication (Salesforce with Amazon Redshift) <a href="#amazonredshift-dbsynccloudreplication-salesforcewithamazonredshift" id="amazonredshift-dbsynccloudreplication-salesforcewithamazonredshift"></a>

Most of the features of DBSync Replication will work the same irrespective of the database.&#x20;

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

**Update Database Schema:**

* To generate schema in Redshift database, the user must have Permission to generate Schema in Redshift database.
* DBSync Cloud Replication Creates schema and Tables metadata if it does not exist in Redshift database.

**Source to Database (Clean Copy):**

* Clean Copy creates Schema and Tables if it does not exists in Target Database and insert records from source belongs to the Object selected.
* In Redshift 'NULL' Values in INSERT/UPDATE is not supported. So, the following default values will be updated for all the fields which contain 'NULL' values

![](https://help.mydbsync.com/docs/download/attachments/31983357/worddav1d45a64de8e12004430612109b94064c.png?version=1\&modificationDate=1546312043000\&api=v2)

**Source to Database:**

* Inserts or Updates records based on the Timestamp value in Redshift Database.
* In Redshift 'NULL' Values in INSERT/UPDATE is not supported. So, the following default values will be updated for all the fields which contain 'NULL' values.

![](https://help.mydbsync.com/docs/download/attachments/31983357/worddav1d45a64de8e12004430612109b94064c.png?version=1\&modificationDate=1546312043000\&api=v2)

**Database to Source:**

* While replicating from Redshift database to source, default values in Redshift database are removed.

![](https://help.mydbsync.com/docs/download/attachments/31983357/worddav1d45a64de8e12004430612109b94064c.png?version=1\&modificationDate=1546312043000\&api=v2)

### Amazon Redshift Database details in DBSync Replication Profile <a href="#amazonredshift-amazonredshiftdatabasedetailsindbsyncreplicationprofile" id="amazonredshift-amazonredshiftdatabasedetailsindbsyncreplicationprofile"></a>

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.

![](https://help.mydbsync.com/docs/download/attachments/31983357/image2021-6-9_21-55-40.png?version=1\&modificationDate=1623255939000\&api=v2)

**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](http://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.