Cannot parameterize dynamics linked service

Anonymous
2022-07-12T04:24:10.117+00:00

This is an odd one. Currently if we want to link to Salesforce (a non Microsoft product) we can use parameterization in the setup of the linked service. However it's Microsoft competitor (CRM Dynamics), we cannot setup the linked service with parameters. This makes the non Microsoft product quite a bit more compelling for integration. I understand that it's not supported as indicated here, but I find this to be a major oversight.

When are we getting parameter support for Dynamics in Data Factory?

219677-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,209 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,602 Reputation points Microsoft Employee
    2022-07-12T21:05:53.62+00:00

    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:

    220091-image.png

    • Dataset Parameters to Linked Service Parameters:

    220076-image.png

    • Pipeline parameters to Dataset parameters:

    220092-image.png

    Here are couple of forum threads where a similar requirement has been discussed:

    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 130616-image.png or upvote 130671-image.png 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

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.