CODEWITHSUNDEEP
oracle-databaseazureazure-data-factoryazure-resource-manager
Jan Lender
Jan Lender

Reputation: 58

Azure Data Factory - ARM Template

I'm deploying ARM template to Azure Data Factory v2 using PowerShell command 

New-AzureRmResourceGroupDeployment -Name MyDeployment -ResourceGroupName myResourceGroup -TemplateFile C:\work\arm_template.json -TemplateParameterFile C:\work\arm_template_parameters.json

There are two Oracle 12c Linked Services in the factory. The deployment fails with error messages pointing something wrong was with these linked services. The messages provide no details:

Resource Microsoft.DataFactory/factories/linkedServices 'myDataFactory/myLinkedServiceOne' failed with message '{
  "code": "BadRequest",
  "message": "Error message not found.

I can see all resources of the Data Factory in Azure Cloud after the deployment fails but those two Linked Services (and pipelines that depend on the Linked Services)

The issue I'm aware of is I didn't know how connection strings should have look like. I didn't find it in MS documentation so I made them up completely. They were as follows (arm-template-parameters.json):

    "myLinkedServiceOne_connectionString": {
        "value": "Host=mydatabase.host.net;Port=1536;SID=someSid;User Id=someUser;Password=somePassword;"
    },

My question is: How Oracle DB connection string should look like in ARM parameters file?

Upvotes: 0

Views: 970

Answers (1)

Fang Liu
Fang Liu

Reputation: 2363

This is due to your Integration Runtime is offline. Please restart it and try it again.

You connection string looks fine according to this doc.

But if you are using ODBC connector, you should follow this doc.

Upvotes: 1

Related Questions