Parameters option is missing for many apps (Salesforce Marketing Cloud, HubSpot, Marketo, etc.) in Azure Synapse/Data Factory linked service

Question

Hi team, I'm working on a solution where I need parameter options for Synapse/ADF linked services. I can see parameters only for few and not for others like Salesforce Marketing Cloud, HubSpot, Marketo, etc. Is it a feature gap, any workaround?

Answer 1

@Rajesh Rai Thanks for using Microsoft Q&A forum and posting your query.

There are few linked service types that the ADF service provides built-in parameterization experience from UI direclty. Please refer to this natively supported list in this document: Natively parameterization Supported linked service types from UI

Advanced authoring: For other linked service types that are not in list mentioned in the above 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}.

For parameterizing linked service using advanced section, you can refer to this video: Parameterize Linked Services using Advanced section in Azure Data Factory

You can follow this approach for other types of linked services where native parameterization from UI isn't supported.

Hope this info helps.

---

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.