Tutorial: Common Data Model & Extract-Transform-Load (ETL)

Loading Map....

Date(s) - 09/24/2016
8:00 am - 12:00 pm

Washington Hilton


This tutorial is partof the 2016 OHDSI Symposium. It will take place on Saturday, September 24th at the Washington Hilton in Washington DC.

Learning objectives and technical competencies:

  • Learn the OMOP CDM v5 community standard (data structure, content, conventions)
  • Design an ETL specification using WhiteRabbit
  • Build a OMOP CDM database in a RDBMS
  • Evaluate data quality using ACHILLES


  • Knowledge of relational database schemas
  • Laptop, ability to download and install Java application (for WhiteRabbit), install R (for ACHILLES)
  • For hands-on exercise:
    • 1) Download SYNPUF data and load into local PostgresQL database
    • or 2) have access to a different source data in RDBMS or csv format

Rimma Belenkaya, MS, MA – Memorial Sloan Kettering Cancer Center
Erica Voss, MPH – Janssen Research & Development
Mark Velez, MA – Columbia University
Karthik Natarajan, PhD – Columbia University


Registration for this tutorial is full. We do however anticipate cancellations. If you’re interested in attending please complete our waiting list form. As spaces become available, we will invite participants from the waiting list to attend on a first-come-first-served basis.

Waiting List