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.
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.
Modules. The first three steps are free. The Data Quality Toolkit opens with any paid module.
Edition. Free browser edition, Desktop or Server.
A real DataBridge screen, with sample data from a demo instance.
How DataBridge does it.
Each step names the feature as it appears in the product.
- 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.
- Step 2
Validate File
Check a file against a template and list every problem by row and column.
- Step 3
Data Diff
Compare the file before and after cleaning, with an optional key column, to see exactly what changed.
- 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.
- 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.
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.
Related pages.
Try the parts that are free today.
The free browser edition needs no sign-in and never uploads your files.