function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sumathy SubramanianSumathy Subramanian 

Salesforce to amazon redshift data replication

Hi All,

I am looking to replicate data from Salesforce to Amazon Redshift. Amazon Redshift is our enterprise data warehouse and is used as a single point of truth for cross domain reporting. Please advice if the connectivity is possible and what steps need to be taken in order to get this connection set up?
SandhyaSandhya (Salesforce Developers) 
Hi,

Refer below salesforce help article for information on this.

https://help.salesforce.com/articleView?id=bi_integrate_connectors_redshift_settings.htm&type=0
 
https://help.salesforce.com/articleView?id=bi_integrate_connectors_amazon_aws_rds_settings.htm&type=5
 
https://salesforce.stackexchange.com/questions/161879/salesforce-and-aws-rds
 
Please mark it as solved if my reply was helpful, it will make it available
for others as a proper solution.

Best Regards,
​Sandhya
 
David GardelDavid Gardel
You can automatically replicate data from your Salesforce to Amazon Redshift by using Skyvia (https://skyvia.com/data-integration/replicate-salesforce-to-redshift). It is web-based ETL service with simple UI and flexible scheduling options.