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
Date: November 14, 2016
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.
Presentations
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
Video
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
video
presentation
i2b2 ETL
Presenter: Andrew Post, MD, PhD, Atlanta Clinical & Translational Science Institute
Discussion Highlights:
- Eureka Clinical Analytics project at Emory
- ETL tools used to load from central warehouse into i2b2
- EMR is Cerner
- Implemented incremental loading
video
presentation
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
video
presentation
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
video
presentation