How to succeed in data migrations with Profit’s Migration Tools

Oct 13, 2014 | News

According to a recent study 75 percent of new systems fail to meet expectations, often because flaws in the migration process result in data that is not validated for the intended task.* How can we validate data in order to minimize risks in the actual data conversion process? Profit Software presents Conversion Engine and Conversion Data Pre-validation tool, migration tools that are used when converting data into Profit Life & Pension system.

Starting point in insurance policy conversions is usually complex. In a typical migration project we have data in system X that needs to be converted into the new system in a right form. At the same time we have to pay attention to the complexity of the structure and how we can find equivalence to that in the new system.

There are typically two ways to carry out conversions: do all at once or execute it in phases, iteratively. With iteration we refer to both testing and to the actual conversion. When testing is iterative small issues can be found in time and further problems can be prevented. When the conversion takes place iteratively we have possibility to minimize risks in production. Iteration allows to test the actual conversion process and make sure that tools as well people involved in the process are functioning in a right way.

We at Profit Software have over 20 years of experience of large scale migration projects and based on our knowledge conversion is the most critical part. In order to guarantee successful conversions from a system X into our solution, Profit Life & Pension (PLP), we have developed Conversion Data Pre-validation tool and Conversion Engine.

Conversion Data Pre-validation tool is a stand-alone application that analyses and validates conversion source files. It’s used in the development phase when iterating and testing data. It does not have dependencies to PLP so it can be used independently by the team responsible of exporting the source data. This makes it possible to iterate the data corrections very quickly. The tool enables to find quality problems in source data quality before the conversion phase so it minimizes bugs in production.

Conversion Engine will form the backbone of any actual client conversion project. It is used to import data into PLP by reading conversion source files. The conversion engine will only convert the actual business data (i.e. policies, clients etc.). Any technical data are generated according to the PLP data model requirements. The conversion will also result some batches being scheduled in PLP to be executed on the newly converted data.

The projects will usually have additional requirements of their own for the conversion process on top of the generic requirements. The Conversion Engine and Conversion Data Pre-validation tool has been designed as flexible and extendable as possible. It makes it possible for these project-specific requirements to be implemented as easily and straightforwardly as possible as extensions to the Migration Tools.

Migration Tools minimize risks since

  • Source data is validated and analyzed during the entire project
  • Migration data is converted and tested in batches before the actual conversion takes place
  • Migration project is transparent and project lead can follow progress throughout the project. With transparency we refer to the fact that we get continuous information of data quality.

Profit’s Migration tools enable a productized way to implement conversions with minimum risks. Tools make it possible to start the migration project at the same time with the overall project and to have quality data with small margin errors.

Interested in knowing more? Please contact: Learn more about Profit Life&Pension from

*Successful Data Migration. Rep. Oracle, Oct. 2011.
conversion engine migration pre-validation tool source file


Profit Software ranked number 120 on the Tivi 250 list

Tietoviikko has published its yearly report on Finland’s 250 largest ICT companies. It states that ICT sector has grown rapidly; one sign was that minimum revenue limit in order to get to the list was 10.4M euros when it last year was 9.1M euros. The average turnover...

Profit Software rebrands as Evitec to support Nordic expansion

Profit Software is a leading provider of system solutions and consulting services to the Nordic financial service industry. It also offers analytics and information management services across multiple industries. The company is now starting a major rebranding project...


System renewal – an upgrade in technology or also something else?

When discussing a system renewal, hot topics are amongst other digitalization, automation, conversions, and migration. And nothing wrong with these, all important factors ensuring the new system operates as whished and delivers the expected benefit. But will a system...

Tuotekehitystä ketterästi ja yhdessä oppien

Tässä sisältösarjassa tuomme esille Profit Softwaren eri kehittäjätiimejä. Nyt esittelyvuoron saa Mikan ja Teron johdolla tuotetiimimme, joka on erikoistunut Profit Life & Pension -järjestelmään tunnetussa ja pitkäaikaisessa finanssialan asiakkuudessamme. Mika...

Mitä löytyy modernin sopimushoitojärjestelmän ytimestä?

Digitalisaatio on jo monen vuoden ajan ollut kestopuheenaihe vakuutusalalla. Koronaviruksen tuoma paine pystyä palvelemaan asiakkaita etäyhteyksin kiihdytti keskustelua entisestään. Yhtiöt ovatkin viimeistään koronan myötä kehittäneet asiakasrajapinnassa tapahtuvaa...

Alanvaihtajina IT-alalla

Haastattelimme kolmea, jo pitkän uran vakuutus- ja pankkialalla työskennellyttä profitlaista: Annikaa, Elkaa ja Maijaa. Annikalla ja Elkalla on takanaan parisenkymmentä vuotta työskentelyä vakuutusalalla, Maijalla on pitkä kokemus pankkimaailmasta. Alanvaihtajina...