Clinical Data Mart (CDM) – CDM is a special CDIS feature in which data can be fetched in bulk from an EHR system into a REDCap project. CDM must be initiated on the project creation page and the ability to create a CDM project is managed through the REDCap user profile. To retrieve the desired data a fetch request must be created and within that request the date range in which to look, specific data elements, and a list of MRNs must be specified. These three requirements can be provided at the time of project creation or after creation from within the Clinical Data Mart page. CDM historically was best suited for researchers who are conducting retrospective studies and need to pull EHR data once and with minimal updating.
CDM is a special CDIS feature in which data can be fetched in bulk from an EHR system into a REDCap project.
CDM must be initiated on the project creation page.
To retrieve the desired data a fetch request must be created and within that request the date range in which to look, specific data elements, and a list of MRNs must be specified.
CDM is best suited for researchers who are conducting retrospective studies and need to pull EHR data once and with minimal updating.
Introduction
The Data Mart feature is used for importing patient data in bulk into a REDCap project. While CDP is
meant for pulling one patient at a time, Data Mart can pull dozens or hundreds of patients’ data into
REDCap all at once. Like CDP, Data Mart is using the CDIS infrastructure, so it only needs to be set up
once, after which both CDP and Data Mart will utilize it.
Instructions
To use the Data Mart feature and create a Data Mart project, a user must be given explicit permissions
for this by a REDCap administrator on the Browse Users page in the Control Center. Once they have been
given permissions, they can navigate to the Create New Project page in REDCap to see a new option to
create a Clinical Data Mart project (see screenshot below). Note: If they have not yet launched the
REDCap window from inside their EHR, it will inform them that they must first do so before proceeding.
This must be done because launching the REDCap window inside the EHR, which is always the first step
before a user can use either CDP or Data Mart.
Once the project has been created, the whole structure of the project (i.e., the fields and forms) will be
pre-defined. To begin pulling clinical data from the EHR, the user must navigate to the Clinical Data Mart
page using the link on the left-hand project menu. On that page, they may request changes to their
existing Data Mart configuration (if they wish to add new MRNs, new fields, or modify the date range)
and/or pull data from the EHR using the “Fetch clinical data” button near the top of the page. By default,
users will only be able to pull data just one time and will not be able to modify the Data Mart
configuration after initially being set when the project is created. However, an administrator can change
these settings (see below) on the Project Setup page so that they may pull data as often as they wish or
to allow them to make configuration changes when needed.