AWS Entity Resolution vs MatchCore

AWS Entity Resolution links records that may describe the same customer, product, business, or healthcare entity across applications, channels, and data stores. It offers rule-based, machine learning, and data service provider matching. Rule-based users can adjust input fields, priorities, and rules; the preconfigured machine learning model compares consumer fields such as names, email addresses, phone numbers, addresses, and birth dates, then assigns match groups confidence scores from 0.0 to 1.0. Inputs come from AWS Glue, with a limit of 20. Rule-based matching can process new Amazon S3 data incrementally, and the GetMatchId API can synchronously look up an existing match ID while hashing personally identifiable attributes. Access is through the AWS console and API. Personally identifiable data is encrypted at rest by default with AWS-owned keys, with customer-managed symmetric AWS KMS keys also supported. Provider matching includes LiveRamp, TransUnion, and Unified ID 2.0 identifiers, subject to a provider license agreement. AWS states that the service meets PCI DSS and SOC 1, SOC 2, and SOC 3 measures. Pricing is paid, from $0.10; there is no free plan.

MatchCore profiles, standardizes, matches, and merges customer, vendor, and product records to create deduplicated golden records. Its profiler examines completeness, null rates, distinct values, entropy, anomalies, and semantic field types. A visual cleansing pipeline supports case conversion, punctuation removal, parsing, regex replacements, and phone or ID number cleansing. The platform says it includes more than 300,000 standardization rules for names, addresses, and phone data. Matching options include exact, phonetic, fuzzy, edit-distance, token-based, and ML-enhanced algorithms, with configurable field weights and confidence thresholds. Survivorship rules can prioritize values by field, source, completeness, or recency. Import options include SQL Server, Oracle, Teradata, MySQL, Salesforce, CSV, Excel, tab-delimited files, JSON, and ODBC. Its Orchestrator schedules daily, weekly, or monthly runs and can react to source updates. Deployment options include desktop, server, and REST API; desktop runs locally and keeps data on the user’s machine. Plans start at $417 a month, billed annually at $5,000 per user license. A 14-day trial is offered without a credit card requirement.