It is also important to factor in the long-term implications of maintaining these manipulations if there are no plans to use technology to automate them.The cost of automation technologies may seem high until you compare them to the cost of doing the same thing manually.
The data sources will not have identical models, and defining the mappings between them will require a considerable amount of effort.
Before beginning, costs, additional time, and increased complexity of data manipulation due to structural differences must be considered.
The dynamics of managing and integrating data sources are complex and highly variable, and often result in having new sources which are similar to or duplicate parts of existing sources.
The challenge is that these disparate data sources must work together and share information.
Many businesses have data stored in multiple data sources with similar data structure.
For example, you might have a separate data center per continent within your area of operation.In most instances, the sheer number of sources and their data can’t keep this from happening without adding significant complexity and effort.The continuous expansion of data sources is a key driver for consolidation initiatives, and sources that can be configured to work together can improve organizational efficiency and reduce capital expenditures.The process Blazent creates delivers consolidated records that are complete, accurate and current, and are elaborated in the “Best Practice Configuration Management Database (CMDB) Migration” white paper, linked here.I was wondering if there is a way to merge data from two different data sources. Unfortunately these are not possible with Data Grabber.In the short-term, it may appear too complex to execute this kind of initiative; however, with the proper assessment, planning and use of available technologies and services, the return far outweighs the challenges of maintaining the status quo.