In short DM REVOLVE is
- DataMC’s ground breaking proprietary data migration toolset
- powered by BIDM methodology
- developed over decades by industry experts.
Here we present a small breakdown of some of the DM REVOLVE tools we use.
WOM is the gatekeeper of DM REVOLVE. Through the WOM interface every part of the data migration is
- reported on
- signed off
For each of the data objects it is easy to see
- what stage in the process they have progressed to
- if they are on schedule
- quality of the data
- who is responsible for it at that time
Any problems can be spotted quickly and tracking shows a history of each data object throughout the project.
POM – the selection criteria from the legacy source is used to obtain the required data set, this is then used to create the data objects. All relevant information for each object is recorded here, such as
- the data source
- table names
- the description of the object
- any other notes
The SQL Select statements used to Extract data from the legacy sources are recorded. Once the data has been Extracted, the data owner will need check it against the expected data set, then sign it off in order to progress to the next stage.
MOM takes the completed selection criteria and performs mapping from
- source (legacy) system data fields
- target load template fields
This work is performed by the data analyst and subject matter experts (SMEs) from the client. Required translations and Data quality (DQ) checks are identified at this stage along with the severity of any data quality issues.
Once mapping for a data object has been completed it is submitted for
- on to the next stage
- goes through the MOM cycle again
The ROM review process shows the results of
- POM – selection Criteria
- MOM – Mapping
It is a verification and Data Quality step, here the verification takes place for the
- number of records
- data quality of the objects
The quality of the extracted data is tracked through ROM. It’s traffic light system shows quickly and clearly where any issues are occurring. Each of the data objects is given a thorough breakdown and reports are given for
- any errors
- the number of fields affected
- the exception encountered and its severity
- individual errors for each record
- individual fields if needed.
ROM should be reviewed and monitored by both the clients subject matter experts (SME’s), as well as DataMC Technical Leads, Analysts and Coders. Once the quality is at 100% the object can be moved on.
TOM empowers the client data owners to ensure all translations are completed and correct. This is an important step in improving data quality and ensuring a seamless migration for DataMC and the client.
All the data translations take place in TOM and are tracked and updated here. If you need a legacy field updating from say POSTCODE to ZIPCODE then this is the place to do it. All the results can be exported if needed.
File-O-Gen generates load files from stored model tables ready for import into the target system.