SQL 4 CDS

Description

SQL 4 CDS allows you to use standard SQL syntax to query and manipulate your data and metadata in CDS / D365.

Supports
- SELECT
- INSERT
- UPDATE
- DELETE

Where possible the queries are converted to FetchXML, allowing you to generate FetchXML queries for
plugins or integrations by writing familiar SQL and converting it.

Using the preview T-SQL endpoint, SELECT queries can also be run that aren't convertible to FetchXML.

Latest version release notes

Extended TDS endpoint supoprt
Fixed inserts into multi-select picklist attributes

Versions

Version Release date Number of downloads Rating
4.0.0 1/13/2021 5:21:31 PM 1418 0.00
3.1.0 12/13/2020 4:43:19 PM 2514 5.00
3.0.0 11/2/2020 5:24:16 PM 3274 0.00
2.3.0 8/28/2020 7:45:41 PM 3995 5.00
2.2.0 7/15/2020 7:41:00 PM 2697 0.00
Show more versions (15 more)

Ratings

Latest version

No feedback yet. Add yours

Other versions

(Ivo Bouwman, )
This one helped me a million times by now.
(Chung Lee, )
(Marc Scheuner, )
Absolutely fantastic plugin for anyone who's at home in SQL, and misses the power and flexibility of SQL when working with Dynamics365 - wonderful job, Mark! Couldn't do my work without your plugin!
(Durgaprasad Katari, )
Great tool, can enable TDS endpoint easily without running the orgDBsettings exe.
(Nishant Rana, )
Awesome tool. Thanks !
(Patrick Lauziere, )
Great tool to extract data in fields order you want.
(Nicola Micheletto, )
(CRM Admin, )
(Rich Waring, )
Great to have a way to effectively run sql queries against the D365 back end - saved me a lot of time today.

Related information

Author: Mark Carrington Latest version: 4.0.0 Released on: 01/13/2021 Nuget package Id: MarkMpn.SQL4CDS Open Source: true Go to project web site Ratings (all versions) 5Average rating 9Number of ratings Downloads 1418Latest version 32345All versions 1617.25Average per version