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 conducting the cleansing and transformation of the data in-memory. We eliminate the need to use additional data repositories as a landing zone for data prep, as well as, removing the need to add additional vendors for data orchestration.

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!

image

FOCUS & EXPERTISE

IT resources internally are there to focus on designing and deploying new applications and keeping the current environment operational. Which leaves the rather difficult and unglamorous work of wrangling, cleansing, transforming, and moving data from source systems unaddressed. Lack of a tested methodology and the people who are experts in data migration can mean that migration projects spin out of control, putting entire initiatives at risk. And because data migration is often a one-time effort, many companies lack the in-house expertise necessary to do it correctly. Organizations that want to realize maximum value from an acquisition or a newly deployed application can’t afford to take chances with data migration.

image

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.

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

Expert Transforms

Background Image
Filter on Expressions

This transform allows you to filter rows based on an expression. Use it to select what data rows you would like to work with

Create Based on Expression

This transform allows you to create a new column utilizing existing columns' values, or string or numeric literal

ID Value

This transform allows you to set the ID value for an NNData object

Split Columns

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

Base 64

The Base64 transform encodes and decodes data using the base64 scheme

Split Row

The split row transform splits a row into two or more rows based on naming patterns found in columns that allow sets of columns to be grouped together