Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com
A compact and quick insight into how you can query CDS database using C#
Recently Microsoft has released new product feature where we can directly connect to SQL and write query into CSD Database. Currently this is in preview and not recommended for Product environment.
This feature will only allow you to perform Read only operations, it does not allow to perfrom DDL statement.
To check if you CRM instance is eligible for this new feature navigate to make.powerapp.com and select environment at top right corner. Select Data->Entity->Check if you see Analyze in Power BI ribbon button on top. If it is available then your CRM instance is eligible for this feature.
To Connect to CDS Database update below settings to your CRM instance
Navigate to https://admin.powerplatform.microsoft.com/->Select your environment->Click on Settings->Products->Features and enable TDS (Tabular Data Stream) then click on Save.
Steps to connect to CDS Database from SSMS V18.5
To connect to CDS DB using SSMS, you need to have SSMS V18+ installed…
View original post 134 more words
Debajit's Dynamic CRM Blog 