Data Migration

Large-scale data migrations – done right

Moving Onward to a New System?

Your new solution needs to fuse your ongoing data flow with your historical data. But that data is stuck in your legacy system. You face the challenge of finding and extracting your old data, and migrate what matters into the new solution. The data has to be checked for quality and fitness to ensure it conforms to your new setup. Only then can your operations rely on the new solution.

Make your data migration a success with T2S’ distinctive combination of technical know-how, business experience, data experts and solutions.

Read more about our proven approach and extensive experience with data migration and integration. Scroll down for our checklist with 5 tips for a successful data migration.

  • Migrate your data with minimal risk and no delays
  • Proven strategies and tools for retrieving, transporting and validating data
  • T2S Data Migration Platform and Data Quality Monitor
  • Agile approach in order to be able to respond quickly to changes
  • Extensive data migration and integration experience
  • Business-critical migrations done on time

Proven Data Migration Approach

Type 2 Solutions uses a standard data migration approach for retrieving, transforming, validating and loading data. This approach consists of the following steps:

1. Data migration plan

We start with a preliminary study of the data migration with a data migration plan as deliverable. This plan includes: the data migration strategy, the action plan, a risk analysis, the data migration process, the control framework, the data quality optimization process, the planning and the required resources and tools.

2. Carrying out the data migration

The data migration is carried out according to the established data migration plan:

  • We start with the target system (or the target systems).
  • Within the target system, we identify the data sets (business objects) within the scope of the data migration. Examples of data collections are customers or relations, contracts and prices.
  • We make a migration model per data collection. This is a contract in which the agreements regarding the data are recorded.
  • Based on the migration model, we perform an analysis of the source system (or the source systems).
  • Then we extract the data from the source system.
  • The data is loaded into the T2S Migration Platform.
  • The platform handles transformation and validation of the data.
  • All exceptions that hinder a successful data migration are presented in the T2S Data Quality Monitor.
  • If all data is correct, it will be loaded into the target system.

Iterative process

A data migration is an iterative process. We use an agile approach in order to be able to respond quickly to changes. Validating the entire process and the associated data is a joint responsibility of you, us and the supplier of the new system.

After various test migrations, extensive testing and after approval by the steering group based on the predefined acceptance criteria (control framework), the final data migration takes place.

Data migration T2S

Importance of test runs

John Wittekamp, ​​Chief Technology Officer at DELTA Fiber Netherlands emphasizes the importance of test runs during a migration:

The role of Type 2 Solutions is focused on the quality of the data transfer and is therefore an important part of the team to ensure that you as a whole make the right choices to transfer that data correctly. In particular, performing another test run was typically something that was very much stimulated by Type 2 to ensure that you also achieve the best quality you can deliver.

T2S helped DELTA Fiber Netherlands with the data migration to the new IT systems by deploying data specialists alongside the data migration platform & data quality monitor within the organization on a project basis.

Video – Interview with John Wittekamp CTO DELTA Fiber Netherlands.

T2S Data Migration Solutions

Migration Platform

The transport of your data is done with our T2S Migration Platform. A software platform that can access, transform and validate data from the most diverse IT systems and process it into a format that can be imported into another IT system. If your operations have to keep going 24/7, the platform can help with running the legacy system in parallel with your new solution.

Data Quality Dashboard

Data integration and conversion projects often face unanticipated data quality challenges. The T2S Data Quality Monitor helps you to tackle data quality issues. It provides that kind of insight that makes it possible to improve and maintain data quality.

Checklist Data Migration

Five things your boss does not want to hear

We have collected 5 statements that are heard at some point in any given migration project, whether from the project team or from the business itself. For each of them, we have put together a number of tips to prevent them. And hopefully, they will help you, so you never again need to say:

  We’re running out of budget!

t2s-time  We’re running out of time!

t2s-recources  We’re running out of resources!

t2s-not-workingThe new system is not working!

t2s-liveWe can’t go live!

Client Testimonials

“ Type 2 Solutions has handled the data migration to our fullest satisfaction. Their approach has been utterly professional and thoroughly organized. Another important fact is that they really got into our business processes. ”
Patrick Dankaart Technical and Maintenance Manager at N.V. Westerscheldetunnel
“ Type 2 Solutions’ proven methodology, unambiguous risk analysis, and hands-on approach have helped us achieve our goals in this project. The data migration specialists at Type 2 Solutions are experts in their domain and extremely efficient. By proficiently managing activities and deliverables, they have succeeded in making crucial advances in a very short time. I have thoroughly enjoyed working with them on this project. ”
Ruben Alebregtse Finance Director at Veenman
“ We identified integration as being one of the most serious risks of the initial Carmen implementation at Finnair. Type 2 Solutions embraced these risks, and delivered a solid integration solution, thereby contributing to the timely completion of the project. Beside the technical integration, Type 2 Solutions provided valuable input during the process integration part of the project. Together with Carmen systems they played a significant role in re-engineering our planning process. ”
Ville Iho COO & Deputy CEO at Finnair

Extensive Experience

We have over 18 years of experience with data migration and data integration. In addition to extensive experience with various database platforms, such as Oracle, Microsoft SQL Server, IBM DB2 and MySQL, T2S has experience in migrating data to and integrating data between various IT systems and software packages.

Our data specialists have experience with data migration, integration and data quality projects in various fields such as aviation, finance, food, chemicals, logistics, healthcare, government, IT, mobility, energy, telecom and multimedia.

T2S has experience with data migrations of and data integration with the following IT systems, software packages and database platforms:

  • SAP
  • Dynamics 365 Business Central (MS Dynamics NAV / AX)
  • Mainframe AS400
  • UMAX 365 (MS Dynamics 365)
  • AFAS
  • Progress (QAD)
  • Aptic
  • Oracle Utilities Customer Care and Billing
  • MaxBill
  • Exact online
  • GEA Toll system
  • Transaction Information and Processing System (Toll system TIPS)
  • Carmen Crew Management System (Jeppesen)
  • ORTEC Workforce Scheduling (Harmony)
  • Magento eCommerce platform
  • Selligent marketing platform
  • Fusion Equation (Finastra – Banking operations)
  • SafeWatch (EastNets)
  • Dynamics CRM
  • Care4 ECD/EPD
  • User ECD/EPD
  • mijnQuarant EPD
  • SAP BO
  • Microsoft Azure
  • Informatica
  • Power BI
  • SSIS (SQL Server Integration Services)
  • SSRS (SQL Server Reporting Services)
  • IBM DB2
  • Oracle on Linux
  • Oracle on AIX
  • Microsoft SQL Server
  • Informix
  • Sybase
  • PostgreSQL
  • MySQL

Let’s Talk Data Business

Feel free to contact us to discover the possibilities for your company. Please leave your details and we will contact you as soon as possible.