Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
We have a desktop application, It is not a web-based application and we can not call OData/Rest on that.But we need order data of the crm from that application.I know the CRM have FilteredViews, and also views.Can I query them and use their data?Or create new View in the CRM Database?
If yes How can I give access to FilteredView or View so the that desktop application can access CRM Data.Or any other solution?
Modifying CRM SQL Database is not supported and I would not recommend creating any new views.
You could use filtered views to get the data you want and filtered view applies CRM security model, meaning the app user AD account should be a CRM user.
What the filtered view does is when someone access data using them, it uses the AD sam account name to get user id from the systemuser table and then checks if the user is allowed to access particular entity. As long as you give all the permissions necessary for that user in CRM, it should allow them to access the data
Note: Your application connection to SQL should be using Windows Authentication and it should use the integrated security so that current users AD account can be detected by filtered views.
Business Applications communities