SQL 4 CDS attempts to convert your SQL query into FetchXML so it can be executed natively by CDS. However, SQL is a very rich language and there are a lot of queries that can’t be directly converted. For example, trying to compare two fields: There is no way to Continue Reading
I’m very pleased to announce the release of SQL 4 CDS version 1.0.6! Please update your existing versions in XrmToolBox to get some great new features…
Firstly, thank you to everyone who’s shown an interest in my SQL 4 CDS XrmToolBox tool! I’ve been busy working on the difficult second release, and I’m pleased to announce version 1.0.3 is in the new Tool Library today!
If you’re anything like me you probably find querying the data in CDS a pain, either using the Advanced Find interface or writing FetchXml. Tools such as FetchXMLBuilder help a lot, but I still think about the query I want to write in good-old SQL and then have to translate Continue Reading
Know SQL and want to access your Dataverse/CDS/PowerApps/D365 data? Enter SQL 4 CDS, my XrmToolBox plugin to get a SQL Server Management Studio type interface to query your data! If you’re using SSMS to connect to the TDS endpoint you can also check out the SSMS edition! Introduction Installation Connecting Continue Reading