Melissa, a supplier of information high quality options, is making it potential for purchasers to run its SQL Server Integration Providers (SSIS) parts in Azure Knowledge Manufacturing facility via the Azure-SSIS Integration Runtime. This brings the facility of Melissa’s information high quality options to the cloud, offering prospects higher flexibility in the place their information is saved.
SSIS is Microsoft’s ETL resolution that permits firms to extract and rework information from sources like XML information recordsdata, flat recordsdata, and relational information sources, then load it into totally different information locations, similar to SQL Server, Azure SQL Database, Azure Synapse Analytics, or cloud storage.
“A number of shoppers say ‘hey, we’re nonetheless utilizing SSIS, and we wish to do the identical factor, however not on my native machine anymore. Now we wish to do it within the Azure cloud surroundings,’” mentioned Ben Nguyen, gross sales engineer II and software program engineer II at Melissa.
This led Melissa to create this integration that might enable its SSIS packages to be seamlessly moved to the Azure cloud. “The thought is that these packages have at all times been working for years and years now, and now they’re accessible on Azure Knowledge Manufacturing facility,” he mentioned.
With this integration, all of Melissa’s predominant capabilities will be completed within the cloud utilizing SSIS parts within the Azure Knowledge Manufacturing facility, together with:
- Validating and standardizing contact information, similar to names, addresses, telephone numbers, and emails
- Detecting and merging duplicates
- Analyzing information to find patterns, discover inconsistencies, and uncover alternatives for optimization
- Enriching buyer and enterprise information with extra information like property particulars, geolocation, and firmographics
- Protecting deal with information present utilizing USPS and Canada Submit change-of-address information
- Cleansing and remodeling messy datasets utilizing customization instruments
Selecting between on-prem vs cloud
Nguyen mentioned that anybody already working with SSIS domestically will have the ability to migrate to the cloud simply. “They principally don’t have to alter something about their initiatives, or very minimal modifications. They stunning a lot simply migrate your complete challenge or bundle that they’ve used earlier than onto Azure Knowledge Manufacturing facility and simply run it there,” he mentioned.
Many customers would profit from this new integration, although there are nonetheless some conditions by which it would make sense to maintain utilizing SSIS domestically.
For instance, Nguyen defined that lots of Melissa’s bigger established prospects usually have the whole lot on-prem, from the SQL Server to bodily machines to bodily infrastructure. For these prospects, it could make sense to proceed utilizing native SSIS.
One other kind of buyer which will proceed to profit from native SSIS are these with very delicate information, who’ve a bit extra independence from the web and have lots of parts to their enterprise that they run fully offline.
And eventually, anybody operating SSIS domestically will profit from extraordinarily low latency. “A few of Melissa’s SSIS parts work with a neighborhood API that reads from information recordsdata saved proper in your machine or community. If you run these domestically, they will course of sooner than storing the identical recordsdata on the cloud.” he mentioned.
Anybody else, Nguyen defined, will seemingly profit from shifting to the cloud. That is very true for newer firms, which frequently don’t even have bodily infrastructure; they do the whole lot in cloud-based environments.
Doing issues within the cloud permits for higher scalability, particularly for firms that undergo peaks and valleys of want.
Moreover, Melissa has lots of prospects who’re already doing issues in an Azure surroundings, and are already restricted to no matter instruments work with Azure.
