Markit EDM

We have recently been involved in a number of projects using Markit EDM, an enterprise data management tool from IHS Markit. These projects have included the creation of a brand new enterprise application and also large scale complex data migrations (involving multiple source and destination systems and complex non-intuitive data relationships) using EDM as the underlying engine.

While by no means an exhaustive list of EDM's capabilities, these are some of my favourite features:

  • Browser interface - it is incredibly easy to build a web application using EDM. This is extremely useful for providing access to a wider audience within an organisation without the need for them to install specialist software.
  • The ability to create and manage unique ID's for data items (e.g. a client, or a financial security) that may be sourced from different systems and have different (or no) identifiers. While you would hope that you would already have a pretty decent key for this kind of information in your architecture, where that isn't the case this is an extremely useful feature. It comes built in with the ability to apply complex rules (for example if you end up matching client information on 'fuzzy' information like names, initials, NINo's). It also provides standard screens for managing these ID's after they have been issued, to allow control over reallocation to different values (for example, you had 2 records for Mr Smith which have been consolidated into 1) and to alert you to scenarios where this may be necessary.
  • Packaging and version control - promotion of built components through different environments (dev / test / more test / production etc) is made easy using package export and import, coordinated with support for both in-built and external version control systems
  • Data tracking - the ability to view audit and source information easily to see where a particular data item came from