Attention A T users. To access the menus on this page please perform the following steps. 1. Please switch auto forms mode to off. 2. Hit enter to expand a main menu option (Health, Benefits, etc). 3. To enter and activate the submenu links, hit the down arrow. You will now be able to tab or arrow up or down through the submenu options to access/activate the submenu links.

VA Technical Reference Model v 21.7

M Data Extractor (MDE)
M Data Extractor (MDE) Technology

General InformationGeneral Information help

Technologies must be operated and maintained in accordance with Federal and Department security and privacy policies and guidelines. More information on the proper use of the TRM can be found on the TRM Proper Use Tab/Section.

Website: Go to site
Description: M Data Extractor (MDE) performs data migration from File Manager-based M and Cache`s hierarchical format to structured query language (SQL) databases while transforming the hierarchical data relationships within File Manager-based M and Cache to equivalent relationally-based linkages. This technology converts File Manager data types to standard SQL data types. Data is filtered so only the desired data is extracted. The extractions are placed into a Relational Database Management System (RDBMS) for use by technologies such as data warehouse/mart, clinical software applications, data analysis tools, and ad hoc reporting.

MDE extracts data from Veterans Health Information Systems and Technology Architecture (VistA) and Composite Health Care System (CHCS) 1 and automatically moves the data across the network to databases supporting the Web, data warehouse/marts, or local applications. This technology deposits the extracted data ready-for-use in the target database. This technology extends the life and value of VistA and CHCS 1 by delivering data to external software applications or databases that help a facility achieve clinical, managerial, operational, or financial objectives.

This technology is certified for Oracle Database and Microsoft Structure Query Language (SQL) Server databases.
Technology/Standard Usage Requirements: Users must ensure their use of this technology/standard is consistent with VA policies and standards, including, but not limited to, VA Handbooks 6102 and 6500; VA Directives 6004, 6513, and 6517; and National Institute of Standards and Technology (NIST) standards, including Federal Information Processing Standards (FIPS). Users must ensure sensitive data is properly protected in compliance with all VA regulations. Prior to use of this technology, users should check with their supervisor, Information Security Officer (ISO), Facility Chief Information Officer (CIO), or local Office of Information and Technology (OI&T) representative to ensure that all actions are consistent with current VA policies and procedures prior to implementation.
Section 508 Information: This technology has not been assessed by the Section 508 Office. The Implementer of this technology has the responsibility to ensure the version deployed is 508-compliant. Section 508 compliance may be reviewed by the Section 508 Office and appropriate remedial action required if necessary. For additional information or assistance regarding Section 508, please contact the Section 508 Office at Section508@va.gov.
Decision: View Decisions

Decision Source: TRM Mgmt Group
Decision Process: One-VA TRM v19.9
Decision Date: 09/24/2019
Introduced By: TRM Request
Vendor Name: Strategic Reporting Systems, Inc.
- The information contained on this page is accurate as of the Decision Date (09/24/2019).