So fairly recently Microsoft announced the ability (in preview) to query CDs data with SQL – as opposed to Fetchxml as we have been used to with online.
I will write up a fuller discussion of this, once I have had a proper play, but there were some issues with setting this up, so I put together a short (ish) video to walk through the steps.
Continue Reading Rob Peledie’s Article on their blog
http://www.365knowledge.com/2020/05/25/query-dynamics-365-cds-data-with-sql/
Blog Syndicated with Rob Peledie’s Permission