Using Dataverse Synapse Link as reference data for Stream Analytics

(0) Share

Report

Posted on by Slinlin

Hi,

We are trying to use our Dataverse data as reference for our Azure Stream Analytics. The idea is to couple customer acitivities with their CRM profile state to create meaningful actions for them. We are currently moving from DES to the Dataverse Synapse Link, and have created the data lake where data gets dumped and can see it in Synapse Studio. However, Stream Analytics does not take CDM format out-of-the-box. It seems it can only handle CSV (with headers) and Json formats.

What is the best approach to get our Dataverse data in as reference for Stream Analytics (and in real time as possible)? Should we create a custom deserializer, or use ADF or something else?