ADF connecting to ORacle on VM without SelfHosted-IR

Question

Hi,

I am trying to connect to a Oracle Db from ADF.

The oracle db is on a cloud VM and installation of any software is prohibited (so installing Self-Hosted IR is out of question).
The oracle db and the VM which hosts it, is an external cloud (say AWS) on Virtual Networks.

Is there is a way we can connect ADF to Oracle db in this setup? If so then what are the steps and approach.

Answer 1

Hello @Subash Hasuruvalli ,

Thanks for the question and using MS Q&A platform.

Unfortuatnely, it's not possible to connect Oracle on VM without self-hosted integration runtime.

Here are the prerequisites:

• 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.
• If your data store is a managed cloud data service, you can use the Azure Integration Runtime. If the access is restricted to IPs that are approved in the firewall rules, you can add Azure Integration Runtime IPs to the allow list.
• 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 information about the network security mechanisms and options supported by Data Factory, see Data access strategies.

For more details, refer to Copy data from and to Oracle by using Azure Data Factory or Azure Synapse Analytics.

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

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

• Please don't forget to click on or upvote 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 jhow you can be part of Q&A Volunteer Moderators