Converting Fetch XML to SQL in Dynamics 365


Hi,

Recently we had a requirement to convert Fetch XML query of certain views to SQL. Basically, we wanted to validate it again the source DB from which we push the data inside Dynamics 365.

For this we can use the below managed solution,

https://fetchxml2sql.codeplex.com/

The tool is built using Silverlight so will only work in IE.

The other tool is that we can use is one of the most useful plugins –  Fetch XML Builder of  XRM Tool Box.

Plugin

Below video explains how to use them

https://www.youtube.com/watch?v=OESJxa3bwrU

Hope it helps..

Advertisements

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

One thought on “Converting Fetch XML to SQL in Dynamics 365”

Please share your thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.