How to migrate Oracle on-premise data into the Oracle Fusion cloud using Azure Data Factory

Question

Hi All,

I am looking for your help in the following use case:

I want to migrate the Oracle on-premise data to the Oracle Fusion cloud. Currently, I don't find any direct General Available connector available in the data factory to do the same. Could you please let me know if anyone has encountered the same and can suggest aropund workarounds?

Answer 1

@Shivam Shukla Welcome to Microsoft Q&A forum and thanks for reaching out here.

As Amira mentioned in her comment, currently, Azure data factory has native connectors for below Oracle products:

• Oracle Database
• Oracle Cloud Storage
• Oracle Eloqua (Preview)
• Oracle Responsys (Preview)
• Oracle Service Cloud (Preview)

For full list of Azure data factory supported connectors click here.

Workaround: To move data to/from a data store that Data Factory does not support, or to transform/process data in a way that isn't supported by Data Factory, you can create a Custom activity with your own data movement or transformation logic and use the activity in a pipeline.

Or if you can use the REST API of Oracle fusion cloud, then you can leverage REST connector in Azure data factory to send data to Oracle Fusion cloud.

If you would like to submit a feedback to product team, please feel free to log your feature request in ADF feedback forum here: https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c

All the feedback shared in this forum are actively monitored and reviewed by ADF product team.

Hope this info will help.

---

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.