Recently in 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.

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

Global Address Integration for SSIS

| No Comments | No TrackBacks
blog-global-ssis.png


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


Categories