DM REVOLVE

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.

Workflow-O-Matic (WOM)

WOM is the gatekeeper of DM REVOLVE. Through the WOM interface every part of the data migration is

  • tracked
  • reported on
  • updated
  • 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
  • status
  • 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.

WOM – Workflow-O-Matic – the main admin area of DM REVOLVE – tracking the data objects from start to finish

Profile-O-Matic (POM)

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.

POM – Profile-O-Matic – Select and Extract the data from the legacy systems

Map-O-Matic (MOM)

MOM takes the completed selection criteria and performs mapping from

  • source (legacy) system data fields

to

  • 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

  • review
  • approval
    • on to the next stage
  • rejection
    • goes through the MOM cycle again
MOM – Map-O-Matic – maps fields from the legacy system to the new system

Report-O-Matic (ROM)

The ROM review process shows the results of

  • POM – selection Criteria
  • MOM – Mapping
  • coding

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.

ROM – Report-O-Matic – Generates data quality reports
ROM – Report-O-Matic – Generates data quality reports, identifies errors and helps fix them

Translate-O-Matic (TOM)

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.

TOM – Translate-O-Matic – Translates old values to new, either individually, automatically, or en masse

File-O-Gen (FOG)

File-O-Gen generates load files from stored model tables ready for import into the target system.

FOG – File-O-Gen – Generates Load files ready for the new system

Leave a Comment

Your email address will not be published. Required fields are marked *