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.

If this article was helpful, subscribe to the Passionate About OSS Blog to get each new post sent directly to your inbox. 100% free of charge and free of spam.

Our Solutions


Most Recent Articles

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.