Using a Data Factory Managed VNet to read data from an Oracle on-premise source

Question

Using a Data Factory Managed VNet to read data from an Oracle on-premise source

pmscorca 1,052

Hi,

I need to design an Azure data platform solution that has a Data Factory Managed VNet in order to get data from an Oracle on-premise source.

I've read this article How to access on-premises SQL Server from Data Factory Managed VNet using Private Endpoint and I've some questions about this subject:

is it mandatory to create a private link service for the Azure Virtual Network?
is it possible to use an Azure Key Vault service to save the Oracle credentials without any problems?

Has anyone some experiences with a such scenario to give me any suggests, please? Thanks

1 answer

Your answer

Answer 1

phemanth 15,755 Microsoft External Staff Moderator

@pmscorca

Thanks For Reaching out MS Q&A

To answer your questions:

1.It's based on your requirements; creating a private link service for the Azure Virtual Network is not mandatory. However, utilizing a private link service offers a more secure method to access resources through a private endpoint.

If you opt not to use a private link service, traffic will pass through the public network, potentially compromising security.

In case you have a secure on-premises network connected to your Azure virtual network via ExpressRoute or VPN, you can install the self-hosted integration runtime on virtual machines in a Hub VNET. This approach ensures a secure connection to your on-premises environment

2.Yes, it is possible to use an Azure Key Vault service to save the Oracle credentials without any problems. Azure Key Vault is a secure way to store and manage secrets, such as passwords and certificates. You Can store the Oracle connection string like below in the Azure Key Vault which you can use from your linked service if you are connecting using SID.
Host=<host>;Port=<port>;ServiceName=<servicename>;User Id=<username>;Password=<password>;

So, you Azure Key Vault secret value could be something like below -

You can refer to this secret from your linked service and you should be able to connect to your oracle instance. (see below)

Here are some additional resources that you may find helpful:

Hope this helps. Do let us know if you any further queries.

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.

pmscorca 1,052 Reputation points

2023-12-07T09:42:22.01+00:00

Hi @phemanth thanks for your reply.

I thought to use a Data Factory Managed VNet to read data from an Oracle on-premise source to avoid any Self-Hosted IR installation. So, is it mandatory to create a private link service in order to access to Oracle by a private endpoint?
phemanth 15,755 Reputation points Microsoft External Staff Moderator

2023-12-07T13:18:12.8666667+00:00

@pmscorca

Yes, you need to create a private link service to access Oracle by a private endpoint. A private link service is a way to expose a service privately within a virtual network. By creating a private link service for Oracle, you can access it securely from your Data Factory managed virtual network using a private endpoint.
phemanth 15,755 Reputation points Microsoft External Staff Moderator

2023-12-08T08:41:43.0766667+00:00

@pmscorca

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.
phemanth 15,755 Reputation points Microsoft External Staff Moderator

2023-12-11T12:37:29.5+00:00

@pmscorca

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

Using a Data Factory Managed VNet to read data from an Oracle on-premise source

1 answer

Your answer