Data Integration Types

Data integration is the process of transferring data between different storage types and locations. This typically includes extraction, cleaning, loading into target data repository and verification.”’s Data Integration page.

Whilst cross-referencing some data integration work that I was doing recently, I came across this great web-page with helpful icons and descriptions for the different types of data integration, as follows:

  1. Data Migration – transferring existing data sets into a new data repository
  2. Data Consolidation – brings multiple sets of data together into a singular repository
  3. Data Federation – brings data from many different sources into a single repository
  4. Data synchronization – different repositories contain the same information
  5. Master Data Management – processes / tools to manage data across multiple repositories

Before seeing this page I’d never even thought of classifying my data modelling / mapping exercises into different categories like this. The terminology does make more sense though, so this becomes my new terminology baseline for data integration.


Most Recent

What’s your Everest?

What’s your Everest? I was out doing a walk today and listening to a podcast (Jeff Lerner‘s “Unlock your Potential” with guest Colin O’Brady [episode #226]) and

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.