Hello @Anonymous ,
Thanks for the question and using MS Q&A platform.
As per my understanding you would like to know how to parameterize Dataverse connector as it is not supported to parameterize natively in UI as that of other connectors described in this document: Supported linked service types for parameterization. Please correct if my understanding is wrong.
For other linked service types that are not in list called out in the document, you can parameterize the linked service by editing the JSON on UI:
- In linked service creation/edit blade -> expand "Advanced" at the bottom -> check "Specify dynamic contents in JSON format" checkbox -> specify the linked service JSON payload.
- Or, after you create a linked service without parameterization, in Management hub -> Linked services -> find the specific linked service -> click "Code" (button "{}") to edit the JSON.
Refer to the JSON sample to add parameters section to define parameters and reference the parameter using @{linkedService().paramName}.
Here is a sample on how to parameterize a Dataverse connector using Advance authoring option in UI. In this example I have parametrized Organization name for the serviceURI
and also the servicePrincipalID
and then passed those values from pipeline parameters -> Dataset parameters -> Linked service parameters.
{
"name": "Dataverse1",
"type": "Microsoft.DataFactory/factories/linkedservices",
"properties": {
"parameters": {
"paramOranizationName": {
"type": "string",
"defaultValue": "defaultValue"
},
"paramservicePrincipalId": {
"type": "string",
"defaultValue": "defaultValue"
}
},
"annotations": [],
"type": "CommonDataServiceForApps",
"typeProperties": {
"deploymentType": "Online",
"serviceUri": "https://@{linkedService().paramOranizationName}.crm.dynamics.com",
"authenticationType": "AADServicePrincipal",
"servicePrincipalCredentialType": "ServicePrincipalKey",
"servicePrincipalId": "@{linkedService().paramservicePrincipalId}",
"encryptedCredential": "ew0KICAiVmVyc2lvbiI6xxxxxxx250ZW50VHlwZSI6ICJQbGFpbnRleHQiLA0KICAiQ3JlZGVudGlhbElkIjogIkRBVEFGQUNUT1JZQEIzRjhGQTE0LTI3ODAtNDg2OS05NjNFLTJCM0M2MEY0Njk2NF81ZWIxNjFiOC0yYzRkLTQ1Y2ItYTYzNy01ODlmZmRkOThiZGEiDQp9"
}
}
}
- Dataset parameters:
- Dataset Parameters to Linked Service Parameters:
- Pipeline parameters to Dataset parameters:
Here are couple of forum threads where a similar requirement has been discussed:
- SFTP Connection customization / parameterization
- The integration runtime has two disk drives, is there a way to parameterize the Host field in the linked service file system?
Hope this will help. Please let us know if any further queries or if your requirement is different from my understanding.
------------------------------
- Please don't forget to click on
or upvote
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
- Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators