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

Anchor
etlEpic-Campbell etlEpic-Campbell

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

Anchor
etlEureka-post etlEureka-post

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

Anchor
etlHeron-Waitman etlHeron-Waitman

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

Anchor
etlBI-Mike etlBI-Mike

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