topic Re: Upsert data to an on-premises MSCRM system via Fabric pipelines in Pipelines

Upsert data to an on-premises MSCRM system via Fabric pipelines

mzinic96 — Mon, 12 Aug 2024 12:45:08 GMT

Is it possible to add an on-premises MSCRM as a destination in pipelines? I am having trouble with the connection. Which connector should I choose, or what type of connection should I create in the 'Manage connections and gateways' section?

Re: Upsert data to an on-premises MSCRM system via Fabric pipelines

Anonymous — Tue, 13 Aug 2024 09:45:02 GMT

Hi mzinic96 ,

For a local MSCRM data source, you should use the on-premises data gateway. This gateway allows you to connect to local data sources using data flows and data pipelines in Microsoft Fabric.

download gateway

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Upsert data to an on-premises MSCRM system via Fabric pipelines

mzinic96 — Tue, 13 Aug 2024 12:17:15 GMT

Hi Anonymous, thank you very much for the response. I have one more question. In the Copy Data activity in a pipeline, which connector should I use as the destination? Dynamics 365 and Dynamics CRM only support Service Principal authentication, which I can't use with an on-premises MSCRM.

Should I maybe create a connection to the on-premises MSCRM in the 'Manage connections and gateways' section? If so, which connection type should I choose?

Do I maybe have to create a connection to the on-premises MSCRM in the 'Manage connections and gateways' section? Which connection type should I choose?