How can we migrate/copy Oracle database hosted in a Linux server to Azure Datalake Storage?

Question

We are trying to migrate/copy Oracle database hosted on a Linux server to Azure Datalake Storage using ADF linked service. Please advise if we still need the integration runtime? Is it possible to use just linked service to copy? I am not sure if Linux server is supported for integration runtime. Please advise. Thanks!

Answer 1

Hi Raj Ravulapalli,

Thank you for posting query in Microsoft Q&A Platform.

Please note, linked service is only connection information about the storage or server. It's like connection string only. Intergration runtime, is the one which actually does the compute and data movements. So, Integration runtime is mandatory. In fact, while you create linked service you select integration runtime also inside it.

If your data storage is not on cloud and publicly not accessible, then you need to consider installing integration runtime on the server to establish connection between your storage and ADF.

Below are few videos, I recommend you watch to get better understanding.

Linked service in ADF

Integration runtime in ADF

Install and configure self-hosted IR in ADF.

Hope this helps. Please let me know if any further queries.

---

Please consider hitting Accept Answer button. Accepted answers help community as well.