Recently we were trying out the preview feature of using SQL to query CDS data. Below are the steps à To get started, Download or open SQL Server Management Studio (18.4 or later) Use Azure Active Directory authentication to connect. Specify the organization address URL followed by port 5558 in the server name. If you … Continue reading “Setting up – Using SQL to query data in Dynamics…
Continue Reading Nishant Rana’s Article on their blog
Setting up – Using SQL to query data in Dynamics 365 (Preview)
Recently we were trying out the preview feature of using SQL to query CDS data. Below are the steps à To get started, Download or open SQL Server Management Studio (18.4 or later) Use Azure Active Directory authentication to connect. Specify the organization address URL followed by port 5558 in the server name.
Blog Syndicated with Nishant Rana’s Permission
More About This Author
Array
- Dyn365CE6 May 2024Fixed – The latitude or longitude for the User record associated with this resource is invalid – Dynamics 365 Field Service /Dataverse
- Dyn365CE30 April 2024Use Geolocation Settings for Location Tracking and Auditing – Dynamics 365 Field Service
- Dyn365CE29 April 2024Fix the trigger – Microsoft.OData.ODataException: A binary operator with incompatible types was detected. Found operand types ‘Edm.Guid’ and ‘Edm.String’ for operator kind ‘Equal’ (Power Automate / Dataverse)
- Dyn365CE23 April 2024Portal does not load and displays “Server Error” or shows “Getting set up.. This might take a while” message -Portal Startup Issue (PowerApps Portal)