DataMatch Enterprise

DataMatch Enterprise

by Data Ladder • • Data Quality Tools

No reviews yet
Pricing on request View plans

DataMatch Enterprise is Data Ladder's data matching software for deduplicating and cleansing records across files and databases without code. Quote only.

DataMatch Enterprise finds the records in a company's data that describe the same person, business or address, then flags or merges them. Data Ladder, a data quality software company in Suffield, Connecticut, makes it alongside Product Match, a separate tool for product data. The job it takes over is the slow comparison of spreadsheets and database exports, where spelling variants, nicknames and stray formatting hide duplicates. It runs as a desktop toolkit, and a Server Edition also ships as a Docker build. A project usually opens with data profiling, which reports blank values, distinct counts, frequencies and patterns for every field. The data cleansing and standardization tools then fix casing, trim spaces, remove characters, fill nulls and clean telephone numbers, with the Pattern Builder for custom formats. Built-in libraries handle name verification and common nicknames. Match configuration compares records with exact, fuzzy and intelligent matching, and Match Scoring sets the threshold at which a pair counts as a duplicate. Address Verification checks US addresses against USPS CASS, DPV, LACSLink and SuiteLink data. The toolkit suits data analysts, CRM administrators and operations staff who own a customer, member or patient list that has grown untidy. Its no-code screens let business users build profiling, cleansing and matching rules without a developer. Healthcare, education, government, retail, finance and insurance teams are the sectors Data Ladder builds for, along with sales and marketing. Buyers choose between three editions: the base toolkit, one adding the API for real-time fuzzy search, and one adding Address Verification. Organizations that must keep records inside their own network can run it on their own machines, on Linux or in their own cloud. Typical jobs are clearing duplicates from a contact list before a mailing and linking one customer's records across several systems. Records come in from Excel workbooks, CSV and text files, XML and JSON, Oracle and other SQL databases, and Snowflake through its data connector. Results arrive as a table of matched pairs with a score for each, ready for a reviewer to check. Recurring work runs from the command line or the Scheduler, while the REST API lets another application send records for matching. DataMatch Enterprise fits the team that must settle which records are the same before anyone can rely on the data.

Features

  • Included: Automated column profiling
  • Not included: Declarative quality rules in YAML or SQL
  • Included: No-code rule authoring
  • Not included: Reusable rule library across datasets
  • Not included: Anomaly detection on quality metrics
  • Not included: Quality score per dataset
  • Not included: Quality checks in CI and orchestration runs
  • Not included: Data contracts with enforcement
  • Included: Standardisation and cleansing transforms
  • Included: Duplicate detection with fuzzy matching
  • Included: Address and reference data validation
  • Not included: Issue assignment and remediation workflow
  • Not included: Alerts to chat and ticketing tools
  • Not included: Quality results published to a catalog
  • Included: Checks across warehouses, lakes and files
  • Not included: Open source checks library
  • Included: Private deployment in your cloud

Additional Features

  • Data profiling with blank, distinct and frequency counts
  • Pattern Builder regex wizard
  • Name verification and nickname libraries
  • Telephone number cleansing
  • Casing, trimming and null filling transforms
  • Exact, fuzzy and intelligent matching
  • Match Scoring with a 0 to 100 percent threshold
  • Record deduplication
  • USPS CASS, DPV and LACSLink address verification
  • SuiteLink and Canadian postal code fields
  • Excel, CSV, XML and JSON file sources
  • Oracle and SQL database connections
  • Snowflake data connector
  • Real-time fuzzy search through the API edition
  • Command line projects
  • REST API for matching requests
  • Docker build of the Server Edition

Best for

  • Teams deduplicating customer, member or patient lists
  • Business users who build matching rules without code
  • US mailers that need CASS-certified address verification
  • Organizations that keep data on their own servers or cloud
  • Healthcare, education and government data teams
  • Retail, finance and insurance record keepers
  • Sales and marketing operations cleaning CRM data

Use cases

  • Removing duplicate records from a contact list
  • Linking records about one customer across systems
  • Standardizing names, phone numbers and casing
  • Verifying US postal addresses against USPS data
  • Profiling a new dataset for blanks and invalid patterns
  • Matching an Excel file against a SQL database
  • Reviewing scored match pairs before a merge
  • Searching a database for near matches in real time

Screenshots & Videos

Explore DataMatch Enterprise in action

Datamatch Enterprise Homepage With Match Results
View full size
Datamatch Enterprise Homepage With Match Results

User Reviews

Write a Review

No reviews yet

Be the first to share your experience with this software.

Compare with Similar Software

Click to compare side by side with DataMatch Enterprise

Want to claim this brand?

To claim this brand, please contact support.