Update Oracle Connection version 2.0 from 1.0

Question

Update Oracle Connection version 2.0 from 1.0

Colinn Calaguas 70

This is connected to another question I have.

https://learn.microsoft.com/en-us/answers/questions/5490043/adf-oracle-connection-deprecated-version-1-0

Since the version 1 will be decommissioned soon. We need to update our Oracle connections to version 2. How can make a TNS connection from this example?

EDGE Ebix Version 1

For this connection we have a Host, Port, Service Name, we are NOT using Azure Key Vault and there's a property encrpytionmethod with value of 1.

When we switch this to version 2. I'm not sure how to map these fields correctly.

EDGE Ebix version 2

There's a lot of property names here that exists by default when we switched it to version 2.0.

Really appreciate any suggestions on this.

I have this TNS but not sure if this is correct.

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= 10.1.2.3)(PORT= 1521))(CONNECT_DATA=(SERVICE_NAME= orcl)))

2 answers

Your answer

Answer 1

Hi ,

Thanks for reaching out to Microsoft Q&A.

To migrate your Oracle linked service from version 1.0 to 2.0 in ADF, you need to map the old connection details to the new fields provided in version 2.0, as the TNS string is no longer supported directly. From your version 1.0 setup, take the host (10.1.2.3), port (1521), and service name (orcl) and enter them in the Server, Port, and Service name fields respectively in the version 2.0 configuration. Keep the auth type as Basic and enter the same username and password as before. For the additional property encryptionmethod=1 that you had in version 1.0, set Encryption client to accepted and Crypto checksum client to accepted in version 2.0, leaving the encryption and checksum type fields blank unless your DBA specifies algorithms like AES256 or SHA1. Your provided TNS string is correct but only serves as a reference for extracting these values, as version 2.0 uses explicit field mappings rather than a TNS entry. Once the configuration is complete, test the connection, and if encryption errors occur, confirm the required encryption and checksum algorithms with your DBA before finalizing the setup.

Please 'Upvote'(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.

Colinn Calaguas 70 Reputation points

2025-08-29T11:21:15.1966667+00:00

Thank you both for your answers. Few weeks ago we managed migrate one of our Oracle connection that's using SID using this TNS in the Server field for Version 2.0 and since there are no properties, it works perfectly.

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.2.3)(PORT=1521))(CONNECT_DATA=(SID=orcl)))

We are also using AKV for this setup.

Now we used this format to specify in the Server field and we are using username and password on this.

In which I'm sure we placed the correct username and password in setting up our linked service.

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.2.3)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))

We've added also the properties Encryption client and Crypto checksum client.

and after testing the connection, we've received this error.

Do we need to use AKV to make this work? I'm still verifying about which algorithms are used from our DBA to setup this connection.

But isn't that also need to be specified when we are using the version 1.0 of this connection in which it's working fine so I'm assuming we don't need to specify anything for Encryption types client and Crypto checksum types client.

Any steps I'm missing?

Answer 2

Hello Colinn Calaguas, thanks for posting your query on Microsoft QnA!

As correctly mentioned by Vinodh247, a mapping is required for old connection details. In addition to his answer, I would like to share some references and additional details which may help you with your issue.

Here are some references to help clarify and guide you:

Oracle Connector 2.0 documentation for Synapse Analytics: Copy data from and to Oracle by using Azure Synapse Analytics (This page details the configuration for Oracle Connector 2.0, showing the individual fields).
Upgrade the Oracle connector upgrade the Oracle connector
Key Vault integration with Synapse Linked Services (general concept): Store credentials in Azure Key Vault (While not specific to Oracle 2.0, this explains the pattern for retrieving individual secrets to populate parameterized linked service properties)

If you are using the Username and password not SSO

Use the below string with password in AKV :

{"server":"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=SQL.saku.lab)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl.saku.lab)))","authenticationType":"Basic","username":"SYSTEM","password":"<>"}

Your linked JSON should look like this.

{
    "properties": {
        "type": "Oracle",
        "version": "2.0",
        "typeProperties": {
            "connectionPropertiesInString": {
                "type": "AzureKeyVaultSecret",
                "store": {
                    "referenceName": "orcl_akv_LS",
                    "type": "LinkedServiceReference"
                },
                "secretName": "latest-secret"
            }
        },
        "connectVia": {
            "referenceName": "integrationRuntime1-shir",
            "type": "IntegrationRuntimeReference"
        },
        "annotations": []
    }
}

Please "Accept as Answer" if the answer provided is useful, so that you can help others in the community looking for remediation for similar issues

Thanks

Pratyush

Pratyush Vashistha 1,525 Reputation points Microsoft External Staff Moderator

2025-08-26T03:23:01.8433333+00:00

Hello Colinn Calaguas,,

Following up 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.

Thanks

Pratyush
Pratyush Vashistha 1,525 Reputation points Microsoft External Staff Moderator

2025-08-27T06:08:33.4+00:00

Hello Colinn Calaguas,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Please "Accept as Answer" if the answer provided is useful, so that you can help others in the community looking for remediation for similar issues.

Thanks

Pratyush
Colinn Calaguas 70 Reputation points

2025-08-27T14:04:13.66+00:00

Hi. Sorry I was Out of Town in the past few days. I'll try this and let you know if this works. Thank you so much.

Share via

Update Oracle Connection version 2.0 from 1.0

2 answers

Your answer