How to connect data factory to vendor Oracle database that requires a static IP

Question

How to connect data factory to vendor Oracle database that requires a static IP

Steve B 0

Hi, I would like to use Azure Data Factory to copy over data from an external vendor Oracle database. This vendor requires a whitelisted static IP address to access. From what I can tell, I need to set up a virtual machine in Azure that has a static IP assigned to it, and then install a self-hosted integration runtime to that machine? From there, I can use that SHIR to connect to my linked Oracle service? Is that correct? My question is if those are the correct steps, and how to accomplish those steps. As is obvious, I have very little technical expertise in this space. Thanks for any help!

PRADEEPCHEEKATLA 90,646 Reputation points Moderator

2023-04-17T07:25:40.82+00:00

Steve B - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Steve B 0 Reputation points

2023-04-17T18:58:23.25+00:00

Hi, I apologize for taking so long to respond. The Oracle database is an on-premise server, running version 19.0.
PRADEEPCHEEKATLA 90,646 Reputation points Moderator

2023-04-24T05:33:47.0433333+00:00

Steve B - Thanks for the details, you can use one of the above methods to connect to your oracle database.

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

2 answers

Your answer

PRADEEPCHEEKATLA 90,646 Reputation points Moderator

2023-04-17T07:25:40.82+00:00

Steve B - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Steve B 0 Reputation points

2023-04-17T18:58:23.25+00:00

Hi, I apologize for taking so long to respond. The Oracle database is an on-premise server, running version 19.0.
PRADEEPCHEEKATLA 90,646 Reputation points Moderator

2023-04-24T05:33:47.0433333+00:00

Steve B - Thanks for the details, you can use one of the above methods to connect to your oracle database.

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Steve B - Thanks for the question and using MS Q&A paltform.

Have you tried the steps - you are metioned in the question?

Can you please share more details versions of an Oracle database which you are using?

There are two ways to connect to on-prem Oracle source.

One way is using a self-hosted integration runtime - If your data store is located inside an on-premises network, an Azure virtual network, or Amazon Virtual Private Cloud, you need to configure a self-hosted integration runtime to connect to it.

The second way is you can also use the managed virtual network integration runtime feature in Azure Data Factory to access the on-premises network without installing and configuring a self-hosted integration runtime.

For more details refer to Copy data from and to Oracle by using Azure Data Factory or Azure Synapse Analytics and Connecting Oracle OnPrem from Cloud using Integration Runtime.

Hope this will help. Please let us know if any further queries

Answer 2

Sreeju Nair 12,666

Another option could be to use Azure Private Link for Azure Data Factory. By using Azure Private Link, you can connect to various platform-as-a-service (PaaS) deployments in Azure via a private endpoint. A private endpoint is a private IP address within a specific virtual network and subnet.

Refer: https://learn.microsoft.com/en-us/azure/data-factory/data-factory-private-link

Hope this helps

Steve B 0 Reputation points

2023-04-17T18:56:42.5233333+00:00

Thank you, I will try this!
PRADEEPCHEEKATLA 90,646 Reputation points Moderator

2023-04-27T08:45:41.65+00:00

@Sreeju Nair - Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

How to connect data factory to vendor Oracle database that requires a static IP

2 answers

Your answer