Data Integration is one of those necessary but evil tasks that is part of almost every project - M&A, system consolidation, customer onboarding and regulatory reporting all require data to be moved, transformed or combined.
The traditional approach to doing data integration is to have experts in the source and target systems create a map that describes how every field in the source is transformed and moved to the appropriate field in the target. This map, often captured in Excel, is then handed off to an IT team to code the ETL job that does the work. This code is then handed off to yet more teams for testing and ultimately, deployment. This process is time consuming, error-prone and expensive.
A powerful new approach to addressing this challenge involves using semantic web technology as the "data glue" to guide integration and dramatically simplify the process. There are several key components to this approach:
There are significant benefits to this approach:
Check out Anzo Smart Data Integration from Cambridge Semantics to see this approach in action.