How To Query CDS Data Using SSMS

One of the exciting announcements during the Microsoft Business Application Summit 2020 Virtual Event was about the T-SQL Endpoint for the Common Data Service (CDS). This means we can now use SQL Server Management Studio (SSMS) to look at the tables/entities, its columns and write very complex SQL queries.

So, how do we setup that SQL connection to CDS? Let’s go through the steps below.

Pre-requisites

  • SSMS version 18.4 or later
  • CDS Environment version 9.1.0.17437 or higher

Enable the TDS Endpoint

Go to Power Platform Admin Center, select your environment and then under the environment Settings, expand Product then click on the Features link. Scroll down on your screen and turn on the Enable TDS Endpoint toggle, then press Save:

T-SQL-CDS

NOTE: As of this writing, this feature is still in preview and not available in all regions.

Connect to the Server

Open SQL Server Management Studio and supply the following in the Object Explorer then press Connect:

T-SQL-CDS
Server Name Your organization’s address URL followed by a comma and port number of 5558
Authentication Only Azure Active Directory is supported.
User Name AAD email address
Password AAD password

 

T-SQL-CDS

You can now start writing your SQL queries:

T-SQL-CDS

Happy querying in CDS! If you have any questions about the Common Data Service, please get in touch with us.

18 Warning Signs You Need The Cloud

If your business experiences these red flags, your diagnosis is clear: time to adopt the cloud!

Get The Report

18 Warning Signs You Need The Cloud

Get The Report