In short DM REVOLVE is
- DataMC’s ground breaking proprietary data migration toolset
- Powered by BIDM methodology
- Developed over decades by industry experts
- A proprietory toolset used by DataMC on every engagement
- Clients get to experience the full use of the tools whilst working with DataMC consultants
Here we present a small breakdown of some of the DM REVOLVE tools we use.
TAP – Toolkit Access Portal
The control hub of DM REVOLVE, TAP houses all of our toolsets
- WOM – Workflow-O-Matic
- POM – Profile-O-Matic
- MOM – Map-O-Matic
- ROM – Report-O-Matic
- TOM – Translate-O-Matic
- FOG – File-O-Gen
From here you can access any of the tools you will need for a data migration.
WOM is the gatekeeper of DM REVOLVE. Through the WOM interface, every part of our 15 step 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
Problems can be spotted quickly. Tracking shows the history of objects throughout the project. Relevant parties are informed when objects reach each stage of the process. WOM makes the process transparent, and accountable.
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 checks it against the expected data set then signs off in order to progress to the next stage.
MOM takes the completed selection criteria and performs the 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. Its 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 client’s subject matter experts (SME’s), as well as DataMC Technical Leads, Analysts, and Coders.
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 White to W, Red to R and Blue to B then this is the place to do it. All the results can be exported if needed.
TOM is also the place to perform inflight data duplication cleansing – this could be merging separate accounts into one along with any data associated with them if needed.
File-O-Gen generates load files from stored model tables, these are ready for import into the target system. Once generated the loads can be tested daily, this leads to
- Fast generation of structured files
- Repetition of the load
- Catching and correcting errors
- Automation and predictability