© 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

James Wiggins, HCLS Solutions Architect, AWSDario Rivera, HCLS Solutions Architect, AWS

4/3/18

OHDSI on AWS

© 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.© 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

OHDSI on AWS

Features

• A complete OHDSI environment including a data warehouse with sample data

• Deployed in an isolated, three-tiered Virtual Private Cloud• Uses data at rest and in flight encryption for HIPAA

eligibility• Uses managed services: OS, middleware, and database

patching and maintenance is largely automatic• Automated backups for operational and disaster recovery• The entire environment is built automatically in a little over

an hour• Reasonable monthly cost.

Objective

To provide a

well-architected implementation of popular OHDSI tools that can easily be deployed by anyone.

© 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

Researchers

Amazon Redshift Cluster

Amazon Relational Database Service (Amazon RDS)

Aurora PostgreSQL

AWS Elastic Beanstalk

ApplicationLoad

Balancer

Clinical Data

Vocabulary

Results

ATHENA

ACHILLES

OMOP CDM

OHDSI on AWSHigh-Level Architecture

ATLAS WebAPI

AWSCloudFormation

© 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

AWS Region / VPC

Availability Zone A Availability Zone B

Internet Gateway

(or VPN)

Encrypted RDSSnapshots

Auto-Scaling

Apache and Tomcat Servers

Aurora Postgres RDS Master

Aurora Postgres RDS Slave

Researchers

Application Load

Balancer

Apache and Tomcat Servers

Synchronous Replication

Redshift Cluster

Encrypted RedshiftSnapshots

Public Tier

Private Application Tier

Private Database Tier

Elastic Beanstalk

VPC NAT Gateway

© 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

Useful Reference Links

• AWS big data blog post• Loading data into Redshift• Restoring a Redshift Cluster from a snapshot• Tuning Redshift query performance• Controlling access to Redshift• Updating your Elastic Beanstalk environments platform version