I am having some confusion as to how to decide what to choose between
Data Consolidation/Data Integration and
Data Synchronisation? I know that:
Data Consolidation/Data Integration: refers to the collection and integration of data from multiple sources into a single destination. During this process, different data sources are put together, or consolidated, into a single data store.
Data Synchronisation: refers to establishing consistency among systems and data stores and subsequent continuous updates to maintain consistency.
Now suppose I have a case like this regarding a company:
- Data is present in multiple sources often department wise
- Because of this majority of time company spends in validating data rather than on useful analysis for planning
- The data definition also varies between different sources
Now given such a case which is better to use - Data integration/consolidation or leaving the data in different sources and synchronize it?
Also what other useful and relevant information should I look for that may help in making the decision and how those additional information will reflect on my decision making?