CODEWITHSUNDEEP
azurepowershellazure-data-factoryazure-automation
Ed_Ru
Ed_Ru

Reputation: 134

Run Powershell script in Azure Automation or ADF Custom Activity?

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

  1. Run PowerShell script
  2. Store the output (.csv or .tsv) directly in ADLS (or in a StorageAccount and copy them to ADLS)
  3. 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?

Upvotes: 0

Views: 632

Answers (1)

Joy Wang
Joy Wang

Reputation: 42153

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.

Upvotes: 0

Related Questions