Monday, March 25, 2013

Introducing SQL2FetchXML Online Converter

Today, I would like to share with you that KingswaySoft, where I work, has just launched a new website called SQL2FetchXML.com, which is a free online converter that helps convert SQL script into CRM FetchXML query.

FetchXML is a proprietary query language that is used in Microsoft Dynamics CRM, which helps query data from CRM system through its web service interface. We, as developers, are usually familiar with writing SQL script. Often the case, we take pride in our productivity when writing SQL script, and sometimes complex ones. But when it comes to FetchXML, we need to worry about the XML syntax, formatting, which makes us much less productive. With sql2fetchxml.com website, you can continue to use your SQL mindset, and let the utility handle the conversion for you.

Please feel free to give it a try and let me know how it goes.

Hope you find this utility useful.

6 comments:

  1. Thanks Daniel Cai I will defiantly try this. :)

    ReplyDelete
  2. Hi Daniel,

    thanks for that idea. I can imagine, that this would help a lot. Converting a SQL report to CRM Online is only one idea. I tried just something pretty simple.
    I did a "SELECT new_entityid FROM Filterednew_entity", because you should use the filtered views.
    The converter should check for a Filtered in front of the entityname and remove it in the resulting Fetch-XML.

    I will try more complex SQL-scripts later, but I am clear, that this tool will not break the limitiations of FetchXML. ;-)

    Great work!
    Lars

    ReplyDelete
    Replies
    1. @Lars, thanks for your feedback. We have just uploaded a new build which should handle filtered views properly now.

      Kind regards,
      Daniel Cai

      Delete
  3. nice done Daniel

    i have tried several of it and it runs just perfect.

    here is something i found some point out of support in sql reading:
    implict table alias, right join, distinct

    are those one as deaigned ?

    -stan

    ReplyDelete
    Replies
    1. I will have to look into the support for implicit table alias. Right join is not supported, it is a limitation of FetchXML query. Distinct is already supported, and if the converter doesn't work for your specific query, please post your query here, so I can have a look.

      Delete