connect Oracle server using self host IR

Question

Hi Team,

I need connect Oracle server using self host IR, so do i need to install self Hosted IR in my laptop or in oracle server, And is there any other connections to be made to coonect ADF , could you please share detailed answer

Thanks,

Answer 1

Hello @Venkateswarlu Y ,

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

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.

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

• 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