The Powershell Core and Windows Powershell task types allow you to execute Powershell scripts as part of a Data Governor job. Whilst they are separate task types, both Core and Windows variants use the same form for creating and modifying the task.
The difference between Powershell Core and Windows Powershell ultimately comes down to:
If you are migrating a Powershell Task over from Data Governor V5 and older, it’s recommended you use the Windows Powershell task type.
|Scenario||Core vs. Windows|
|I need to utilise database tooling such as SSAS.||Windows|
|I need to work with Windows administration tools such as Active Directory.||Windows|
|I need to run basic operations such as calling a REST API webhook and working with the file system||Core|
|I need to use Powershell on Linux||Core|
|This is my first time integrating Powershell into a Data Governor job.||Core|
The Powershell editor provided in Data Governor includes syntax highlighting and will include various autocompletion options in future updates.
The Powershell provided in the editor will be executed as is by Data Governor so ensure that it is error free before creating a task with it.
Both Powershell tasks support parameters and will convert them to variables that get injected into the Powershell script.
Parameter Name | Parameter Value | Script | Output
PersonName | Alex |
Write-Output "Hello $PersonName" | Hello Alex
Parameter values need to be set when the task is added to a job’s sequence. Learn more about parameters in the jobs documentation.