Data migration can mean different things given a certain situation or task. Migration can be necessary to seed a transactional system, to move data to facilitate a hardware upgrade, to convert a legacy reporting system to a new data warehouse and marts, or to provide a consolidated view of a merged company’s data assets. Establishing a data migration strategy can be complicated, but there are some tips and tricks to maximize data assets when companies join forces. Let’s focus specifically on reporting and analytic applications.

When companies merge, no matter what the circumstances, certain economies of scale can almost always be gained by consolidating systems. Some are functional in nature, like hardware and maintenance expense, but often the larger value will be found in consolidating data assets for strategic use. Consolidating and interrogating data provides valuable insight into the successful and unsuccessful overlapping practices of both companies. This analysis can be of great benefit to identify opportunities for improvements, eliminate overlap between the organizations and provide accurate organization-wide guidance. However, to get to the value, there are architecture considerations to be addressed, tactical decisions to be made and an overall approach to be decided. So, where do you start?

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access