Use SQL to query data in CDS (Preview) - Part 1 (Connection and the first query)

Good evening friends,

Today I wanted to explore a significant step for Power/Dynamics professionals. As of this week, you can query CDS (Common Data Service) using SQL. So let explore all the quirks and features of this new approach.

Note, to benefit from it; one needs to be already familiar with CDS architecture and CDS. In my opinion, experience with older, on-premise systems also very beneficial.

It is important to note that the connector is read-only. It is not possible to create, update or delete records.

So, let’s see.

First, you must download SQL Server Management Studio. Note, the version must be 18.4 or higher. I have tried an older one and was not able to connect.

Second, the connection string:

*Do not forget the port at the end of the Server Name*

Once connected, you will be able to see the list of tables.

Select "New Query" and let's write a simple query

There is another pleasant observation. The tables allow you to see value as well as a label of a reference.

Stay tuned, more sections coming shortly.