ADF Oracle Linked Service 2.0

Question

ADF Oracle Linked Service 2.0

SK 0

I am in process of upgrading Oracle Linked Service from 1.0 to 2.0 as recommended by MS.However am facing issue while providing the connection string similar to 1.0 into 2.0.To be precise, in 1.0 we used to pass SID and Port Number, however when I try to upgrade to 2.0 am not able to find any option to provide SID or Port Number which is required to establish a connection. Any update is much apriciated

Anonymous

2025-08-07T05:43:18.2033333+00:00

Hi SK,

Greetings for the day!

Just checking to see if you have a chance to check my previous response and helped, do let me know if you have any further questions on this.

If the provided information answers your query, do click "Upvote", it will help others who might be facing similar challenges.

Thanks

Kalyani
Anonymous

2025-08-08T05:10:43.84+00:00

Hi SK, Hope you are having great day!

Just a quick follow-up to see if you’ve had the chance to try the suggested approach, if you ran into any issue or need more details. please feel free to let me know.

Looking forward to your update.

Thanks,

Kalyani
CHERUKUMALLI,SIVA RAMA KRISHNA 0 Reputation points

2025-09-16T16:36:34.5533333+00:00

Oracle V1 connection: This allows us to store the entire connection string in Key Vault, enabling us to reuse a single connection for any Oracle data source.

Oracle V2 connection: With this version, we need to specify the hostname and username at the connection level. Alternatively, we can parameterize the host and username and supply these values at runtime.

In both parameterization approaches, the physical hostname and username are exposed in ADF/Azure logs. Wouldn’t this pose a security concern?

1 answer

Your answer

Anonymous

2025-08-07T05:43:18.2033333+00:00

Hi SK,

Greetings for the day!

Just checking to see if you have a chance to check my previous response and helped, do let me know if you have any further questions on this.

If the provided information answers your query, do click "Upvote", it will help others who might be facing similar challenges.

Thanks

Kalyani
Anonymous

2025-08-08T05:10:43.84+00:00

Hi SK, Hope you are having great day!

Just a quick follow-up to see if you’ve had the chance to try the suggested approach, if you ran into any issue or need more details. please feel free to let me know.

Looking forward to your update.

Thanks,

Kalyani
CHERUKUMALLI,SIVA RAMA KRISHNA 0 Reputation points

2025-09-16T16:36:34.5533333+00:00

Oracle V1 connection: This allows us to store the entire connection string in Key Vault, enabling us to reuse a single connection for any Oracle data source.

Oracle V2 connection: With this version, we need to specify the hostname and username at the connection level. Alternatively, we can parameterize the host and username and supply these values at runtime.

In both parameterization approaches, the physical hostname and username are exposed in ADF/Azure logs. Wouldn’t this pose a security concern?

Answer 1

Hello SK,

Thanks for reaching out on Microsoft Q&A!

You're absolutely right, in ADF Linked Service v2.0 for Oracle, the previous fields like Host, Port, and SID are no longer individually exposed.

To Configure Oracle Linked Service (v2.0):

1.Open Azure Data Factory:

Navigate to your Data Factory instance in the Azure portal.

2.Create a New Linked Service

Go to Manage (gear icon in the left panel)
Select Linked services > Click + New
Choose Oracle as your data store

3.Configure Base Connection

Name: Provide a friendly name for your linked service
Integration Runtime: Select your Integration Runtime (e.g., self-hosted for on-premises DB)
Server name: example (salesserver1: 1521/sales.us.example.com)<<replace yours>>
Authentication type: Choose Basic
Username / Password: Enter your Oracle DB credentials

{ 
    "name": "OracleLinkedService", 
    "properties": { 
        "type": "Oracle", 
        "version": "2.0", 
        "typeProperties": { 
            "server": "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= oraclesample.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=db1)))",  
            "username": "<user name>",  
            "password": "<password>",  
            "authenticationType": "<authentication type>" 
        }, 
        "connectVia": { 
            "referenceName": "<name of Integration Runtime>", 
            "type": "IntegrationRuntimeReference" 
        } 
    } 
}

Please refer the Microsoft document to get more details about Oracle 2.0 connector

https://learn.microsoft.com/en-us/azure/data-factory/connector-oracle?source=recommendations&tabs=data-factory

If the provided I formation helpful, do click the "Upvote" which might be beneficial to other community members reading this thread. Please let us know if you need more details.

Thanks,

Kalyani

CHERUKUMALLI,SIVA RAMA KRISHNA 0 Reputation points

2025-09-19T14:49:52.1133333+00:00

Hi Kalyani,
You misunderstood my question. In ADF Linked Service v2.0 for Oracle, both the host and usernames are visible in the ADF/Azure logs, contrary to what you stated. Is this not the case?

Additionally, in version 2, there isn’t an option to store all connection details (host, port, username, password) in KeyVault, unlike what was possible in version 1. When introducing a new version, it should ideally offer improvements over the previous one. We expect that V2 should allow the entire connection string to be managed through a KeyVault secret.
Srinivas Ketaraju 0 Reputation points

2025-09-29T18:44:20.49+00:00

If my details are as below, how can this fit in 2.0

server :host=servername.isidc.com;

port=1527;

sid=XYZ

;user id=ABC

Share via

ADF Oracle Linked Service 2.0

1 answer

Your answer