Pre-Lab Setup

Steps

  • Introduction
  • Create the Student Environment

Introduction

This guide helps students set up the pre-environment for the AWS Database Migration Service (AWS DMS) lab.

AWS DMS required source and destination as shown below:

Your instructor will provide you source database details during main lab to configure source endpoint. If you ran instructor lab to setup your own instance of Postgres database then use instance endpoint from instructor lab.

In this lab, you will complete the following pre-requisite using AWS CloudFormation template deployment:

  • Create required VPC setup for AWS DMS instance.
  • Create Amazon S3 bucket for destination end point configuration.
  • Create Amazon S3 buckets for Amazon Athena query result storage.
  • Create required Amazon S3 bucket policy to put data by AWS DMS service.
  • Create AWS Glue Service Role to use in later hands-on workshop.
  • Create Amazon Athena workgroup users to use in Athena workshop.
  • Create Amazon Lake formation users to use in Lake formation workshop.

Create the Student Environment

Make sure you select the ap-southeast-2 (Sydney) region

  • Sign in to the AWS console where you will host the student environment.
  • Navigate to the AWS CloudFormation page.
  • Click the Deploy to AWS icons below to stand up the DMS pre-lab 1 workshop infrastructure.
Launch Template Region
Launch Stack in ap-southeast-2 Sydney (ap-southeast-2)

  • In Specify stack details, provide a name for “Stack Name” as “dmslab-student”.
  • Click on Next.

  • In review page, review all the details, scroll down and check the box to acknowledge the policy and then click on Create Stack.

  • Launch the stack. It may take 5 minutes for the stack to launch.

  • Go to the Outputs tab and note down all resource information in a notepad as you are going to use them in future labs:

Congratulations!!! You have successfully completed student lab and setup all pre-requisite required to run rest of the workshop. Please proceed to next lab Batch Data Ingestion with DMS.