Events
Space shortcuts
Space Tools

Versions Compared

Key

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

i2b2 Community Discussion at AMIA: i2b2 and ETL Processes


Date: November 14, 2016


Presenters: 

Diane Keogh, Managing Director, i2b2 Foundation

James R. Campbell, MD, University of Nebraska

Andrew Post, MD, PhD, Atlanta Clinical & Translational Science Institute (ACTSI)

Russ Waitman, PhD, University of Kansas Medical Center

 Mike Mendis, Partners HealthCare – i2b2

 

 

Section

Session Summary

The second i2b2 Educational Seminar was held on November 14, 2016 at the AMIA Conference in Chicago, IL. The main topic of this educational seminar was a community discussion around i2b2 and ETL processes. Several community members presented information about their experience using ETL tools with their EMR and i2b2. These discussions evolved into how the community can share the ETL scripts with the rest of the community.

 


 

Section

Presentations (5)

 

Section

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
Column
width50%

 

 

 

Column
width50%

Presentation Slides

 

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

 

 

 


 

 

Section

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

 

Section
Column

Presentation Video

 

 

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

 

Column

Presentation Slides

 

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

 

 


 

 

Section

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

 

 

Section
Column

Presentation Video

 

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

 

Column

Presentation Slides

 

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

 

 


 

 

Section

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

 

 

Section
Column

Presentation Video

 

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

 

Column

Presentation Slides

 

View file
nameHERONi2b2ETLNov2016-RUSS.ppsx
height250

 

 


 

 

Section

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

 

Section
Column

Presentation Video

 

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

 

Column

Presentation Slides

 

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

 

 


 

 

 

...