Replicate Salesforce data into Redshift Using Datapipeline:

Performance tuning for Loading data into Redshift

DBSync Cloud Replication for Salesforce is used for replication and synchronization of schema and data between Salesforce and Database namely Oracle, SQL Server, My SQL, Redshift and Cassandra.
We have often come across situation where in direct writes to redshift is quite slow and the requirement is to increase the performance of large data writes to redshift Datawarehouse.The goal of this white paper is to help you to understand how to increase the download performance into redshift by using an intermediate AWS RDS instance and push the whole load using AWS data pipeline. We review in detail how to set up an AWS Data pipeline and steps to achieve clean download maintainingscalability and performance. After reading this whitepaper you will be able to make an educated decision and choose the solution that best fits your needs. 

Setting up AWS Datapipeline for RDS MySQL to RedShift