Need to Extract Data from an Oracle Database on OCI using Synapse - Is there any alternative to create a Self-Hosted as I don't want to mange the VM?

Question

Hello -

I have an azure synapse workspace created. I want to extract data from an oracle database which is on Cloud. I have created Site2Site VPN between azure and OCI and I can access the database now.

I am using self-hosted VM as an Integration run time which means I need to maintain this machine and I want to avoid that.

Is there anyway I can use the Azure Integration run and chose the SKU of that IR rather than create the Self-Hosted IR.

Client has not forecasted for these costs as we never told that we need to maintain a separate VM for this.

Is there any alternatives to self-hosted.

Please help!

Answer 1

Hello Xhevahir Mehalla,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

Sequel to your questions, I understand that you are facing challenges due to your task to extract data from an oracle database and to use the Azure Integration run and chose the SKU of that Integration Runtime (Azure IR) rather than create the Self-Hosted IR.

This prescribed solution was based on the scenario given and your questions, while focusing on the problem statement. To connect to an Oracle database on the cloud from Azure Synapse without maintaining a self-hosted Integration Runtime (IR), you have a few options that could be considered as alternatives.

About Azure Synapse, it provides an Azure-hosted IR, which is a fully managed service. However, as of now, Azure IR does not natively support direct connectivity to on-premises or private network databases like Oracle on OCI. This is where your Site-to-Site VPN would come into play.

Therefore, Azure Data Factory (ADF) offers a Managed Virtual Network (Managed VNet) integration runtime which can be used to securely connect to data sources in your private network without requiring a self-hosted IR. This can be a great alternative because you can connect your Managed VNet IR to the Oracle database over the VPN connection.

The three tasks you will need to focus on are:

1. Create a Managed VNet Integration Runtime in ADF.
2. Configure the Managed VNet IR to Use Your VPN.
3. Link Azure Synapse to the Managed VNet IR.

Accept Answer

I hope this is helpful! Do not hesitate to let me know if you have any other questions.

** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful ** so that others in the community facing similar issues can easily find the solution.

Best Regards,

Sina Salam