Datafactory SSIS IR: need an public IP to gain access AWS DRS (Database)

Normando 1 Reputation point
2021-12-14T09:25:22.743+00:00

Hello;

I have a Datafactory with an SSIS IR.
I have to access a DB service on AWS and for security I need to indicate the IPs from where the requests will come.
Access is from the IR, when executing an SSIS package not from a Datafactory pipeline.

When the IR stops and restarts the IP changes, it seems because of the load balancer.
Is it possible to assign a public IP so that the IR always access with the same IP?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,655 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,491 Reputation points Microsoft Employee Moderator
    2021-12-15T19:35:15.99+00:00

    Hello @Normando ,
    Thanks for the ask and using Microsoft Q&A platform .
    You set a static IP for the SSIS IR , please read about the same here .
    https://learn.microsoft.com/en-us/azure/data-factory/join-azure-ssis-integration-runtime-virtual-network#access-to-other-cloud-data-stores

    158015-image.png

    Please do let me know how it goes .
    Thanks
    Himanshu

    -------------------------------------------------------------------------------------------------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.