Share via

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,686 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 41,006 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
  3. Pinaki Ghatak 2,400 Reputation points Microsoft Employee
    2024-05-03T08:52:00.2566667+00:00

    Hello @Learn@MN

    To connect to an on-premises Oracle database from Azure Data Factory, you need to use the Data Management Gateway.

    The gateway acts as a bridge between your on-premises data source and Azure Data Factory. Here are the high-level steps to set up the connection:

    1. Install the Data Management Gateway on a machine that has access to the Oracle database.
    2. Configure the gateway to connect to the Oracle database.
    3. Create a linked service in Azure Data Factory that points to the gateway.
    4. Create a pipeline in Azure Data Factory that uses the linked service to copy data from the Oracle database to your Azure SQL Database. For detailed instructions on how to set up the connection, please refer to the following Microsoft documentation: - Copy data to or from Oracle on-premises by using Azure Data Factory

    This article provides step-by-step instructions on how to set up the connection and copy data from an on-premises Oracle database to Azure SQL Database. Regarding the additional configurations required on the Azure or Oracle side, you need to make sure that the machine where the Data Management Gateway is installed has access to the Oracle database. You may need to configure firewall rules or VPN connections to enable this access. Additionally, you need to make sure that the Oracle database is configured to allow connections from the machine where the Data Management Gateway is installed.

    I hope this helps in your Oracle to Azure journey

    0 comments