none
ARM parameters - Connection String for Oracle DB

    Question

  • I'm deploying ARM template to Azure Data Factory v2. There are two Oracle 12c Linked Services in the factory. I have no clue how connection string should look like in arm_template_parameters.json file. I tried it as follows but my version caused deployment failed.


            "myDBConnectionLinkedService_connectionString": {
                "value": "Host=xxxxx.xxx;Port=1536;SID=XXSIDXX;User Id=xxuserxx;Password=xxpasswordxx;"
            },

    My question is what is the required format of connection string for Linked Service pointing to Oracle 12g database.

    Monday, June 25, 2018 11:31 AM

All replies

  • Hi Jan,

    Please reference https://docs.microsoft.com/en-us/azure/data-factory/connector-oracle#supported-capabilities

    Specifically, this Oracle connector in ADF v2 supports the following versions of an Oracle database. It also supports Basic or OID authentications:

    • Oracle 12c R1 (12.1)
    • Oracle 11g R1, R2 (11.1, 11.2)
    • Oracle 10g R1, R2 (10.1, 10.2)
    • Oracle 9i R1, R2 (9.0.1, 9.2)
    • Oracle 8i R3 (8.1.7)

    So I'm afraid Oracle 12g database connector hasn't been supported yet.

    Monday, June 25, 2018 1:04 PM