Background Image

DATA MIGRATION

Data Migration with NNCompass applies proven technology and expertise for data migration success. Our approach reduces your infrastructure footprint & cost by transforming the data in-memory. We eliminate the need to use additional data repositories as a landing zone for migration efforts.

84%

of migration projects fail to meet expectations

37%

suffer cost overruns

67%

are not delivered on time

No worries... NNCompass is here to help!

Data Co-Location Vs True Integration.

Many organization will leverage a cloud providers migration services or worse they may rely on a traditional system integrator who uses an eclectic kit bag of conversion tools…the problem is, neither approach is Data Integration, it is simply Co-Location! Co-locating data doesn’t improve your analytics and in many cases, it doesn’t reduce the costs associated with sustaining your data enterprise. So, before you just let a vendor run off and migrate your data. You need to start asking the tough questions about how they will apply the various steps associated with the ETL process to ensure you don’t take the same “dirty” data into your new “clean” cloud! Challenge them to address back-ups, archiving, and streaming data while also taking into consideration minimal disruption to operations.

image

In-Memory Transforms for Data Migration

Background Image
Change Column Names

This transform will change an existing column name to a name you specify

Ignore / Hide Columns

Hiding/Ignoring column names will hide them from the data view. It won't delete them from the original data

Merge & Create Column

Select two or more columns to merge (or concatenate) together. Merging two or more columns results in a newly created column

Split Columns

Split multiple key value pairs found inside one column into multiple columns

Find & Replace

Find text within a column, or across all columns, and replaces it with text you specify

Create Based on Formula

This transform lets you create new data columns based on mathematical operations

Outlier Handler

Sometimes mistakes are made when manually inputting numerical data. Here you can specify acceptable ranges on any numerical column

Data Masking

Data masking is the process of hiding original data with random characters or data. Protect data that is classified as personal identifiable

Normalize Dates

Dates are normalized during the ingest process, but you can still select a date column and change the way the date is displayed

Text Enrichment while Migrating Data

Background Image
"Easy Add" Extractions

Select from a dropdown list of the commonly found things in unstructured text, like key value pairs, phone numbers, dates, emails, URL's, SSN's, Credit Card Numbers and financial data like dollar and euro figures

User Assisted Extraction

A breakthrough in extracting value out of unstructured text this allows you to train NNCompass on key / value pairs specific to your data. A powerful way to allow non-technical users to apply regular expression extractions

Expert Mode Extraction

If you're an expert user you can write in your own RegEx, or start with prebuilt "East Add" extractions and modify them to your needs

Split Columns

Split multiple key value pairs found inside one column into multiple columns

Find & Replace

Find text within a column, or across all columns, and replaces it with text you specify

Create Based on Formula

This transform lets you create new data columns based on mathematical operations