Skip to content

Instantly share code, notes, and snippets.

@nmvinoth

nmvinoth/CreateDFwithManagedVNET.ps1 Secret

Created February 21, 2023 17:09
Download ZIP

Revisions

  1. nmvinoth created this gist Feb 21, 2023.
    35 changes: 35 additions & 0 deletions CreateDFwithManagedVNET.ps1
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,35 @@
    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;