Data Integration leverages both technical and business process to combine data into useful information for transactional analytics and/or business intelligence purposes. Data integration is formally defined as the following:
Data Integration is a set of procedures, techniques, and technologies used to design and build process that extract, restructure, move and load data in either operational or analytic data stores either in real or batch mode.
Types of Data Integration
There are different methods pr patterns of integrating data based on types of processing being performed, which includes the following:
- Transactional data integration: Focuses on how transactions are created, updated, modified, and deleted.
- Business intelligence data integration: Focuses on the collection of those transactions and forming them into a database structure that facilitates analysis.