Software · OMOP & OHDSI

The ETL Suite for mapping any data into OMOP

Purpose-built to slot into the OHDSI suite of tools, the Rook IT ETL Suite does the heavy lifting of mapping data from any source system into the OMOP Common Data Model. The ETL-Engine performs the actual transformation work, while the ETL-Orchestrator manages pipelines of ETL-Engine runs — end to end.

From any source system
to a standardized OMOP CDM

The suite complements the OHDSI ecosystem — taking raw source data through a repeatable, auditable path into the OMOP Common Data Model, ready for analysis in tools like ATLAS and HADES.

01

Source Data

02

ETL-Engine Mapping

03

Vocabulary & Concepts

04

OMOP CDM

05

OHDSI Analytics

Two tools, one pipeline

The ETL-Engine does the actual work of transforming and mapping data. The ETL-Orchestrator sits above it, coordinating many ETL-Engine runs into managed, repeatable pipelines.

Core Transformation

ETL-Engine

The workhorse of the suite. The ETL-Engine performs the actual extraction, transformation and mapping of source data into the OMOP Common Data Model — applying vocabulary mappings and CDM conventions in a single, reproducible run.

  • Maps data from any source system into OMOP
  • Built to fit the OHDSI toolset and OMOP CDM
  • Repeatable, auditable transformation runs
Pipeline Management

ETL-Orchestrator

The conductor. The ETL-Orchestrator manages pipelines of ETL-Engine runs — sequencing, scheduling and monitoring the individual mapping jobs so that complex, multi-stage transformations run reliably and repeatably end to end.

  • Orchestrates pipelines of ETL-Engine runs
  • Sequences and monitors multi-stage jobs
  • Reliable, repeatable end-to-end execution

Download the ETL Suite

Grab the latest ETL-Engine and ETL-Orchestrator builds, then dive into the documentation to set up your first OMOP mapping pipeline.

Go to downloads

Request a license

The ETL Suite is licensed software. Tell us a little about your organization and use case, and we'll get back to you with license options for the ETL-Engine and ETL-Orchestrator.

Prefer email? Reach us directly at info@rook-it.com.

Get a license