Webinar Recap: "Elevate Your ETL: Seamlessly Integrate Melissa’s SSIS Data Quality Tools with Azure Data Factory"

Melissa recently partnered with MSSQLTips to host a webinar, “Elevate Your ETL: Seamlessly Integrate Melissa’s SSIS Data Quality Tools with Azure Data Factory.” Below is a recap of how to deploy Melissa’s SSIS data quality components on Azure Data Factory. If you’d like to dive deeper, you can watch the full webinar here!

Melissa’s SSIS data quality components are now fully compatible with Azure Data Factory, allowing you to validate, cleanse and enrich data in SSIS packages running on Azure SSIS Integration Runtime (SSIS IR). This is ideal for organizations looking to modernize data quality and ETL workflows in the cloud. Our team can help you move on-premises SSIS packages to Azure while tuning data pipelines for scalability and performance. Whether you are migrating existing packages or building new ones, Melissa streamlines the process with minimal refactoring—you'll get the same robust data cleansing and enrichment capabilities in your cloud pipelines without rebuilding your ETL from scratch. With Melissa’s Azure Data Factory compatibility, enterprises can accelerate cloud migration and deliver trusted, high-quality data across the organization. Below are some of Melissa’s most widely used data quality and enrichment components for Azure Data Factory:

• Contact Verify: Verifies, corrects and standardizes U.S. and Canada postal addresses, email addresses and phone numbers, and converts U.S. addresses to rooftop latitude/longitude coordinates.
• Global Verify: Verifies, corrects and standardizes postal addresses, email addresses and phone numbers for 240+ countries. Plus, convert street addresses to precise latitude/longitude coordinates.
• MatchUp: Provides advanced deduping/matching capabilities to eliminate duplicates and create a single customer record.
• SmartMover: Matches your address records against the USPS NCOA^Link database or Canada Post NCOA database and returns the current address of customers that have moved. 

In the webinar, Ben, our Sales Engineer, walks through how to deploy existing SSIS packages to Azure, configure them in Azure Data Factory (ADF) pipelines, and run them seamlessly in the cloud using Melissa’s trusted contact data validation and deduplication tools. He also highlights that these solutions are backed by decades of data quality expertise and curated reference datasets—not just basic fuzzy matching. And in his step-by-step demo, you'll learn how to publish an SSIS package from Visual Studio to Azure SQL Server, and then how to orchestrate and execute it within Azure Data Factory. You'll also see the types of outputs and match results you can expect from each component. Watch the full webinar to see real-world examples of how popular components like Contact Verify, MatchUp and SmartMover perform in a modern Azure-based ETL workflow.

Want more information about Melissa and our products? Reach out to us at www.melissa.com or call 1-800-MELISSA. Don’t forget to subscribe to our blog for everything related to data quality!