Restricted access

October 28, 2010

Data Integration in Brief

Filed under: Data Integration — Katherine Vasilega @ 7:04 am

Let’s get back to basics! With all the data integration buzz around, it is useful to get data integration terms defined. There you go.


When you deal with data integration, you will come across these two terms, sooner or later. What do they actually mean? The objective of Master Data Management (MDM) is to provide and maintain a consistent view of company’s main business entities. Many MDM applications concentrate on handling customer data, because it improves sales and the marketing process. The term for customer MDM solutions is Customer Data Integration (CDI).

MDM and CDI are often presented as technologies, but in reality they are business applications. The objective of both MDM and CDI is to provide a consistent view of dispersed data. This view is created using data integration techniques and technologies.

Data Integration Techniques

The techniques involved in data integration process include

    Data Consolidation captures data from multiple sources and integrates it into a single data warehouse.
    Data Federation provides a single virtual view of source data files.
    Data Propagation copies data from one location to another.

Data Integration Technologies

These techniques may be implemented using Extract, Transform, Load (ETL), Enterprise Information Integration (EII), Enterprise Application Integration (EAI), or other technologies like Enterprise Data Replication (EDR), Enterprise Content Management (ECM), etc.

It is quite common for MDM and CDI applications to use a hybrid approach that involves several data integration techniques and technologies.

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment