Notifications
Announcements
No record found.
The Data Which we create in Asset Management Module in Finance & Operations d365, Where this data is getting Stored in backend and How can we fetch this data using SQL Query?
You shouldn't access the database directly and it's typically impossible, because Microsoft won't give you access to DBs of production environments they host. If you need that, then your solution can't be implemented and you must look for another way how to deal with your business requirements. Depending on what you need, you may want to data export, web services, export to Azure Data Lake and so on.
You can only make SQL queries to D356 in non-production environments.
For production, you can enable for example BYOD or Data Lake.
I prefer Data Lake, since we had some performance issues with BYOD in large tables.
You can make SQL queries against Data Lake using Azure Synapse.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 451 Most Valuable Professional
André Arnaud de Cal... 428 Super User 2025 Season 2
BillurSamdancioglu 239 Most Valuable Professional