Data Integration Service

A data integration product should be platform independent. It should also have the capacity to integrate data regardless of the following:

• Required frequency
• Communication protocol
• Business rules needed for intricate integration patterns

There are primarily three types of products that stem from the data integration space:

• Extract Transformation and Load (ETL): These products are built to move large data volumes while offering the capability to carry out effective transformations. They are often found in a batch process algorithm. This is due to the availability of data volumes and the frequently used transformations like summation, aggregation, sorts and multi-table joins.
• Enterprise Application Integration Products (EAI): These are often known as brokers or messaging software. These are designed in such a way that they move a smaller amount of data with amplified frequency patterns.
• Enterprise Data Replication (EDR): These products present information when data sets are modified or changed. These are delta-processing or change-data capture products. They often work on either a triggering or log-scraping mechanism. Also, they offer a pointer to the last extraction point for tracking the data that has been processed.