How to access an Oracle database on a different server from ADF

Learn@MN 0 Reputation points
2024-03-15T02:12:32.37+00:00

Hi,

I have Azure Data Factory (ADF) configured to work with Azure SQL Database. However, I also need to access data from a separate Oracle database located on another server. How to set up a connection in ADF to extract data from this Oracle database? Are there any additional configurations required on the Azure or Oracle side to enable this connection? Please advise.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,549 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,816 Reputation points
    2024-03-15T06:14:58.7+00:00
    1 person found this answer helpful.
    0 comments
  2. Suba Balaji 11,186 Reputation points
    2024-03-15T06:38:45.6733333+00:00

    Adding few more details:

    Whenever you are going to pull or push data to a new data source, you need to use appropriate linked service. In your case, you would have created a linked service to azure SQL db. Like that you have to create a linked service pointing to your Oracle source.

    Once you create a linked service, you can create data sets and use the same in copy activity or data flow to pull or push data from Oracle

    1 person found this answer helpful.
    0 comments