Fig 1 - Data quality firewall prevents duplicates with DataMatch Enterprise + API
Data Ladder provides a data quality management suite that includes all the sorts of capabilities that one would expect, plus self-service data preparation capabilities. Specifically, the company offers DataMatch Enterprise and ProductMatch, where the former works exclusively with structured data and the latter with semi and unstructured data and which is targeted at manufacturers and retailers. As well as a free to download trial edition the main editions of DataMatch Enterprise are DataMatch Server Enterprise, and DataMatch Server Enterprise + API. The last of these offers real-time capabilities that is intended to prevent duplicates getting into your systems in the first place, with the API either being called from a database trigger, or being used as an intermediate layer between the database (Oracle, Db2, SQL Server, Access, MySQL, PostgreSQL, Teradata) and application, as illustrated in Figure 1.
Other supported integrations include ODBC, OLE DB, Excel, CSV files, XML, JSON, text files and Salesforce. Object storage is also supported as are NoSQL data sources such as Hadoop and MongoDB.
A cloud-based version of DataMatch Enterprise (which will include the aforementioned data preparation) is currently undergoing beta testing.
Customer Quotes
“The step by step and wizard-like tool walks you through the process of setting up a project. It’s very intuitive and allowed us to build all kinds of projects and bring in all kinds of data sources… The interface allowed us to get good results and it’s very simple to use.”
Bell Bank
“DataMatch Enterprise™ was much easier to use than the other solutions we looked at. Being able to automate data cleaning and matching has saved us hundreds of person-hours each year.”
St John Associates