By Cassandra Balentine
A businesses’ data is an invaluable resource. However, in order to make the best use of it—and prevent it from getting out of control—it needs to be clean, managed, and accessible.
In the November issue of Software Magazine, we discuss the functions and power of data quality management tools, list early adopters of these solutions, and illustrate how they integrate into the enterprise.
Here, we highlight technologies that offer these functions.
BackOffice Data Quality Solutions provide a single sign-on console to finding, monitoring, investigating, and resolving the most complex data errors across all entities in a global enterprise. “The solutions are built on a dedicated data stewardship platform of modern, standardized functions that automate the process of data remediation and governance and deliver on the fly reporting to stakeholders on any aspect of the project or process,” says Tyler Warden, VP of solution management, BackOffice Associates.
Built for the business user, these solutions reduce time resolving errors, quickly upload corrected data to the target system, and easily enable businesses rules management to eliminate future errors, all while leveraging the reuse of templates, content, and other assets across multiple data management projects. BackOffice DataQuality solutions support both master data and all mainstream business application data such as ERP, CRM, and SRM, including cloud and on premise solutions.
Experian Data Quality combines software, services, and Experian data to enable business users to obtain quality, actionable data. “We believe that our strong solutions in data profiling, monitoring, data cleaning in more, paired with strong customer support and Experian data provide a very powerful offering,” says Erin Haselkorn, public relations manager, Experian Data Quality.
Today, Experian Data Quality is one of the largest players in the data quality space, according to Haselkorn. “Clients choose us because of our years of experience, solid customer service and support, innovative product suite, strong market expertise, and superior data assets. Our solutions are designed for business users, are easy to implement, and provide a return on investment quickly,” she offers.
Additionally, Experian software and services are designed to support a variety of businesses in improving the quality of its customer data, gaining additional insight to support strategic decision making, and building a data strategy to enable calculated initiatives. These initiatives include data collection optimization, customer loyalty efforts, data analytics, data migration, data governance, and data management assessment.
Thomas Brence, director, product marketing, Informatica, points out that pricing models for data quality tools vary based on the customers’ needs and the type of tool chosen. Licensed, on premise traditional data quality solutions can be paid for year after year with maintenance, whereas data verification can be sold as data as a service with tiered, volume-based subscription pricing. “Today, we see businesses moving towards more subscription-based models and Informatica has kept up with that trend. We offer pricing models that fit every kind of budget or model whether you’re looking for subscription-based or licensed on premise data quality tools.
Melissa Data provides the full spectrum of contact data quality, including data profiling, data cleansing, data standardizing, data matching, data enrichments, and continuous monitoring over time to enforce data governance. “We have on premise and cloud services, plus many integrations for popular platforms like Microsoft SQL Server, Pentaho, Talend, Oracle, Excel, Dynamics CRM, Salesforce, and Magento to make data quality easy for the developer, the DBA, and the business user.
Neopost’s Enterprise Digital Solution group includes three companies that provide data quality tools, satori software, Human Inference, and DMTI Spatial.
Satori Software is a postal data solution that supports mailers of all sizes. It also offers a variety of data quality tools to gain confidence in the contact data company’s use every day to build stronger connections and deliver better service to customers.
Satori Bulk Mailer provides end to end mailing preparation in a wizard-based, all in one package.
Satori Ignite is a solution that is a combination of data management technology and Satori’s mail production software, supported by its experience and expertise in processing data in preparation from mailing the solution is aimed at print service providers.
Satori Infuse Web services is a data quality as a services solution that allows organizations to connect with confidence, building and maintain the highest quality contact information available when and where it is needed.
Human Inference provides data quality and management, supporting a range of clients and partners in banking, insurance, healthcare, utilizes and publishing. It helps companies benefit from customer data. This is accomplished with software solutions to optimize the quality of contact data. “As a result, businesses substantially improve interaction between their organization and its customers,” says Christopher M. O’Brien, EVP, communication and shipping solutions, Neopost USA.
SAP wants to help companies run a live business by making data trusted, complete, and relevant for business processes and analytics. “We believe that every organization needs real time access to data that can be trusted and to have the flexibility to prepare for the unique needs of every department and user,” says Philip On, VP marketing for enterprise information management, SAP.
SAP’s data quality tools offer many key features including SAP Agile Data Preparation, SAP HANA Smart Data Integration and SAP HANA Smart Data Quality Data Quality Management microservices, Simple User Interface, SAP Information Steward, and SAP Data Services.
SAS allows customers to span the worlds of data management and analytics with shared metadata and lineage across a common platform. Trusted data is crucial—data quality is pervasive throughout our data management offerings and within many of its analytics solutions. Matthew Magne, global product marketing manager for big data management, SAS, says customers can start with a small departmental footprint to show value and grow as business needs dictate.
Solutions include SAS Data Loader for Hadoop, SAS Data Quality, SAS Data Governance, SAS MDM, and SAS Federation Server.
Talend Data Fabric combines big data, data integration, data quality, cloud integration, master data management, data preparation, and application integration into a single integration platform with a common development and management environment.
Talend’s Data Quality tools enable users to profile, cleanse, mask, and prepare data, while monitoring the quality of data over time—regardless of format or size. Talend Data Quality is integrated into the Talend Data Fabric integration platform, allowing complete reuse of data quality rules across different styles of integration. Rules include machine learning based data de-duplication, validation, standardization, and enrichment. Uniquely, Talend Data Quality natively supports Spark and MapReduce code generation to run data quality tasks on massive data sets directly inside Hadoop.
With Talend, data quality can be deployed on premise or in the clod and on data at rest of in flight, allowing for both a batch and real time use cases to be addressed by a single data job. Recently, the company added self-service capable through Talend Data Preparation. Data Preparation enables anyone to access and cleanse data using browser-based, point and click tools. Business users can share data sets and data preparation recipes turning user defined data preparations into qualified processes. Users can easily export results into desktop tools such as Excel and Tableau to make trusted decisions. Lastly, IT can reuse the rules defined by the business user to embed data preparation into batch, bold, and master data management data integration scenarios.
Data quality software tools are designed to provide accurate and complete data to their organizations. Typical functions include profile, transform, cleanse, identify, match, merge, enrich, and import. Overall, data quality enables businesses to understand, standardize, and monitor data over the course of its lifecycle. SW
Informatica offers its Data Quality, Data as a Service and Data Preparation products for data quality. Data as a service is designed to enable its customers the confidence of accurate, verified contact data. Informatica Data Quality provides projects and initiatives with clean, trusted data to meet its client’s business objectives regarding the size, format, or platform of their data. It’s Data Preparation product is an intelligent data prep application designed to make it easy for users to set up self-service datasets.
Aug2016, Software Magazine