Contents
- Overview
- Required Software
- Definitions
- Installation
- Running the ETL to extract from your database or file
- Scrubbing Protected Health Identifiers from Free Text
Anchor | ||||
---|---|---|---|---|
|
Overview
The ETL program Extracts patient information from existing systems, Transforms the results into standard HIPAA safe medical vocabularies, and Loads the results into a locally controlled Peer node.
...
Anchor | ||||
---|---|---|---|---|
|
Definitions
ETL: (1) Extract (2) Transform (3) Load
...
Anchor | ||||
---|---|---|---|---|
|
Required Software:
Java 1.5 or later
MySQL 4.1 or later
Anchor | ||||
---|---|---|---|---|
|
Installation
(1) Unzip the ETL zip archive to a directory of your choice
...
# Extractor for the VSL pipeline #
Wiki Markup |
---|
\[DB\] Database Connection |
Wiki Markup |
---|
\[XML\] XML Formatted File |
[DB] Database Connection
[XML] XML Formatted File
[CUSTOM] \[CUSTOM\] Custom Wiki Markup
Extractor for the VSL pipeline=DB
The wizard will then ask which type of DB extractor to use:
# Database Extractors #
Wiki Markup |
---|
\[STANDARD\] Standard Pathology LIMS |
Wiki Markup |
---|
\[MGH\] MGH Frozen Tissue Repository |
Wiki Markup |
---|
\[BWH\] BWH Frozen Tissue Repository |
[STANDARD] Standard Pathology LIMS
[MGH] MGH Frozen Tissue Repository
[BWH] BWH Frozen Tissue Repository
[CRIMSON] Crimson Biomaterials Collection \[CRIMSON\] Crimson Biomaterials Collection Core Wiki Markup
Database Extractors=STANDARD
...
Done.
Anchor | ||||
---|---|---|---|---|
|
Running the ETL Program
Running ETL on Demand
Syntax:
...
ETLRunner myConfig.xml hours 1 MM-DD-YYYY HH:mm:ss
Anchor | ||||
---|---|---|---|---|
|
SCRUBBER
The SCRUBBER can be setup to de-identify text "on the fly" before it is loaded into the peer database.
We recommend using the 2.8 scrubber because it has numerous upgrades. For more information, contact us.