USE CASE

Data Migration

  1. Problem description

Numerous companies, especially the larger ones, have invested a lot of time and money in recent years to stop proliferation in their IT landscapes and modernize their environments at the same time. Centralization and standardization are the means of choice here.

  1. Repercussions

Migrating many heterogeneous legacy systems, typically not from one single manufacturer, to a new centralized and modern solution inevitably entails data migration projects. The associated workload for large companies very quickly adds up to 5,000 man-days and more.

  1. Impact

However, besides the high costs and long project durations, these kinds of extensive data migrations also have other disadvantages to the detriment of the companies’ strategy and innovation. On the one hand, they can jeopardize compliance with important deadlines. For example, SAP has announced the discontinuation of all its previous systems by 2025. On the other hand, new business models, for example based on the Internet of Things (IoT), are at stake if sensors and machines are assigned to the wrong customer data. The opportunity in centralization and modernization projects, however, lies precisely in not transferring all legacy data and documents, but just the up-to-date and correct information that is really needed.

The better the data quality and smaller the volume of migrated information is, the greater the benefits of data migration are. Duplicates, incomplete or erroneous data records, for example of long-sold or closed parts of companies and business units, already only cost storage space and maintenance in the legacy systems. A new and central solution’s potential to create value is reduced accordingly if these legacy issues are also transferred to the new world.

  1. Solution

Data migration is ideal when it minimizes the amount of data to be transferred and maximizes its quality. This is precisely what is possible with a modern, central and neutral platform for information management.

The solution to the challenges is the system-independent management of the entire life cycle of legacy data and documents. Data Migration International has developed the JiVS IMP information management platform precisely for this purpose.

4.1. Data staging area

JiVS IMP generally acts as a central collection point and provisioning area or “data staging area” for company information. Data and its quality can be analyzed and optimized here, for example, using duplicate cleansing, enrichment from other, business-relevant sources and harmonization. By the way, this is of essential importance not just for migration projects, but also in all agile business scenarios such as mergers & acquisitions or digital transformation and the resulting digital business models and processes.

The JiVS IMP data staging area reveals its full benefit when migrating to the target systems in four steps:

4.2. Housekeeping

JiVS IMP is the solution to the problem of getting rid of legacy issues. As JiVS IMP allows the management of data and documents that are no longer operationally required, including their business logic throughout their entire life cycle: from their transfer from the production systems to legally compliant storage and final erasure.

The most important aspect of housekeeping, however, is that historical information remains accessible at all times. This allows companies to migrate only that part of the data to the target systems that they actually need in their day-to-day business, such as open orders.

4.3. Identify

Once the information pool has been transferred from the legacy systems to JiVS IMP, the analysis can begin of whether and which data the customers need and which they don’t. JiVS IMP offers an analysis tool with various parameterization options for this. For example, the information stored in the legacy system can be selected sorted by orders that are older than six months and have therefore already been completed, or by company codes and plants that no longer exist. Other selection criteria for data reduction potential analysis (DRPA) would include organizational units, various master data and transaction data types, or certain business objects. This DRPA results in reports for management in the form of whitelists or blacklists that specify which tables and fields in tables are transferred or are no longer required.

4.4. Design

Once it has been clarified what’s operational and what’s historical information, the detailed planning of data selection and migration follows in the design phase. This also takes place on JiVS IMP. The selection criteria from the identify phase are then further refined and tested, so that the cut in the data pool can be automatically done by software.

4.5. Transform

At the end of the design phase, JiVS IMP provides accurate and tested filter rules as whitelists and blacklists. This gives customers the choice of which tools they want to use to transform and migrate information. Alternatively, JiVS IMP can transfer the complete data package to JiVS IMP’s own Extraction, Transformation and Loading (ETL) solution.

Customers can implement JiVS IMP both in their own data center or use offers from the public cloud for implementation. Supported environments include the Google Cloud Platform, Amazon Web Services and Microsoft Azure. At the same time, customers can choose from a variety of popular database management systems (DBMS), from IBM Db2 to Oracle Database and Microsoft SQL Server to SAP IQ.

  1. Customer benefits

The advantages are obvious: The smaller data volume considerably reduces the project duration and the necessary consulting workload. Instead of 5,000 man-days, large projects usually require 2,000 man-days. Migration costs are reduced accordingly overall.

However, the advantage of optimized data quality is at least just as important. New software generations are instruments and drivers of digital transformation in companies. However, their success depends crucially on the quality of the available data. Analyses based on incorrect or incomplete data lead to incorrect results and consequently to incorrect strategies and measures. Conversely, the company that uses digitization to clean up and continuously maintain its data is ahead of the competition.

Over 1,000 implementations worldwide have shown that this concept works. The costs for operating JiVS IMP are generally 80 percent lower than the expenditure to continue running the legacy systems. The fact that the information is transferred unchanged from the legacy systems and stored audit-proof is recognized by auditors, so legal certainty with regard to the tax authorities is provided. Add to that: As a Java-based platform, JiVS IMP is independent of the systems on which it runs. Consequently, there is no spare parts problem with the hardware, as is the case with legacy systems. As a living system, JiVS IMP also allows for regular security updates, so that the risk of cyber attacks and espionage is permanently contained. Once the information, including the underlying business logic, has been transferred from the legacy systems to JiVS IMP, it can be completely switched off and disposed of.

5.1. High degree of automation

Thanks to a very high degree of automation, JiVS IMP enables the transfer of all information from legacy systems at the touch of a button. Compared to conventional methods, this corresponds to an acceleration of several orders of magnitude.

5.2. Massive data reduction

As a rule of thumb, transaction data is not required for more than one year. This means a 90 percent reduction in the original information pool for a legacy system that has been in operation for 10 years and a 95 percent reduction for a system that has been in operation for 20 years. In addition, the new systems can be kept permanently lean and can therefore be operated more cost-effectively by continuously moving information generated and processed there to JiVS IMP on a specific date, for example, one year after generation.

5.3. Fit for digitization

With the help of JiVS IMP, customers can ensure the level of data quality that is appropriate for the requirements of digitization alone – also and especially in the context of big data projects.

5.5. Massive benefits

The advantages of JiVS IMP in the context of data migrations are huge: The operating costs generally drop by 80 percent or more compared to the cost of continuing to run the legacy systems. At the same time, the migration workload is generally reduced by 50 percent, while access to legacy data and documents remains 100 percent intact. Together with the retention management function, JiVS IMP provides the basis for 100 percent legal certainty.

  1. Prices and availability

JiVS IMP is available now. The range of functions and price are determined specifically for the project.

Get More Insights

Drop us a line at anytime, and one of our employees will respond to you as soon as possible!