Home

Perseus

Perseus combines intuitive and easy-to-use Web-based UI for design and implementation of ETL (extract, transform, and load) configuration and service for conversion the native/raw data to the OMOP Common Data Model (CDM).

The typical sequence:

1. Scan native data
2. Map tables
3. Map fields
4. Convert to CDM
5. Check data quality
6. Save mapping

Tutorials

• Connecting to native data

  • Scan native
  • White Rabbit scan report

• Link native tables to CDM tables

  • Link tables
  • Order/Filters
  • Drop links
  • Filter by source fields/Field details
  • Concatenating native tables

• Link native fields to CDM fields

  • Start mapping
  • Direct mapping
  • Constant
  • Sql functions
  • Vocabulary lookup
  • Mixed
  • Fields groups
  • Clone
  • Condition
  • Similar fields
  • Concept configuration

• Search in the standardized vocabularies

• Save/continue progress

• Convert native to CDM

• Convert Fake data to CDM

• Generate ETL document

• Check data quality

• Code mapping

  • Load new codes
  • Configure mapping
  • Reviewing
  • Modify
  • Usage in ETL
  • Drop