topic Re: Connect To Microsoft Dynamics Finance and Operations in Connectivity & Data Prep

Connect To Microsoft Dynamics Finance and Operations

wcilliers — Mon, 16 Aug 2021 23:51:27 GMT

Hi All,

I am looking for some guidance to connect to a MS D365 F&O (FinOps) environment using Qlik Sense SaaS. I have tried using the Rest Connector as well as OData, but not able to authenticate.

I also tried the D365 CRM connector just for in case, but that also did not work.

Any ideas?

Thanks,

Wynand

Re: Connect To Microsoft Dynamics Finance and Operations

NZFei — Fri, 10 Jun 2022 03:36:36 GMT

Same problem that I am having now. Anyone has any idea please?

Re: Connect To Microsoft Dynamics Finance and Operations

philipp_ebner — Wed, 05 Jun 2024 14:42:56 GMT

Hi, it's been a while since the last post here. The current solution would be to create an Azure Synapse Analytics Workspace + an Azure Data Lake Storage (all in Azure). With the help of MS Power Platform you can then create an "Azure Synapse Link" and copy your D365 Tables to the Azure Data Lake over this Link ("Delta Parquet" or (Delta)- Format). From there you can grab the *snappy.parquet Files with Qlik Saas. you will probably have to build a logic in Qlik script in order to meaningfully concat the parquet files (insert , update, delete).

Re: Connect To Microsoft Dynamics Finance and Operations

FedericoC — Wed, 17 Jul 2024 23:42:36 GMT

Do you pay an extra for Azure Synapse Link?

Re: Connect To Microsoft Dynamics Finance and Operations

Aslam07 — Wed, 25 Feb 2026 15:40:18 GMT

Hey do you have step by step documents for this ? I have successfully set up my Synapse Link. However, I am not able to connect to my Qlik.