ADF Linked Service SHIR - Oracle connector 2.0 & TNSNAMES.ORA

Question

Trying to find example on how to configure Linked service using Oracle connector 2.0 to point to TNSNames.Ora file which is available on SHIR server. Documentation is not clear. Can you please send me a link/information on how to make connection using Oracle connection specified in TNSNames.Ora file?

Answer 1

Hi @Thakur, Satyajit

To configure a Linked Service in Azure Data Factory (ADF) using the Oracle Connector version 2.0, specifically pointing to a TNSNames.ora file on your Self-Hosted Integration Runtime (SHIR) server. Here’s a breakdown of how you can go about this: 
 

Configuration of TNSNames.ora: 

Make sure your TNSNames.ora file is correctly set up on the SHIR server. This file should contain the required net service names that your application will use to connect to Oracle databases. Here’s a basic entry for TNSNames.ora: 

ADAPTER =  
  (DESCRIPTION =  
    (ADDRESS_LIST =  
      (ADDRESS = (PROTOCOL = TCP)(HOST = yourOracleServer)(PORT = 1521))  
    )  
    (CONNECT_DATA =  
      (SERVICE_NAME = yourOracleDatabaseServiceName)  
    )  
  )

Replace yourOracleServer and yourOracleDatabaseServiceName with the actual host name and service name.

Creating the Linked Service in ADF 

When defining your Linked Service in Azure Data Factory, you can use the net service name from your TNSNames.ora file as part of the connection string. Here’s how the connection URI should look:

oracledb://ADAPTER

This tells ADF to look for the connection details specified in the TNSNames.ora file on the SHIR server.

After setting up the Linked Service, make sure to test the connection to ensure everything is configured correctly.

For more comprehensive details on these steps, you can refer to the Microsoft documentation here: Configure the Oracle Client for the Oracle Database adapter.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.