Recently in Data Quality Components for SSIS Category

Record Matching Made Easy with MatchUp Web Service

| No Comments | No TrackBacks

MatchUp®, Melissa's solution to identify and eliminate duplicate records, is now available as a web service for batch processes, fulfilling one of most frequent requests from our customers - accurate database matching without maintaining and linking to libraries, or shelling out to the necessary locally-hosted data files.


Now you can integrate MatchUp into any aspect of your network that can communicate with our secure servers using common protocols like XML, JSON, REST or SOAP.

 

Select a predefined matching strategy, map the table input columns necessary to identify matches to the respective request elements, and submit the records for processing. Duplicate rows can be identified by a combination of NAME, ADDRESS, COMPANY, PHONE and/or EMAIL.

 

Our select list of matching strategies removes the complexity of configuring rules, while still applying our fast and versatile fuzzy matching algorithms and extensive datatype-specific knowledge base, ensuring the tough-to-identify duplicates will be flagged by MatchUp. 


The output response returned by the service can be used to update a database or create a unique marketing list by evaluating each record's result codes, group identifier and group count, and using the record's unique identifier to link back the original database record.

 

Since Melissa's servers do the processing, there are no key files - the temporary sorting files - to manage, freeing up valuable hardware resources on your local server.

 

Customers can access the MatchUp Web Service license by obtaining a valid license from our sales team and selecting the endpoint compatible to your development platform and necessary request structures here.

How to Do It All with Melissa

| No Comments | No TrackBacks

With Melissa, you can do it all - see for yourself with the brand new Solutions Catalog. This catalog showcases products to transform your people data (names, addresses, emails, phone numbers) into accurate, actionable insight. Our products are in the Cloud or available via easy plugins and APIs. We provide solutions to power Know Your Customer initiatives, improve mail deliverability and response, drive sales, clean and match data, and boost ROI.

 

Specific solutions include:

·         Cleaning, matching & enriching data
·         Creating a 360 degree profile of every customer
·         Finding more customers like your best ones with lookalike profiling
·         Integrating data from any source, at any time

Other highlights include: global address autocompletion; mobile phone verification; real-time email address ping; a new customer management platform; as well as info on a wealth of data append and mailing list services.

 

Download the catalog now:

http://www.melissa.com/catalogs/solutions/index.html

 

MatchUp Now Available in the Cloud

| No Comments | No TrackBacks

Did you know that most databases contain 8-10% duplicates? These duplicates get in the way of business intelligence, accurate analytics, and can even result in wasted spend and undeliverable mail costs.

 

The solution? MatchUp®! The new edition of a Cloud web service to the current lineup allows you to dedupe, household, and fuzzy match into any aspect of your network that can communicate with our secure servers using common protocols like XML, JSON, REST or SOAP. Select a predefined matching strategy, map the table input columns necessary to identify matches to the respective request elements, and submit the records for processing. 


MatchUp's matching strategies remove the complexity of configuring rules, while still applying Melissa's fast and versatile fuzzy matching algorithms and extensive datatype-specific knowledge base, ensuring the tough-to-identify duplicates will always be flagged.

 

Use MatchUp Web Service to:

·         Indicate if a record is unique or matches any other records in a submitted record set

·         Create a unique group identifier used to group and query all records that matched each other

·         Count number of records in each matched group

·         Aggregate these output properties to indicate the status of a single record and/or clean and evaluate the status of an entire database


The MatchUp Web Service is a good fit for customers who don't want to install or host local libraries or datafiles, or maintain them. Unlike other Melissa Web services, MatchUp is batch-oriented; there are no incremental deduping or survivorship capabilities available at this time.

MatchUp Web Service joins our current lineup of MatchUp solutions:

·         On-Premise API: Multiplatform, support for the following platforms: Java®, Visual C#®, Windows®, PHP, Oracle®, Linux®, Solaris®, HP UX®.

·         Integrations/Plugins: Dedupe, consolidate and create golden records using MatchUp   in popular programs including Excel®, Pentaho®, SSIS, Salesforce®.

·         Service Bureau: Send us your file for quick batch deduping with fast turnaround.

 

Try it Free:

http://www.melissa.com/contact-data-verification/global-matching.html

Flagship SSIS Developer Suite Now Enables Data Assessment and Continuous Monitoring Over Time; Webinar Adds Detail for SSIS Experts


Rancho Santa Margarita, CALIF - March 17, 2015 - Melissa Data, a leading provider of contact data quality and address management solutions, today announced its new Profiler tool added to the company's flagship developer suite, Data Quality Components for SQL Server Integration Services (SSIS). Profiler completes the data quality circle by enabling users to analyze data records before they enter the data warehouse and continuously monitor level of data quality over time. Developers and database administrators (DBAs) benefit by identifying data quality issues for immediate attention, and by monitoring ongoing conformance to established data governance and business rules.

Register here to attend a Live Product Demo on Wednesday, March 18 from 11:00 am to 11:30 am PDT. This session will explore the ways you can use Profiler to identify problems in your data.

"Profiler is a smart, sharp tool that readily integrates into established business processes to improve overall and ongoing data quality. Users can discover database weaknesses such as duplicates or badly fielded data - and manage these issues before records enter the master data system," said Bud Walker, director of data quality solutions, Melissa Data. "Profiler also enforces established data governance and business rules on incoming records at point-of-entry, essential for systems that support multiple methods of access. Continuous data monitoring means the process comes full circle, and data standardization is maintained even after records are merged into the data warehouse."

Profiler leverages sophisticated parsing technology to identify, extract, and understand data, and offers users three levels of data analysis. General formatting determines if data such as names, emails and postal codes are input as expected; content analysis applies reference data to determine consistency of expected content and field analysis determines the presence of duplicates.

Profiler brings data quality analysis to data contained in individual columns and incorporates every available general profiling count on the market today; sophisticated matching capabilities output both fuzzy and exact match counts. Regular expressions (regexes) and error thresholds can be customized for full-fledged monitoring. In addition to being available as a tool within Melissa Data's Data Quality Components for SSIS, Profiler is also available as an API that can be integrated into custom applications or OEM solutions.

Request a free trial of Data Quality Components for SSIS or the Profiler API.
Call 1-800-MELISSA (635-4772) for more information.

News Release Library


In three easy steps, Melissa Data's product specialist Matthew Bayne demonstrates how Personator for SQL Server Integration Services (SSIS) cleans, verifies, standardizes, and appends missing information such as email addresses and phone numbers - to complete your contact records, help reduce fraud, and improve your marketing efforts.

Watch our video now!



Powerful Features Support Developers with Enriched, De-Duplicated Customer Records; Combats Exponential Increase in Costly Data Decay, Highlighted in Company Magazine


Rancho Santa Margarita, CALIF. - October 29, 2014 - Melissa Data, a leading provider of global contact data quality and data enrichment solutions, today announced significant enhancements to its flagship Data Quality Components for SQL Server Integration Services (SSIS), including the addition of three new services: global email, global phone verification, and U.S. property data enrichment. Data Quality Components for SSIS is a suite of custom data cleansing transformation components for Microsoft SSIS, used to standardize, verify, correct, consolidate and update contact data. With these new features, developers and DBAs are positioned to verify, enrich and retain all the best pieces of global customer data, using a single comprehensive and proven data quality tool.

New to the suite of tools is global email verification, which includes real-time email mailbox verification to eliminate up to 95 percent of invalid emails, so emails get delivered and don't bounce. Global phone numbers from over 230 countries can be verified and appended with geographic information, such as latitude and longitude coordinates, administrative area and predominant language spoken in that region. In addition, global phone features include the ability to return the digits necessary to dial out of your country and into the country of the phone number that was input. For users seeking to enrich U.S. address data, the property feature will provide up-to-date property and mortgage information on more than 140 million properties to improve overall customer intelligence.

"Contact data is always in flux, in fact, half of the customer records held in the average database are invalid or out-of-date in just 45 months - what we call the half-life of data," said Bud Walker, director of data quality solutions, Melissa Data. "Particularly as data becomes more global and increasingly includes email as a critical path of contact, database design must incorporate flexible, scalable tools that rely on a comprehensive approach to managing constant changes in customer data."

Melissa Data's research into the half-life of data, including the operation and long-term costs associated with undeliverable shipments, low customer retention and unsuccessful CRM initiatives, along with other SQL-based data quality challenges are featured in the current issue of Melissa Data Magazine, the company's quarterly resource for DBAs and data quality developers.

Melissa Data Magazine will be available at PASS Summit 2014, Booth #407, starting November 4 in Seattle, Washington. Click here to download the SQL Server edition of Melissa Data Magazine, or call 1-800-MELISSA (635-4772) for more information.

News Release Library


Data Quality Tool Consolidates Duplicates into Single Golden Record of Customer Data; Uniquely Determines Most Accurate Information Based on Objective Data Quality Score


Rancho Santa Margarita, CALIF- April 23, 2014 - Melissa Data, a leading provider of contact data quality and integration solutions, today announced new matching and de-duplication functionality in its MatchUp Component for SQL Server Integration Services (SSIS), uniquely solving the business challenge of duplicate customer data. Based on proprietary logic from Melissa Data, MatchUp determines the best pieces of data to retain versus what to discard - consolidating duplicate records objectively, unlike any other data quality solution. By assessing the quality of individual data fields, MatchUp enables a smart, consistent method for database administrators (DBAs) to determine the best customer contact information in every field.

"The average database contains 8 to 10 percent duplicate records, creating a significant and costly business problem in serving, understanding and communicating with customers effectively. The ideal is a single, accurate view of the customer - known as a golden record - yet this remains one of the biggest challenges in data quality based on methodologies that don't adequately evaluate the content of each data field. As a result, DBAs either overlook duplicates or consistently struggle with determining what information survives in the database and why," said Bud Walker, director of data quality solutions, at Melissa Data. "By using intelligent rules based on the actual quality of the data, DBAs are much better positioned to retain all the best pieces of information from two or more duplicate records into a single, golden record that provides valuable insight into user behavior and helps boost overall sales and marketing performance."

MatchUp works in sharp contrast to matching and de-duplication methods that rely solely on subjective principles, such as whether the record is the most recent, most complete or most frequent. Instead, selection criteria for determining a golden record is based on a relevant data quality score, derived from the validity of customer data such as addresses, phone numbers, emails and names. Once the golden record is identified intelligently, MatchUp further references the data quality score during survivorship processes to support creation of an even better golden record; duplicate entries are then collapsed into a single customer record while retaining any additional information that may also be accurate and applicable.

Utilizing deep domain knowledge of names and addresses, survivorship operations with MatchUp can granularly identify matches between names and nicknames, street/alias addresses, companies, cities, states, postal codes, phones, emails, and other contact data components.

Melissa Data will be demonstrating its MatchUp Component for SSIS at booth #46 during Enterprise Data World, April 27-May 1, 2014 at The Renaissance Hotel in Austin, TX. To download a free trial of Melissa Data's MatchUp Component for SSIS, click here or call 1-800-MELISSA (635-4772).

News Release Library


Fundamentals of SQL Server Contact Data Cleansing

| No Comments | No TrackBacks
By Joseph Vertido

New Webinar!
The roadblocks involved in implementing a solid routine for normalizing data can be extensive and can prove to be time consuming, especially when dealing with specific types of domains. In this new webcast, our data quality analyst Joseph Vertido, will help
you understand the major roadblocks in normalizing contact data (address, name, phone and email) and experience a new approach from Melissa Data, using plugins for Microsoft SQL Server Integration Services 2012 to effectively normalize contact data, all at no cost.

Sept 19 at 3 pm EST. Register Now

https://www2.gotomeeting.com/register/610451850

Melissa Data will demonstrate new "Golden Record" functionality in its MatchUp Component for SQL Server Integration Services (SSIS) at Enterprise Data World (EDW). MatchUp SSIS is a powerful tool for advanced matching and deduplication management. By integrating the Golden Record selection tool, MatchUp SSIS represents an industry breakthrough based on its ability to discern contact data information, and select the surviving record based on the level of quality of the information provided.

Melissa Data will also showcase its popular collection of contact data quality and integration solutions. The event will be held April 28 through May 2 in San Diego, Calif. at the Sheraton Hotel and Marina.

Come stop by Booth #412 and say hi!

CLICK HERE FOR MORE INFO

Check out this video featuring a step-by-step/start-to-finish approach to cleanse and enrich address data using the new SQL Server 2012 Data Quality Services (DQS), and Melissa Data's Datamarket Address Check service. From the video, you will learn how to create a comprehensive Data Quality project that leverages Melissa Data's deep experience in address verification to cleanse, verify and standardize postal address information in SQL tables and Excel spreadsheets.

Click Here to watch video.

Categories