Session 1: i2b2 REDCap Integration


Date: March 27, 2017

 

Presenters: 


Philip Ng, Managing Director, i2b2 Foundation

Presentation: Data Data Democratization, Using i2b2, Excel, REDCap in End-User Extracts


Stanley Boykin, Computational Health Informatics Program (CHIPS), Childrens Hospital Boston

Presentation: Multimodal Collection of Patient Reported Outcomes mySCILHS


Dan Connolly, Kansas University Medical Center

Presentation: SEINE: There and Back Again

 


Session Summary

At the 2017 Joint Summits on Translational Science, the i2b2 Foundation held a .

 

 

Presentations (5)

 

i2b2 Foundation Update

 

Presenter: Diane Keogh, Managing Director, i2b2 Foundation

 

Discussion Highlights:

  • Accomplishments to date
  • Source code repositories
  • Sharing i2b2 plugins
  • Community Support Efforts – Educational webinar series
  • Exploring partnership between i2b2 and tranSMART foundations

 

 

 

 

Presentation Slides

 

 

 

 

 

 

Enhancing interoperation: an i2b2 ETL schema for Epic EHRs

 

Presenter: James R. Campbell, MD, University of Nebraska

 

Discussion Highlights:

      • ETL Library for Epic EHRs
      • Organizing i2b2 for interoperation
      • i2b2 ETL architecture for Epic EHRs
      • Data warehouse extracts vs CCDA vs FHIR interface for transportability of code

 

Presentation Video

 

 

 

Presentation Slides

 

 

 

 

 

i2b2 ETL - Eureka Clinical Analytics Project at Emory University

 

Presenter: Andrew Post, MD, PhD, Atlanta Clinical & Translational Science Institute

 

Discussion Highlights:

  • ETL tools used to load from central warehouse into i2b2
  • EMR is Cerner
  • Implemented incremental loading

 

 

Presentation Video

 

 

Presentation Slides

 

 

 

 

 

HERON ETL for i2b2 and Discussion on how we might support reproducible science as a community

 

Presenter: Russ Waitman, PhD, University of Kansas Medical Center

 

Discussion Highlights:

  • HERON ETL Data Flow
  • Jenkins used to automate the ETL process
  • Data Sources:
    • REDCap
    • Clarity
    • IDX
    • University Health system consortium data

 

 

Presentation Video

 

 

Presentation Slides

 

 

 

 

 

 

Additional Resources

 

KUMC maintains overview of our HERON ETL process here:

https://informatics.kumc.edu/work/wiki/HERON

 

Links to an older code repository:

https://informatics.kumc.edu/work/browser/heron_load

 

Through our work with the GPC we are now maintain our current code repository on Github

https://github.com/kumc-bmi

 

The actual HERON ETL is in a private project https://github.com/kumc-bmi/heron. Once you have a GitHub account, contact Dan Connolly and Heron-Admin@kumc.edu  to get access to the latest code.

 

 

 

 

 

ETL with Business Intelligence Development Studio (BIDS)

 

Presenter: Mike Mendis, Partners HealthCare – i2b2

 

Discussion Highlights:

  • BIDS is Visual Studio development environment

  • Microsoft offers SQL Server and Business Intelligence stack provides

    • SQL Server / T-SQL query engine
    • Integration Services provide ETL tools
    • Analysis Services provides tools to build multidimensional databases…
    • Reporting Services provides tools to build reports and a portal to deploy reports

 

  • i2b2 ETLsMicrosoft Connectors available for Oracle database support

    • Can be used to populate i2b2 data marts
    • Run stored procedure to convert to standard format

 

Presentation Video

 

 

Presentation Slides