You’re offline. This is a read only version of the page.
Hi All,
We are migrating from 2013 onpremise to d365 online dynamics CRM.I have all the reports in 2013 but for D365 for reporting we use fetch xml queries.I have sql queries for all the reports but for using reports in d365 those reports wont be supported and needs to be modified according to fetch xml queries.I want to know whether there is any tool available online for converting the sql quries to fetch xml queries or do i need to write fetch xml queries manually for all the reports.I chceked with sql2fetchxml.com but it gives error for issues like joins.Kindly let me know if anyone had come across any tool for this.
Thanks in advance
thanks Matt.I am trying with query builder in xrm toolbox
Hi Priti01,
Some SQL queries cannot be converted to equivalent FetchXML queries. This article presents a list of current FetchXML limitations.
Hi Priti
I do not know of any tools to be able to do this automatically. I have previously had to re-write all the queries manually, but the FetchXML builder can help with creating the queries and building outer joins, not possible through advanced finds alone. There is an element of restriction with FetchXML compared to SQL, so it might be that you cannot recreate the report queries exactly. There are ways around this like the data export service to replicate data in an azure hosted SQL db and doing SQL reporting on that server instead of D365, but it depends on the reports, how critical they are and if the expense of this method would be justifiable.
Thanks
Matt
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (