Melissa, a supplier of knowledge high quality options, is making it doable for purchasers to run its SQL Server Integration Providers (SSIS) parts in Azure Knowledge Manufacturing unit by way of the Azure-SSIS Integration Runtime. This brings the facility of Melissa’s knowledge high quality options to the cloud, offering prospects higher flexibility in the place their knowledge is saved.
SSIS is Microsoft’s ETL resolution that permits firms to extract and remodel knowledge from sources like XML knowledge information, flat information, and relational knowledge sources, then load it into totally different knowledge locations, corresponding to SQL Server, Azure SQL Database, Azure Synapse Analytics, or cloud storage.
“Numerous purchasers say ‘hey, we’re nonetheless utilizing SSIS, and we want to do the identical factor, however not on my native machine anymore. Now we wish to do it within the Azure cloud atmosphere,’” mentioned Ben Nguyen, gross sales engineer II and software program engineer II at Melissa.
This led Melissa to create this integration that will permit its SSIS packages to be seamlessly moved to the Azure cloud. “The concept is that these packages have all the time been working for years and years now, and now they’re accessible on Azure Knowledge Manufacturing unit,” he mentioned.
With this integration, all of Melissa’s primary capabilities may be achieved within the cloud utilizing SSIS parts within the Azure Knowledge Manufacturing unit, together with:
- Validating and standardizing contact knowledge, corresponding to names, addresses, cellphone numbers, and emails
- Detecting and merging duplicates
- Analyzing knowledge to find patterns, discover inconsistencies, and uncover alternatives for optimization
- Enriching buyer and enterprise information with further knowledge like property particulars, geolocation, and firmographics
- Retaining tackle information present utilizing USPS and Canada Submit change-of-address knowledge
- Cleansing and reworking messy datasets utilizing customization instruments
Selecting between on-prem vs cloud
Nguyen mentioned that anybody already working with SSIS regionally will be capable of migrate to the cloud simply. “They mainly don’t have to vary something about their initiatives, or very minimal adjustments. They stunning a lot simply migrate all the challenge or bundle that they’ve used earlier than onto Azure Knowledge Manufacturing unit and simply run it there,” he mentioned.
Many customers would profit from this new integration, although there are nonetheless some conditions by which it’d make sense to maintain utilizing SSIS regionally.
For instance, Nguyen defined that a whole lot of Melissa’s bigger established prospects sometimes have all the things 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 that will proceed to profit from native SSIS are these with very delicate knowledge, who’ve a bit extra independence from the web and have a whole lot of parts to their enterprise that they run fully offline.
And eventually, anybody working SSIS regionally will profit from extraordinarily low latency. “A few of Melissa’s SSIS parts work with an area API that reads from knowledge information saved proper in your machine or community. Once you run these regionally, they will course of quicker than storing the identical information on the cloud.” he mentioned.
Anybody else, Nguyen defined, will doubtless profit from shifting to the cloud. That is very true for newer firms, which frequently don’t even have bodily infrastructure; they do all the things 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 a whole lot of prospects who’re already doing issues in an Azure atmosphere, and are already restricted to no matter instruments work with Azure.
