Finance | Project Operations, Human Resources, ...

How to fetch data using SQL query from f & o d365

(0) Share

Report

Posted on by Binatrivedi

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?

I have the same question (0)

All responses (2)

Answers (0)

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

nunomaia 25 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No