Azure data factory create integration runtime thru CLI

Question

Azure data factory create integration runtime thru CLI

Pankaj Joshi 391

I want to create new azure integration runtime with property virtual network "enabled" in Azure Data Factory. Due to policy restriction it's not allowing to create new through portal. So I have to create through devops pipeline. I need complete Azure CLI commands with example to achieve that. I copied azure cli command from Microsoft site but it does not seem to working. Also I could not able to find any example. Please help.

Pankaj Joshi 391 Reputation points

2023-02-11T16:23:01.77+00:00

We have already created Data factory "demo-d-datafactory" and it has created a default azure integration runtime host. Now in existing data factory "demo-d-datafactory" I want to add new azure integration runtime with "Enable managed virtual network" as attached screenshotIMG_20230211_214528.jpg so what is the cli command I can use to update datafactory with new azure integration runtime and Enable managed virtual network in new integration runtime as per screenshot? Please advise
Pankaj Joshi 391 Reputation points

2023-02-13T08:08:06.81+00:00
I tried with "az datafactory integation-runtume managed create" but not

successful, I don't know how to pass all these properties in attached json screenshot IMG_20230213_133627.jpg because of which it is failing
Arun Siripuram 911 Reputation points

2023-02-16T00:09:33.1433333+00:00
@pankaj joshi

Thank you for reaching Microsoft Q&A

To create a new Azure Integration Runtime (IR) in Azure Data Factory with the virtual network enabled, you can use the Azure CLI command az datafactory create. Here is an example of how you can use this command:

az datafactory create --name <data_factory_name> --resource-group <resource_group_name> --location <location> --virtual-network-type enabled --subnet-id <subnet_id>

Where:

<data_factory_name>: Name of the Azure Data Factory.

<resource_group_name>: Name of the resource group where the Data Factory will be created.

<location>: Azure region where the Data Factory will be created.

<subnet_id>: ID of the subnet where the IR will be created. The subnet must belong to a virtual network in the same subscription as the Data Factory.

Here's an example of creating a new Azure Data Factory with the virtual network enabled:

az datafactory create --name myDataFactory --resource-group myResourceGroup --location eastus --virtual-network-type enabled --subnet-id /subscriptions/<subscription_id>/resourceGroups/<resource_group_name>/providers/Microsoft.Network/virtualNetworks/<virtual_network_name>/subnets/<subnet_name>

Please let us know whether this works. Will be happy to assist.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-02-16T00:16:06.0166667+00:00

Hello @Pankaj Joshi,

Are you seeing any errors when creating the integration run time via the CLI?

Can you please provide more details here?
Pankaj Joshi 391 Reputation points

2023-02-16T08:24:23.1433333+00:00

Yes attached screenshot contain cli command I am running and error recieved. IMG_20230216_135312.jpg
Pankaj Joshi 391 Reputation points

2023-02-17T07:05:52.5333333+00:00

I think It is disallowed because I am not giving reference of Vnet in Cli command. I need to know how to do that or how to pass json object as a input to Cli command. Thanks
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-02-17T23:32:35.75+00:00

Hello @Pankaj Joshi,

Thanks for the reply. Do you see the same error message when creating the new azure IR via the portal?

Sorry, I am trying to correlate whether the issue is with CLI or from the Azure portal or is it the same from CLI and portal.
Pankaj Joshi 391 Reputation points

2023-02-22T16:10:45.4933333+00:00

Yes error message is same due to policy set up as it is mandatory to pass subnetId. I can pass it through ARM in this case
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-02-22T16:27:39.26+00:00

I got it. Thank you for the update, @Pankaj Joshi

Accepted answer

0 additional answers

Your answer

Pankaj Joshi 391 Reputation points

2023-02-11T16:23:01.77+00:00

We have already created Data factory "demo-d-datafactory" and it has created a default azure integration runtime host. Now in existing data factory "demo-d-datafactory" I want to add new azure integration runtime with "Enable managed virtual network" as attached screenshotIMG_20230211_214528.jpg so what is the cli command I can use to update datafactory with new azure integration runtime and Enable managed virtual network in new integration runtime as per screenshot? Please advise
Pankaj Joshi 391 Reputation points

2023-02-13T08:08:06.81+00:00

I tried with "az datafactory integation-runtume managed create" but not

successful, I don't know how to pass all these properties in attached json screenshot IMG_20230213_133627.jpg because of which it is failing
Arun Siripuram 911 Reputation points

2023-02-16T00:09:33.1433333+00:00

@pankaj joshi

Thank you for reaching Microsoft Q&A

To create a new Azure Integration Runtime (IR) in Azure Data Factory with the virtual network enabled, you can use the Azure CLI command az datafactory create. Here is an example of how you can use this command:

az datafactory create --name <data_factory_name> --resource-group <resource_group_name> --location <location> --virtual-network-type enabled --subnet-id <subnet_id>

Where:

<data_factory_name>: Name of the Azure Data Factory.

<resource_group_name>: Name of the resource group where the Data Factory will be created.

<location>: Azure region where the Data Factory will be created.

<subnet_id>: ID of the subnet where the IR will be created. The subnet must belong to a virtual network in the same subscription as the Data Factory.

Here's an example of creating a new Azure Data Factory with the virtual network enabled:

az datafactory create --name myDataFactory --resource-group myResourceGroup --location eastus --virtual-network-type enabled --subnet-id /subscriptions/<subscription_id>/resourceGroups/<resource_group_name>/providers/Microsoft.Network/virtualNetworks/<virtual_network_name>/subnets/<subnet_name>

Please let us know whether this works. Will be happy to assist.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-02-16T00:16:06.0166667+00:00

Hello @Pankaj Joshi,

Are you seeing any errors when creating the integration run time via the CLI?

Can you please provide more details here?
Pankaj Joshi 391 Reputation points

2023-02-16T08:24:23.1433333+00:00

Yes attached screenshot contain cli command I am running and error recieved. IMG_20230216_135312.jpg
Pankaj Joshi 391 Reputation points

2023-02-17T07:05:52.5333333+00:00

I think It is disallowed because I am not giving reference of Vnet in Cli command. I need to know how to do that or how to pass json object as a input to Cli command. Thanks
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-02-17T23:32:35.75+00:00

Hello @Pankaj Joshi,

Thanks for the reply. Do you see the same error message when creating the new azure IR via the portal?

Sorry, I am trying to correlate whether the issue is with CLI or from the Azure portal or is it the same from CLI and portal.
Pankaj Joshi 391 Reputation points

2023-02-22T16:10:45.4933333+00:00

Yes error message is same due to policy set up as it is mandatory to pass subnetId. I can pass it through ARM in this case
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-02-22T16:27:39.26+00:00

I got it. Thank you for the update, @Pankaj Joshi

Answer 1

Hello @Pankaj Joshi,

Your error message says, "resource 'azuresqlirsecure' was disallowed by policy. " and you have mentioned, "Due to policy restriction, it's not allowing to create new through portal."

The behavior will be the same either using CLI, PowerShell, or via the Azure portal.

We would see this error if there is a policy in your subscription that disallows you to create such resources. To be able to proceed further, you might have to disable the policy that was causing the issue with your deployment.

Reference document: https://learn.microsoft.com/en-us/azure/azure-resource-manager/troubleshooting/error-policy-requestdisallowedbypolicy?tabs=azure-cli

I hope this clarifies.

Please let me know if you have any further questions.

Share via

Azure data factory create integration runtime thru CLI

0 additional answers

Your answer