Using SQL Management Studio with CDS

By | May 15, 2020

Just got to play with the latest cool feature, which is using SQL Management Studio to connect to CDS environments. You’ll find the documentation here:

If you have not seen what it looks like, here is an example:


To set it up, you just need SSMS v18.4, and don’t forget to configure your environment to enable TDS endpoint. Which you can do with the help of this solution, for example:

Just need to update the setting below before you try connecting SSMS to the environment;


And then it just works. From my very quick testing so far, here are some observations – they are not making this feature less exciting, but this is just something to keep in mind:

  • RetrieveMultiple plugins are not working when you are querying data in SSMS. There are lot of solutions which would be using those plugins for localization/security, and, it seems, SSMS is just bypassing them, so that’s something to keep in mind
  • Looking at the speed of those queries, it seems they are running directly against the database (no fetchxml involved)
  • This is not the same as having access to the on-prem database – there are no views, for example
  • If you have lots of data, I’d suggest using TOP X in your SELECT queries. Or it may take quite a bit of time to get the results
  • All data is read-only (which you can see on the first screenshot above, next to the database name). In either case, UPDATE statements etc are not supported. Which is understandable since they would have to go through the API

7 thoughts on “Using SQL Management Studio with CDS