Melissa Demonstrates Sustainable Analytics Techniques Using Data Quality for SQL Server at PASS Summit

SuperSU | 2019, Data Quality Components for SSIS, Pass Summit, Press Release, SQL Server Integration Services, SSIS

Real-Time Tools Eliminate Bad Data Costs of 10-25%

Rancho Santa Margarita, CALIF – October 30, 2019 – Melissa, a leading provider of global address, name, email, phone, and identity verification solutions, today announced its will demonstrate its Data Quality Components for SQL Server® at PASS Summit, supporting data professionals who use the Microsoft data platform. Melissa’s toolset enables a sustainable analytics strategy, preventing the GIGO (Garbage In, Garbage Out) that gets in the way of meaningful analytics. Data professionals are empowered to prevent business revenue losses of 10-25% by avoiding common but costly errors fueled by bad data.

“Bad data is the culprit for enterprise problems that are diverse yet consistent in their ability to disrupt business operations. Without accurate data, businesses cannot locate new customers and lack understanding of customer needs, ultimately minimizing the value of each customer,” said Bud Walker, vice president, enterprise sales and strategy, Melissa. “Reliable and ongoing data quality controls are key, seamlessly driving effective communications and predictive analytics.”

Melissa’s Data Quality Components for Microsoft® SQL Server is a unique set of global data quality tools that empower DBAs and developers to collect data from any source, and clean and enrich data during migration and integration. By preventing incorrect, incomplete, duplicate, or outdated data from entering enterprise systems, organizations can gain immediate insight for actionable intelligence.

Melissa tools integrate closely with both the community and enterprise editions of SQL Server® Integration Services (SSIS) as well as the range of Microsoft technologies, including restful APIs and components for .NET™, Dynamics CRM, and Excel®. The company will be demonstrating these Microsoft compatible data quality tools and strategies at PASS Summit at the Washington State Convention Center in Seattle, November 6-9, 2019.

Click here to access a free trial and developer resources, and a free pair of elephant socks with your demo account. To learn more, visit Melissa at PASS Summit; click here if you prefer to set a briefing appointment. To connect with members of Melissa’s global intelligence team outside of this event, visit https://www.melissa.com/ or call 1-800-MELISSA.

About Melissa
Since 1985, Melissa has specialized in global intelligence solutions to help organizations unlock accurate data for a more compelling customer view. More than 10,000 clients worldwide in arenas such as retail, education, healthcare, insurance, finance, and government, rely on Melissa for full spectrum data quality and ID verification software, including data matching, validation, and enhancement services to gain critical insight and drive meaningful customer relationships. For more information or free product trials, visit https://www.melissa.com or call 1-800-MELISSA (635-4772).

Media contacts

Greg Brown
Vice President, Global Marketing, Melissa
greg.brown@Melissa.com
+1-800-635-4772 x1130

Jacqueline Zerbst, MPowered PR for Melissa
pr@mpoweredpr.com
+1-877-794-6777

Record Matching Made Easy with MatchUp Web Service

Blog Administrator | Data Governance, Data Integration, Data Management, Data Matching, Data Quality, Data Quality Components for SSIS, Data Steward, Data Warehouse, Duplicate Elimination, Fuzzy Matching, Golden Record, Householding, Identity Resolution, Record Linkage, SQL Server Integration Services, SSIS, Survivorship | , , , , , , ,

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.

MatchUp Now Available in the Cloud

Blog Administrator | Data Management, Data Matching, Data Quality, Data Quality Components for SSIS, Duplicate Elimination, SSIS | , , , , ,

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:

https://www.melissa.com/data-deduplication

Global Address Integration for SSIS

Blog Administrator | Data Integration, Data Quality, SSIS | , , , ,

Is your business growing internationally? It’s inevitable that you will encounter data quality problems complicated by the shipping needs of clients outside the United States. The data quality of address information, here, is key to that success. Remove duplicates, save on postal, shipping and product
costs, and find the ability to perform effective business intelligence. Melissa Data’s Global Verify Component for use in Microsoft SQL Server
Integration Services can help you reach global address data quality. 

Address data differs worldwide, which means that you can’t
force international addresses into U.S. address formats. One way to approach
this would be to customize the way your input forms are laid out while making
the input easy for the user. This can increase the effectiveness of
the data you collect.

When you install Global Verify Component into your SSIS
server, you will be able to apply data quality to international addresses. From
there, you will map the input in the component based on the fields you
have.

When it comes to output, there are
three types of outputs designs. After selecting one, you input the column name.
You also have the option to customize the output. One of the most important
options provided is the Output Script. That is where you can specify what
language/character set you want the output to be. Then you have the
Pass-through columns. These simply allow you to pass through from your input
source any data you want to keep unchanged.

Melissa Data alerts you with
results codes; which alert you to the status and errors of each record. There are also output filters. These allow output flow into different
streams based on a number of customizable conditions. With these outputs, you
can direct different types of verification to different destinations and handle
them accordingly.

Melissa Data’s Global Verify Component makes cleaning and
validating your international addresses in SSIS simple and effective. Read our whitepaper: Global Address Data Integration in SSIS or download a free trial of Global Verify Component.

By Natalia Crawford