Migrating jobs on Sql agent to azure data factory

Question

Hello the community,
The goal is to migrate a project that runs in production through SQL AGENT sequences and power shell scripts. The Purpose is to recover elements and save them in blob storage. I have access to the power shell file locally in my computer, which I am looking to have run these files in azure data factory. Any suggestions please ?

Answer 1

Hey,
In case if you need to execute powershell scripts in Azure, you can use the below components:

1. Azure automation : wherein you can schedule your powershell run book similar to SQL jobs
2. In case if you need to execute the powershell scripts via Azure data factory, there is no direct way.
   You would need to create an Azure function for Powershell wherein you would host your scripts and trigger the Azure function via https trigger through Azure data factory

Answer 2

Hey,
Thanks for you answer.
Do you have documentation for your second proposition ? This will help me a lot!

Answer 3

@Nandan Hegde hey Nadan , I have tried to execute my script powershell with both methods. In fact, there is an issue while authentication via runbook to powerful BI. The same when I have tried to work with functions. I created a service principal and tried the active directory approach to make it work but unfortunately it failed. The reason why is the incompatibility issue between ADAL and powerful core as you can see in this post <<https://github.com/PowerShell/PowerShell/issues/10473>>