Use case · Migration and data quality

Fix the file before it reaches the ERP.

Most failed imports come from the file, not the ERP. Clean and check it first: start free in your browser, then add rules and duplicate matching with the Data Quality Toolkit.

The problem

A bad import costs a rollback, a call to someone and a second try. Spaces in codes, mixed date formats, duplicate rows and malformed emails are all findable before the load.

What you need

Modules. The first three steps are free. The Data Quality Toolkit opens with any paid module.

Edition. Free browser edition, Desktop or Server.

Pricing and what each edition includes.

A real DataBridge screen, with sample data from a demo instance.

Steps

How DataBridge does it.

Each step names the feature as it appears in the product.

  1. Step 1

    Quick Transform

    One-click clean-ups with no template: whitespace, duplicates, dates, phone numbers and lowercase emails. Output is CSV, TSV or JSON.

  2. Step 2

    Validate File

    Check a file against a template and list every problem by row and column.

  3. Step 3

    Data Diff

    Compare the file before and after cleaning, with an optional key column, to see exactly what changed.

  4. Step 4

    Data Quality Toolkit

    Templates carry rules for required values, length, type, range, pattern and code lists such as US state codes. The Raw to Cleaned mapping splits names, lowercases email, strips phone punctuation and normalizes address parts.

  5. Step 5

    Record Matching

    Find duplicates with exact, normalized or fuzzy rules, choose how survivors are picked, and export a merge report that shows each decision.

Honest limits

What this does not do.

  • The rules check that values are well formed. They do not confirm that an email address or phone number exists, and they do not check street addresses against a postal database.
  • The free browser edition handles CSV and TSV files up to 10 MB and Excel files up to 5 MB, 100,000 rows each.

Marketplace packs used: Data Quality Toolkit. See the Marketplace.

Keep reading

Related pages.

Next step

Try the parts that are free today.

The free browser edition needs no sign-in and never uploads your files.