Run Powershell script in Azure Automation or ADF Custom Activity?

Question

What could be the best way to automatize the following process in Azure:

Run PowerShell script
Store the output (.csv or .tsv) directly in ADLS (or in a StorageAccount and copy them to ADLS)
Move data from ADLS to one Azure SQL DB

For points 2 and 3 think that the best way is to implement them in ADF with copy activity and some U-SQL scripts.

For point 1 I don’t have a clear idea how to implement it. I’m considering a Custom Activity in ADF or implement it on Azure Automation. Which method is more appropriate for this purpose?

You could get the code within the powershell script to open a connection to SQL Server (and probably ADLS) write the results directly there. In other words do 1 and 2 (and maybe even 3) all inside the powershell script. — Nick.Mc
– Nick.Mc, Commented Mar 21, 2019 at 12:39
Hi @Nick.McDermaid this was another option that I consired. ¿Any idea of what could be the better option to run the powershell script (ADF Custom Activity, Azure Automation or Azure Function)? — Ed_Ru
– Ed_Ru, Commented Mar 21, 2019 at 14:04

Joy Wang · Accepted Answer · 2019-03-22 01:40:38Z

0

Agree with the comment, you could use Azure Automation runbook to run the powershell script. There are two runbook types to run the powershell, for the advantages and limitations, see PowerShell runbooks and PowerShell Workflow runbooks.

For more details to use them, see My first PowerShell runbook and My first PowerShell Workflow runbook.

answered Mar 22, 2019 at 1:40

Joy Wang

42.4k3 gold badges38 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Run Powershell script in Azure Automation or ADF Custom Activity?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related