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.
- SSMS version 18.4 or later
- CDS Environment version 220.127.116.1137 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:
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:
|Your organization’s address URL followed by a comma and port number of 5558
|Only Azure Active Directory is supported.
|AAD email address
You can now start writing your SQL queries:
Happy querying in CDS! If you have any questions about the Common Data Service, please get in touch with us.
If your business experiences these red flags, your diagnosis is clear: time to adopt the cloud!