Not all properties of linked service is listed in - TemplateParametersForWorkspace.json file

Question

Hello Team,

There are a couple of questions related to synapse CI/CD deployment: -

First question

We are using the "Synapse deployment task for workspace" task in CI/CD release pipeline for synapse workspace deployment. There are a few linked service properties that are not appearing on the TemplateParametersForWorkspace.json file.

For ex: - We are using SAP ECC connector as one of the linked service. Few properties like: -

Message server, Message server service, System ID, Logon group are not appearing on the parameter file.

Only a couple of things - "Client ID and User name" are appearing.

So, everytime we deploy to any environment we have to manually set these connections and test them.

How can we resolve this? Can we edit the parameter file to include these linked service properties? If yes, will the parameter json file be overwritten every time the workspace is published?

Second question -

We are connecting to SAP via SHIR. The SHIR names are different in different environments. Here again, everytime we have to manually select the SHIR from the IR dropdown. Is there a way to parameterize this one as well? So that we need not edit the linked service every time after deployment?

Thanks.

Answer 1

Hi, thanks for your question at Q&A. You can add custom parameters as documented here. In the root of your git branch you can create a template-parameters-definition.json file with custom parameters. The examples shown in the documentation also detail adding parameters for Integration Runtimes.