reference deployment

Salesforce Data Warehouse on Amazon Redshift

Gain insights from your Salesforce data in an Amazon Redshift data warehouse

This Partner Solution sets up a highly available pipeline that ingests Salesforce data into an Amazon Redshift data warehouse on the Amazon Web Services (AWS) Cloud. Using this Partner Solution, your organization can deploy an Amazon Redshift instance and load sales and opportunity data from your Salesforce environment in a few steps.

Keyrus logo

This Partner Solution was developed by Keyrus in partnership with AWS. Keyrus is an AWS Partner.

  •  What you'll build
  • This Partner Solution sets up the following:

    • A highly available architecture that spans two Availability Zones.*
    • A virtual private cloud (VPC) configured with public and private subnets, according to AWS best practices, to provide you with your own virtual network on AWS.*
    • In the public subnets, managed network address translation (NAT) gateways to allow outbound internet access for resources in the private subnets.*
    • In the private subnets, an Amazon Redshift cluster of Dense Compute (DC) nodes, one in each subnet. These nodes handle all the Amazon Redshift database work.
    • Amazon AppFlow to create a mapping method to transfer Salesforce data to Amazon Redshift. Mapping creates all destination fields. This solution includes a sample workflow-mapping .swl file for account, contact, case, lead, and opportunity objects.
    • AWS Lambda to create all the required database objects and schema with tables in the Amazon Redshift cluster and to invoke Amazon AppFlow.
    • Amazon Simple Storage Service (Amazon S3) to store the Amazon Redshift logs.
    • AWS Secrets Manager to store and manage Amazon Redshift credentials.
    • AWS Key Management Service (AWS KMS) to encrypt the data within Amazon Redshift.

    * The template that deploys the Partner Solution into an existing VPC skips the components marked by asterisks and prompts you for your existing VPC configuration.

  •  How to deploy
  • To deploy this Partner Solution, follow the instructions in the deployment guide, which includes these steps.

    1. Sign in to your AWS account. If you don’t have an AWS account, sign up at
    2. Connect Amazon AppFlow to your Salesforce account.
    3. Launch the Partner Solution. The stack takes about 15 minutes to deploy. Before you create the stack, choose the AWS Region from the top toolbar. Choose one of the following options:
    4. (Optional) Change the flow trigger.

    Amazon may share user-deployment information with the AWS Partner that collaborated with AWS on this solution.  

  •  Cost and licenses
  • You are responsible for the cost of the AWS services and any third-party licenses used while running this Partner Solution. There is no additional cost for using the Partner Solution.

    No licenses are required to deploy this Partner Solution.

    The AWS CloudFormation template for this Partner Solution includes configuration parameters that you can customize. Some of these settings, such as instance type, affect the cost of deployment. For cost estimates, see the pricing pages for each AWS service you use. Prices are subject to change.

    Tip: After you deploy the Partner Solution, enable the  AWS Cost and Usage Report to track costs associated with the Partner Solution. This report delivers billing metrics to an Amazon Simple Storage Service (Amazon S3) bucket in your account. It provides cost estimates based on usage throughout each month and aggregates the data at the end of the month. For more information about the report, see  What are AWS Cost and Usage Reports?