Data Migration
With our proven methodology, we cost-effectively support the data migration activities of organizations during system implementations and core builds.
When is data migration necessary?
Data migration (selecting, extracting, transforming and transferring data from one system to another) is a common task in IT. However, datasets can exist in many different states and locations, so some data migration projects can be more complex and technically difficult.
In addition, there is often a huge gap between the data requirements of the old and the new system, which can only be bridged through careful planning and early involvement of business stakeholders.
Finally, over the years, even the best-designed database can become chaotic: some data become outdated, and incorrect and duplicate data are created. As processes and business needs change, new data elements emerge and others lose relevance. Data migration provides an opportunity to reassess what is worth saving from the data assets.
Data Migration by DSS Consulting
Our migration services include
- Conceptual design of data movement between systems
- Organized and monitored execution of large-scale data flows between systems during system replacements and implementations
- Building a single deduplicated master from data from multiple systems when building customer master records
- The development of a rule-based, flexible and parameterizable set of tools with built-in data cleansing and data manipulation procedures
Our experience
We have performed data migration tasks in many cases, often in combination with data cleansing, data warehouse development and other developments such as:
- Data cleansing and migration tasks related to new systems to be implemented at a large banking client
- For a leading insurance client, we supported the migration of a customer database with the provision of experts and the development of related reports
- We migrated the data warehouse of our statistical analytics and data services client to a new technology platform and also replaced the data query and analysis applications with a single OLAP analytics application – all the functions provided by the system are now available in a web browser
Technologies
We use the best-known technologies to facilitate our migration projects:
- PL/SQL
- Oracle
- DSS Quality Monitor, DSS Consulting’s proprietary Oracle-based data quality assurance and migration solution
