# 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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.mydbsync.com/cloud-replication-main/target-setup/aws-redshift/amazon-redshift.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.