Is it possible to run an SSIS package with FUZZYGROUPING transformation in Azure?

Jose M Naranjo-Espinosa 20 Reputation points
2024-06-13T09:35:48.62+00:00

I am using Fuzzy grouping transformation in SSIS locally "on premises", but I would like to explore the option to run it in Azure (https://learn.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-deploy-run-monitor-tutorial?view=sql-server-ver16), to compare cost / benefit of running it in the cloud, which presumably would be much faster and quicker? Has anyone got any experience about this I mean is it possible? We are currently under Transformation to migrate to Azure but have been told that everything should now be done using Azure Data Factory or Azure Synapse Analytics, but haven't found anything similar to Fuzzy grouping in any of them. Any help would be appreciated

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,673 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,332 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,149 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,522 questions
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 85,351 Reputation points Microsoft Employee
    2024-06-14T11:33:56.63+00:00

    @Jose M Naranjo-Espinosa - Thanks for the question and using MS Q&A platform.

    Yes, it is possible to run an SSIS package with FUZZYGROUPING transformation in Azure. You can provision an Azure-SSIS integration runtime via Azure portal and select enterprise when provisioning SSIS IR. You can refer to the Built-in and preinstalled components on Azure-SSIS Integration Runtime documentation to see what built-in functionalities are supported. However, it is important to note that Azure Data Factory and Azure Synapse Analytics do not have a similar transformation to Fuzzy grouping.

    For more details, refer to Fuzzy Grouping Transformation.

    Hope this helps. Do let us know if you any further queries.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful