Home

The Northwestern University Biomedical Informatics Center (NUBIC) is made up of faculty and staff who are part of The Robert H. Lurie Comprehensive Cancer Center, the Center for Genetic Medicine, the Feinberg School of Medicine, the Northwestern University Clinical and Translational Sciences Institute (NUCATS). The operational side of NUBIC has three major components: the Enterprise Data Warehouse (EDW), the Bioinformatics Core, and the Translational Informatics group. The EDW is the integration and reporting hub for all clinical and human translational science done at Northwestern. The Bioinformatics Core is focused on clinical research informatics, high-throughput biology analysis (microarrays, proteomics, next generation sequencing). The Translational Informatics Group is focused on delivering software solutions for clinical research, basic research and translational research using Agile software best practices, existing medical data standards and biomedical ontologies.

Recent Posts

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

    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

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

    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