CRM Software Logo

Microsoft Dynamics 365 & Dynamics CRM experts provide reviews and opinions to aid professionals with the Dynamics 365 selection process.

 
 
WebSan Solutions Inc.

Retrieving Data in Microsoft Dynamics CRM

Email | Print

MS Dynamics CRM vs Salesforce    Sign 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.

Comments are closed.

 

 
 
Show Buttons
Hide Buttons