EDW Home

The Northwestern MedicineTM Enterprise Data Warehouse (NMEDW) is a Northwestern University Clinical and Translational Sciences Institute (NUCATS) initiative funded jointly by the Northwestern University Feinberg School of Medicine (FSM), Northwestern Medical Faculty Foundation (NMFF), and Northwestern Memorial Hospital (NMH). Its mission is to create a single, comprehensive, and integrated repository of all medical data sources on the campus to facilitate operational, patient care, and research reporting. The EDW has been developed completely in-house, with no consulting fees.

Recent Posts

  1. ETL Assistant – Management Web UI Gallery

    Posted on by
    1

    Gallery of screenshots from ETL Assistant Manager – the ASP.NET MVC 3 web console for our ETL automation toolkit built on top of Cozyroc’s amazing SSIS components. This should give you a sense of exactly how quickly we can now integrate external OLEDB data sources using Microsoft SQL Server 2008. Point, Click, Consume. Easy as 1, 2, 3. Continue reading →

  2. The EDW is Hiring Data Architects!

    Posted on by
    1

    Interested in joining the team? We’re looking to hire Data Architects to help support and extend the EDW. The Data Architect is responsible for developing information architectures and complex data models, and approves the modification, and new implementation of database systems. This individual works closely with end users and IT development staff to ensure that new and existing data models and databases are consistent with approved data architecture standards. The Data Architect must have expert level knowledge and experience in data modeling and database design. Continue reading →

  6. ETL Assistant – Getting Error Row Description and Column Information Dynamically

    Posted on by
    1

    SSIS does a fine job at letting you manage “garden path” ETL, but many face the challenge of how to manage row failures. Which row failed? Why did it fail? Error row handling is a central part of any development task and usually winds up representing a significant chunk of your time and code. In this article we’ll step you through how to overcome SSIS’s design-time-only availability of error row information by creating a runtime dynamic error row handler using CozyRoc’s tool kit for SSIS. Continue reading →

  7. ETL Assistant – Using CozyRoc’s Parallel Loop Task

    Posted on by
    Reply

    In our continuing series on building your own templates, reusable “point-and-click” ETL solution using CozyRoc’s components for Microsoft SSIS, we’ll be stepping into the “Parallel Loop Task”. Microsoft’s default loop task is serial. If you ever have need to parallelize execution of SSIS tasks, overcoming this can be quite a challenge. With the Parallel Loop Task you can, with a few quick clicks, enable parallel execution of tasks and packages to maximize the utilization of your available resources. Continue reading →