Data Migration Professional Services and Examples

Below is a list of professional services that we offer. To learn more about any of our services, such as what exactly the service entails, who it could benefit, or for additional case studies or instances where we have rendered that service for our clients, simply click on any service page from the list above or below:

Data / Database Migration Services

At its core, a data migration is the process of either:

  1. converting data from one format into another
  2. moving data from one storage location to another, or
  3. a combination of both; that is.. Continue reading
Case Study
Client's Industry Client's Objective Our Service Delivery / Solution
Manufacturing Our client was headquartered in Sweden and manufactured large mining equipment. They had 8 different sites across the world that produced technical documentation (eg, Parts Catalogs, Technical Service Manuals, Safety Bulletins etc), and most of the sites were using different legacy systems. Our client purchased a new SaaS system for all of their technical documentation, and required all of their legacy technical information to be migrated into the new SaaS system. Our client used various legacy systems, including LinkOne, Catbase, SparePort2, and some home grown systems. Our solution involved us writing enterprise level custom migration software that could ingest the data from each of these various legacy systems, analyze it, convert it according to our client's specific business rules (which could vary across sites or regions), and ultimately produce XML and SVG files that could be published into the target SaaS system. We also wrote tools to integrate with the SaaS system's APIs in order to bulk publish all of the converted content.

In total, we migrated:
  • 1,000,000+ parts
  • 300,000+ Engineering Bills of Material (BOMs), aka assemblies
  • 100,000+ Engineering Diagrams
  • 15,000+ Parts Catalog Manuals
  • 100,000+ Related Technical Manuals (TSMs, Service Manuals, Safety Bulletins, etc)

View more Data / Database Migration Case Studies

Migrating/Converting Records Services

A record migration is the process or result of migrating (or converting) records from one data format or system, into a different format or system. Migrating records is similar to a data or database migration, but differs in that the perspective of looking at the data, as well as cost, are pre determined based on the number of records.

To demonstrate the difference between.. Continue reading

Case Study
Client's Industry Client's Objective Our Service Delivery / Solution
Construction Our client had an Asset Management system, but for their worldwide fleet of construction equipment, the AM system was not the system of record (although it should have been). Their objective was for us to accurately gather all of the distinct records of their fleet, as well as the assemblies which make up each machine, which spanned multiple product lines across multiple continents and manufacturing centers, and merge them into one maintainable location and to serve as their system of record (source of truth for their fleet). The challenge in this project was that all of the data came from secondary and tertiary systems, often times not even from any kind of Asset Management system, but rather from their Technical Publications groups who produced technical documentation for the equipment that each publisher's site manufactured. Our solution involved successfully decrypting, ingesting and analyzing data across multiple systems, and aggregating a single database for their worldwide fleet.

In total, we:
  • analyzed records from 4 different documentation systems
  • ingested over 8TB of data and over 18 million files
  • accurately migrated a fleet of 10,000+ records
  • accurately migrated 150,000+ engineering assembly records

Read more about other record conversion / migration services we delivered to clients

Services to Convert or Migrate Images in Bulk

Image conversions and image migrations can be described slightly differently, as follows:

  • Image Conversion
    An image conversion is the process or result of batch converting images from one format into another, and/or modifying image properties (eg making transformations, or changing its size, etc).
    Some examples of image conversions are:
    • Converting all images into thumbnails
    • Rotating incorrectly oriented images, such as iterating through a set of images, and fixing some orientation (eg, making sure.. Continue reading
Case Study
Client's Industry Client's Objective Our Service Delivery / Solution
Mining Industry Our client had over 40,000 engineering diagrams in CGM format. They hired a third party company to convert those CGM graphics into SVG format, but the third party converted the images without successfully quality assuring that the results are all matching correctly. The issue was that some of the CGMs had data within the file that transformed the images (a rotation transformation), and this was lost when converting to SVG. Our client approached us and asked if we could figure out a way to fix the orientation of the images. The challenge in this project was that not all of the images needed to be landscape or portrait. Some of the images were correctly portrait, and others were accurately landscape. The challenge was finding those images that were incorrectly one orientation, when they should have been a different orientation. To solve this, we wrote a custom algorithm to read the SVG data, ingest and understand each image's matrix transformations, and wrote some reports against the data. We were able to decipher which conditions determined when an image needed to be rotated 90 degrees, and whether that rotation should be clockwise or counter clockwise.

In total, we:
  • ingested over 50GB of image data
  • resolved all incorrect orientations for the images, on a set of 40,000+ SVG engineering diagrams

Read more about other bulk image conversion services we delivered to clients

Legacy System / Legacy Data Migration Services

A legacy system data migration is the process that is required to move data that was stored in a legacy system, out of that system and accurately imported or published into a new system. The steps required to perform a legacy data migration usually consists of:

  1. Understanding the legacy system and its data
  2. Analyzing the data via queries, reports, profiling, etc
  3. Gathering the business rules and.. Continue reading
Case Study
Client's Industry Client's Objective Our Service Delivery / Solution
Original Equipment Manufacturer (OEM) Our client was a large OEM company using a legacy system called LinkOne. All of their Parts Catalogs were initially created and published in the legacy LinkOne system. The client purchased a subscription to a new Software as a Service (SaaS) platform that had lots of new and improved features, including making all of their parts catalogs and parts available online and accessible across their distribution and dealer networks. The objective was to accurately gather all of the legacy content, and successfully migrate it into the new system. One of the key challenges in this legacy system data migration was that the legacy system did not have a backend database; all of the content was stored in folders on a file system. This produces a uniqueness challenge, whereby assembly files can exist in different folders, with the exact same filename, but yet the assembly content could actually be different; eg, a different version or revision of the assembly. To clarify, /some/folder/1101.ldf could be entirely different from /another/folders/1101.ldf, even though they shared the same filename in different directories. To solve this, we used a special hashing algorithm to hash the contents of each file, and to determine when an assembly was actually unique. The end result was an accurate migration of unique content into the new system, without extra fluff or duplication.

In total, we migrated:
  • 100,000+ List Definition Files
  • 40,000+ unique assemblies
  • 50,000+ unique engineering diagrams/images

Read more about other legacy system data migration services we delivered to clients

Custom Reporting Services

A custom report is a report generated outside of a standard reporting tool. While many ERP and other systems have plugins or extensions that allow reporting tools to report on structured data that exists within a database, often times there are other datasets, which may not exist within a database, and which may not be easily reported on. For example, suppose a business has a few thousand log files, but the data within those log files do not exist within any table or database. How can one go about generating a report when all of the data is fragmented across thousands of files? A custom report or custom tool that can.. Continue reading

Case Study
Client's Industry Client's Objective Our Service Delivery / Solution
Construction Our client used Framemaker to generate many of their technical / parts manuals. Although at the time they considered Framemaker good for generating content, it certainly lacks from a structured data perspective and all of the data exists within Framemaker's propriety file format. Our client had thousands of Framemaker MIF files, and needed a way to report on the data, extract the data into a more useful format, and ultimately migrate the data into a new system. Our solution was to write a custom algorithm to parse MIF files, looking for specific types of data that our client was interested in. MIF files can be difficult to work with, as they are not structured like an XML file; in fact, they're more closely related to a Portable Document Format (PDF), but the way references and links are handled can be even trickier. We essentially reverse engineered / deconstructed the way in which their data was handled within MIFs, wrote an algorithm to parse the data, and ingested all of the meaningful data into a custom database. From there, we were able to easily present reports to the client, including answers to key questions like: how many unique assemblies are there, or how many cases of a certain exception exist, or where do we think there are typos in a certain field which does not conform to a field's intended format. Answering these quesetions and more via custom reports proved to be a key ingredient in the overall success of the data migration.

In total, we:
  • ingested 10,000+ MIF files
  • provided 2+ dozen custom reports that answered key questions about the data

Read more about other custom reports and reporting services we delivered to clients

Custom Data Analysis Services

A custom data analysis is essentially any analysis performed on one or more datasets by an expert who can work with, ingest, analyze and interpret data.

Although a data analysis should be an integral part of many types of projects, it is often over shadowed and/or not even considered at all. Often times projects are simply kicked off and the requirements gathering session begins, but the analysis of the project's data is completely missing, and thus there is.. Continue reading

Case Study
Client's Industry Client's Objective Our Service Delivery / Solution
Engineering Our client had tens of thousands of engineering diagrams, and they wanted to know how often a certain condition is present within their drawings. Generally, images would not be considered easily analyzable data. Most people would be familiar with raster graphics (BMP, GIF, JPG, etc), but they lose quality as the size of the image is increased. In order to retain the ability to scale a type of image or drawing, it is better to create the image as a vector graphic, rather than a raster graphic. Most modern engineers will design using CAD systems, and CAD drawings can be exported to a vector format, such as SVG (Scalable Vector Graphics), which retains the mathematic data that makes up the drawing. A vector image is made up of math (lines, curves, matrix transformations, etc), rather than colored pixels. As a result, we were able to ingest all of their vector image data into a database and perform an expert analysis of the data via complex modeling and queries. This allowed us to locate certain conditions, and provide an expert analysis that would answer the questions they had about which drawings were comprised of certain conditions. This was a unique case of data analysis, but proved to be effective at answering the questions posed by our client.

Read more about other expert data analysis services we delivered to clients