Contact us today: (866) 4-WEBSAN (932726)

Wednesday, 03 August 2016 00:00

Retrieving Data in Microsoft Dynamics CRM

Written by

MS Dynamics CRM vs SalesforceSign up for a free CRM course!Learn more about CRM's features

Retrieving data and metadata for reports In Microsoft Dynamics CRM can be done using SQL views. In Dynamics CRM, users can run queries on SQL views that are automatically created. As the image below shows, names within the SQL views are easy to identify. A Microsoft tip sheet notes that SQL-based reports in Dynamics CRM use the filtered views provided for each entity to retrieve data for the reports. 

CRM Database Table Listing- 1

To obtain the query, users can download the SQL Server Management Studio (SSMS) online. 

Apart from being automatically created, Filtered Views offer the benefit of being updated for custom entities, having security embedded in the view, and being supported after patches, service releases and upgrades.

To learn more about how WebSan Solutions can support your Dynamics CRM projects and implementation, visit our Solutions page or contact us

Linz Tan, Web Marketing Assistant, WebSan Solutions Inc. a 2014 Ontario Business Achievement Award Winner for Service Excellence.

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.