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

Jose M Naranjo-Espinosa 20

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

Jose M Naranjo-Espinosa 20 Reputation points

2024-06-13T09:54:24.8133333+00:00

yes. But you need to select enterprise when provisioning SSIS IR Create an Azure-SSIS integration runtime via Azure portal - Azure Data Factory | Microsoft Learn. You can refer to Built-in and preinstalled components on Azure-SSIS Integration Runtime - Azure Data Factory | Micros... what built-in functionalities are supported.
PRADEEPCHEEKATLA-MSFT 82,671 Reputation points Microsoft Employee

2024-06-18T05:54:28.97+00:00

@Jose M Naranjo-Espinosa - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Jose M Naranjo-Espinosa 20 Reputation points

2024-06-18T07:59:54.3433333+00:00

Hi @PRADEEPCHEEKATLA-MSFT I am new in this forum and is not very intuitive, I don't know how to mark your comment as an answer(?) I will add it as my own because that is the only option I can see on my end but credit is yours. As for resolution or implementation I have provided the information to the cloud team at my org but I am not sure if it will get provisioned or an alternative solution with an external provider will be sought...
Jose M Naranjo-Espinosa 20 Reputation points

2024-06-18T08:00:37.85+00:00

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.
PRADEEPCHEEKATLA-MSFT 82,671 Reputation points Microsoft Employee

2024-06-19T04:09:45.64+00:00

@Jose M Naranjo-Espinosa - I had converted my comment to answer and now you can accept as an answer. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Accepted answer

PRADEEPCHEEKATLA-MSFT 82,671 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.
Please sign in to rate this answer.

1 person found this answer helpful.
Jose M Naranjo-Espinosa 20 Reputation points

2024-06-19T08:32:47.47+00:00

Done, cheers

PRADEEPCHEEKATLA-MSFT 82,671 Reputation points Microsoft Employee

2024-06-19T08:42:55.0333333+00:00

@Jose M Naranjo-Espinosa - Glad to know it helped. Please do continue to use MS Q&A platform for any questions related to Azure!
Sign in to comment

Share via

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

0 additional answers