I use SQL 4 CDS in XrmToolBox quite often, but I found a case where I need to update some data on D365 Contacts based on a query I've created in SQL 4 CDS in XrmToolBox. It's using SQL logic that doesn't transpose to FetchXML, so how can I use this SQL style query with an Azure Data Factory against the Dataverse (or is it CDS) as Source so we can update these fields in D365.
The only alternative I have is to pull down every contact into a SQL database or somehow evaluate every contact through a generic FetchXML which I hope can be avoided given I have a query in SQL 4 CDS that returns in seconds the few fields that need to be updated.
Thanks for insight.