AWS Launches a New Quick Start for Data Warehouse Deployments. Using the new Quick Start, it is now easier to deploy a modern enterprise data store on Amazon Web Services Inc.’s (AWS) cloud. Quick Starts are developed in collaboration with partners and provide automated reference deployments for specific cloud workloads. This simplifies the process of configuring, configuring, and running projects with the required AWS resources. The “Modern Data Warehouse” Quick Start for deploying an enterprise data warehouse (EDW), is built on Amazon Redshift, which also includes Tableau Server’s data visualization and analytics capabilities. [Click on the image to see a larger view.] Data Warehouse Quick Start Architecture (source AWS) It includes:
Chavez
  • Amazon Redshift is a data warehouse that provides enterprise-class relational database queries and management systems.
  • Tableau Server is used for business intelligence (BI), data visualization capabilities, and a Tableau Server sample dashboard that shows how to connect to multiple AWS data sources.
  • A sample dataset that is loaded to an Amazon Redshift cluster for efficient creation of large-scale aggregates. Developers have the option to load their own data.
  • Amazon Relational Database Service (Amazon RDS), which is based on PostgreSQL, provides high-query-volume aggregate table that feed scale-out dashboards.

In a blog post, the company stated that you can either build a new VPC [Amazon Virtual Private Cloud] infrastructure, which is configured for security, scaleability, and high availability, OR use your existing VPC infrastructure to deploy the data warehouse. AWS CloudFormation templates simplify the deployment and allow customization options for instance types, network resources, and configurations for Amazon Redshift, PostgreSQL and Tableau Server. The Quick Start includes detailed information and step by step instructions. You can find more information in the “Data Warehouse Modernization on the AWS Cloud PDF.”