Unable to choose an Azure-based integration runtime when creating a pipeline activity in Azure Data

Question

Unable to choose an Azure-based integration runtime when creating a pipeline activity in Azure Data

Das Gupta, Abhijeet 105

I have created a self hosted and an azure based IR but when setting up or editing a pipeline activity, the azure based IR option is shown to be unavailable.

When creating pipeline activity, the azure based IR is greyed out like so in the screenshot

azure-cloud-IR-unavailable

I want to switch to cloud based IR over self hosted IR in order to run scheduled pipelines even when my self hosted IR is not running.

Why am I not able to choose cloud based IR for a pipeline activity? Does this mean I do not have permissions to setup a cloud based IR? If yes, what role is specifically needed for it?

Konstantinos Passadis 19,691 MVP

Hello @Das Gupta, Abhijeet !

Can you validate you have the required permissions ?

Subscription-level permissions:

    "Contributor" or "Owner" role assigned to your Azure subscription.

    Access to create and manage resources within the subscription.

Data Factory-level permissions:

    "Contributor" or "Owner" role assigned to the Data Factory resource.

    Access to create and manage Data Factory resources, including Integration Runtimes.

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards

Das Gupta, Abhijeet 105 Reputation points

2023-06-21T12:08:49.72+00:00

Yes I have a contributor role level permissions in both of them
Konstantinos Passadis 19,691 Reputation points MVP

2023-06-21T13:38:50.12+00:00

Hello @Das Gupta, Abhijeet !

Can you verify a couple of things ?

Is Managed IDentity Enabled on the Azure Resource of DF ?

Is it protected with Private Endpoint ?

Is there already a Managed VNET ?

Also have toy tried the Powershell ? Is it failing also ?

https://learn.microsoft.com/en-us/azure/data-factory/create-azure-integration-runtime?tabs=data-factory

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards
Das Gupta, Abhijeet 105 Reputation points

2023-07-26T07:15:55.4666667+00:00

Since copy tool activity for a web table uses a Web Table Connector, therefore only self-hosted IRs can be used source
PRADEEPCHEEKATLA 91,846 Reputation points

2023-08-10T04:07:35.39+00:00

@Das Gupta, Abhijeet - We received your feedback that the answer provided on the thread was not helpful.

Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback.

Our engineer had provided a detailed answer which has clear steps for which you are looking for. If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.

Looking forward to you reply. Much appreciate your feedback!

Regards,

PRADEEPCHEEKATLA-MSFT

1 answer

Your answer

Konstantinos Passadis 19,691 Reputation points MVP

2023-06-21T10:20:36.1966667+00:00

Hello @Das Gupta, Abhijeet !

Can you validate you have the required permissions ?

Subscription-level permissions: "Contributor" or "Owner" role assigned to your Azure subscription. Access to create and manage resources within the subscription. Data Factory-level permissions: "Contributor" or "Owner" role assigned to the Data Factory resource. Access to create and manage Data Factory resources, including Integration Runtimes.

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards
Das Gupta, Abhijeet 105 Reputation points

2023-06-21T12:08:49.72+00:00

Yes I have a contributor role level permissions in both of them
Konstantinos Passadis 19,691 Reputation points MVP

2023-06-21T13:38:50.12+00:00

Hello @Das Gupta, Abhijeet !

Can you verify a couple of things ?

Is Managed IDentity Enabled on the Azure Resource of DF ?

Is it protected with Private Endpoint ?

Is there already a Managed VNET ?

Also have toy tried the Powershell ? Is it failing also ?

https://learn.microsoft.com/en-us/azure/data-factory/create-azure-integration-runtime?tabs=data-factory

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards
Das Gupta, Abhijeet 105 Reputation points

2023-07-26T07:15:55.4666667+00:00

Since copy tool activity for a web table uses a Web Table Connector, therefore only self-hosted IRs can be used source
PRADEEPCHEEKATLA 91,846 Reputation points

2023-08-10T04:07:35.39+00:00

@Das Gupta, Abhijeet - We received your feedback that the answer provided on the thread was not helpful.

Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback.

Our engineer had provided a detailed answer which has clear steps for which you are looking for. If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.

Looking forward to you reply. Much appreciate your feedback!

Regards,

PRADEEPCHEEKATLA-MSFT

Answer 1

QuantumCache 20,681 Moderator

Hello @Das Gupta, Abhijeet Welcome to Q&A forum,

Yes, you are right! Thanks for bringing this to our attention.

To use this Web table connector, you need to set up a Self-hosted Integration Runtime.

Here are the Prerequisites.

Could you please visit the IDEAS portal and upvote the feature request?

I will make sure to send this feedback to the Product Team via internal channels.

User's image

If the response is helpful, please click "Accept Answer" and Click 'Yes'. So that we can close this thread.

Share via

Unable to choose an Azure-based integration runtime when creating a pipeline activity in Azure Data

1 answer

Your answer