Data Migration vs Data Integration

Data Migration vs Data Integration: Know The Differences

Data Migration vs Data Integration: Know The Differences

Data migration: The process of transferring data between computer storage types or file formats. It is a key consideration for any system implementation, upgrade, or consolidation.

Data integration: Combining data residing in different sources and providing users with a unified view of them.

To delve a little deeper, Data Integration can be described and explained as a combination of technical and business processes used to combine different data from entirely separate – sources in order to turn it into valuable business insight.

This process essentially aligns, combines and presents each data store to an end-user.

 

Data Migration Explained

“Data Migration is the process of transferring data from one system to another while changing the storage, database or application. In reference to the ETL (Extract-Transform-Load) process, data migration always requires at least Extract and Load steps.

Typically data migration occurs during an upgrade of existing hardware or transfer to a completely new system. Examples include: migration to or from hardware platform; upgrading a database or migrating to new software; or company-mergers when the parallel systems in the two companies need to be merged into one. There are three main options to accomplish data migration:

  • Merge the systems from the two companies into a brand new one
  • Migrate one of the systems to the other one.
  • Leave the systems as they are but create a common view on top of them – a data warehouse.”

h/t to dataintegrationinfo for this info!

Data Integration Explained

“Data integration involves combining data from several disparate sources, which are stored using various technologies and provide a unified view of the data. Data integration becomes increasingly important in cases of merging systems of two companies or consolidating applications within one company to provide a unified view of the company’s data assets. The later initiative is often called a data warehouse.

Probably the most well known implementation of data integration is building an enterprise’s data warehouse. The benefit of a data warehouse enables a business to perform analyses based on the data in the data warehouse. This would not be possible to do on the data available only in the source system. The reason is that the source systems may not contain corresponding data, even though the data are identically named, they may refer to different entities.”

Data Integration Areas

Data integration is a term covering several distinct sub-areas such as:

  • Data warehousing
  • Data migration
  • Enterprise application/information integration
  • Master data management”

h/t to dataintegrationinfo for this info!

 

Need some expert advice on all data related solution? Click here to get in touch with us today!