Events
Space shortcuts
Space Tools

Versions Compared

Old Version 1

changes.mady.by.user Janice Donahoe

Saved on

compared with

New Version Current

changes.mady.by.user Janice Donahoe

Saved on

Key

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

Presentation Slides

 

Section

AMIA 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 session about i2b2 and REDCap. Four members of the i2b2 community presented information on how they have integrated i2b2 and REDCap at their institutions. Below are links to each of their presentations and a video of the session.

 

 

Section

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

 

Sectiontip
Anchor
i2b2FoundationUpdatei2b2FoundationUpdate
Section
Column
width50%
titleTip on Viewing Video in Full Screen

Follow these easy steps to view the video in "Full Screen" mode.

  •  Start the video
  •  A task bar will now appear at the bottom of the video.
  •  Click on the YouTube icon to bring you to the tranSMART YouTube Channel.

Image Added

 

  •  The video should start automatically, once it does click on the Full Screen icon.

Image Added

 

  •  Video will now play on your full screen.

 

 

 

 

Column
width50%
View file
namei2b2Update-AMIA-Nov2016-DIANE.ppsx
height250

 

 

 
Section

 

Section

Presentations (4)

 

 

Section

i2b2 and REDCap
Anchor

etlEpic

aug-

Campbell

redcap-harris

etlEpic

aug-

CampbellEnhancing interoperation: an i2b2 ETL schema for Epic EHRs

redcap-harris

 

Presenter: James R. Campbell, MD, University of Nebraska 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=FIfmXZlfw2UlSDZCKdJKjI

 

 

Column

Presentation Slides

 

View file
namei2b2EpicETLs2017-AMIA-Nov2016-JIM_REDCap_I2B2_Harris.ppsx
height250

 

 

 

 

 

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

 

 

      • SCILHS Network
      • SCILHS Research Cycle
      • mySCILHS; Utilizing REDCap to engage patients and provide gateway to multimodal patient outcome reporting into i2b2

 

Section
Column
width50%

Presentation Video

 

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

 

Column

eYu6GnUEUkY&feature=em-share_video_user


Column
width50%

Presentation Slides

 

View file
namePostEurekaETL2017-AMIA-Nov2016-ANDREW_Boykin_mySCILHS_AMIA.ppsx
height250

 

 

 

 

 

 

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
      • SEINE - Synthesizing EDC IDR Network Exchange
      • REDCap Forms, Fields, Data into i2b2 Folders, Concepts, and facts
      • Use Case: Pilot project - Triple Negative Breast Cancer (TNBC) Registry
      • SEINE DataBuilder
      • Data Deliver via REDCap
      • and so much more...

 

 

Section
Column

Presentation Video

 

Widget Connector
urlhttps://www.youtube.com/watch?v=
LZzh6p1uiEs
5dAnXxfG2vM&feature=em-share_video_user


 

Column

Presentation Slides

 

View file
name
HERONi2b2ETLNov2016-RUSS.ppsx
2017-AMIA-IIT01_Connolly_KUMC.pdf
height250

 

 

 

 

 

 

 

 

 

 

ETL with Business Intelligence Development Studio (BIDS)

 

Presenter: Mike Mendis, Partners HealthCare – i2b2

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

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
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

 

      • General i2b2 Statistics for 2016
      • Integrating i2b2, Excel & REDCap
      • Process of using i2b2, Excel & REDCap at URMC
      • Use cases and "gotchas" learned along the way
      • Usage statistics for Excel generations, REDCap syncs, & REDCap Chart Reviews


Session Summary

Section
Column

Presentation Video

 

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

 

Column

Presentation Slides

 

View file
nameETLwithBI2017-AMIA-Nov2016-MIKE_i2b2_redcap_excel_ng.ppsx
height250