Events
Space shortcuts
Space Tools

Versions Compared

Old Version 1

changes.mady.by.user Janice Donahoe

Saved on

compared with

New Version 2

changes.mady.by.user Janice Donahoe

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section

Session 1: i2b2 REDCap Integration


Date: March 27, 2017

 

Presenters: 

Philip Ng, Managing Director, i2b2 FoundationPaul Harris, PhD, Vanderbuilt University Medical Center

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

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

 


Philip Ng, Managing Director, i2b2 Foundation

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


Session Summary

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

 

 

Enhancing interoperation: an i2b2 ETL schema for Epic EHRs

 

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

and REDCap

Section

Presentations (

5

4)

 

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

 

Section
Anchor
i2b2FoundationUpdatei2b2FoundationUpdate
Section
Column
width50%

 

 

 

Column
width50%

Presentation Slides

 

View file
namei2b2Update-AMIA-Nov2016-DIANE.ppsx
height250

 

 

 

 

 

Section
Anchor
etlEpic-CampbelletlEpic-Campbell
Anchor
aug-redcap-harris
aug-redcap-harris

 

Presenter: Paul Harris, PhD, Vanderbuilt University Medical Center

 

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
      • Overview of REDCap
      • Where i2b2 and REDCap Intersect
      • Use Cases

 

 

Section
Column

Presentation Video

 

 

Widget Connector
urlhttps://www.youtube.com/watch?v=FIfmXZlfw2U

 

Insert widget macro and link to YouTube Video

Column

Presentation Slides

 

View file
namei2b2EpicETLs-AMIA-Nov2016-JIM.ppsx
height250

Attach presentation slide show

 

 

 

 

Section

Multimodal Collection of Patient Reported Outcomes mySCILHS

Anchor

etlEureka

amia-

postetlEureka

redcap-

post

 

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

boykin

i2b2 ETL - Eureka Clinical Analytics Project at Emory University

amia-redcap-boykin


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

 

Discussion Highlights:

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

 

 

      • x

 

Section

 

Column
width50%

Presentation Video

 

Insert widget

urlhttps://www.youtube.com/watch?v=jbJEA3mVx_w
Column

macro and link to YouTube Video


Column
width50%

Presentation Slides

 

View file
namePostEurekaETL-AMIA-Nov2016-ANDREW.ppsx
height250

Attach presentation slide show

 

 

 

 

 

ETL with Business Intelligence Development Studio (BIDS)

 

Section

SEINE: There and Back Again
Anchor

etlHeron

amia-

Waitman

redcap-connolly

etlHeron

amia-

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

redcap-connolly

 

Presenter: Russ Waitman, PhD, University of Kansas Dan Connolly, Kansas University 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
      • x

 

 

Section
macro and link to YouTube Video

 

Column

Presentation Video

 

Insert widget

urlhttps://www.youtube.com/watch?v=LZzh6p1uiEs
Column

Presentation Slides

 

View file
nameHERONi2b2ETLNov2016-RUSS.ppsx
height250

Attach presentation slideshow

 

 

 

 

 

Section

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

 

Info Box
titleAccess to Repository

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.

 

 

 

 

 

Section
Anchor
etlBI-MikeetlBI-Mike
Presenter: Mike Mendis, Partners HealthCare – i2b2
Section

Data Democratization, Using i2b2 , Excel, REDCap in End-User Extracts
Anchor
amia-redcap-ng
amia-redcap-ng

 

Presenter: Philip Ng, University of Rochester Medical Center

 

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

 

      • x


Session Summary

Section

 

macro and link to YouTube Video

Column

Presentation Video

 

Insert widget

urlhttps://www.youtube.com/watch?v=WT4aXjW3oNU
Column

Presentation Slides

 

View file
nameETLwithBI-AMIA-Nov2016-MIKE.ppsx
height250

Attach presentation slide show