Skip to content

Instantly share code, notes, and snippets.

@nmvinoth
Created February 21, 2023 17:09
connect-AzAccount
$client = "<client>"
$environment = "<environment>"
$tenantid = '<tenant-id>'
$subscriptionid = <subscription-id>
Select-AzSubscription $subscriptionid
$ssisdfrg = 'sqltechnet'-df-rg'
$ssisdf = 'sqltechnet'-mvnet-df'
$ssisstgacctname = 'ssisstgacct'
$dfobj = @()
$dfobj = Get-AzDataFactoryV2 -ResourceGroupName $ssisdfrg |Where{$_.DataFactoryName -eq $ssisdf}|SELECT *
if(!$dfobj)
{
$corergobj = Get-AzResourceGroup -Name $ssisdfrg
$dfarmparameter = Get-Content -Path \\sqltechnet.file.core.windows.net\CloudAutomation\parameters.json
$dfarmparameter = $dfarmparameter.Replace('<insert-subscription-id>',$subscriptionid)
$dfarmparameter = $dfarmparameter.Replace('<insert-rg-id>',$ssisdfrg)
$dfarmparameter = $dfarmparameter.Replace('<insert-df-id>',$ssisdf)
$dfarmparameter = $dfarmparameter.Replace('<insert-location-id>',$corergobj.Location)
$envparameterfile = '\\sqltechnet.file.core.windows.net\CloudAutomation\sqltechnet'+'_'+'DF_parameters.json'
$envtemplatefilefile = '\\sqltechnet.file.core.windows.net\CloudAutomation\template.json'
Set-Content -Path $envparameterfile -Value $dfarmparameter -Force
New-AzResourceGroupDeployment -ResourceGroupName $ssisdfrg -TemplateParameterFile $envparameterfile -TemplateFile $envtemplatefilefile
}
else
{Write-Host "DataFactory " $ssisdf "on Resourcegroup "$ssisdfrg "Already exists" }
Remove-Variable * -ErrorAction SilentlyContinue;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment