web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Crystal Reports for Dy...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Crystal Reports for Dynamic 365 F & O

(1) Share

Report

Report

Posted on by CU05090312-0

8

Our company design to use Dynamics 365 F&O (on clould)

when we go live, It is porsible to use CDATA ODBC Driver to the connect to D365 F&O production database (clould ver.) for using Crystal report ?

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Jonas "Jones&q... 5,017 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Direct connection to the D365 F&O (cloud) production database is a big no. That will never be possible.

You can certainly use CDATA to connect to F&O's ODATA interface, but that solution is only suitable if you need to consume data exposed via ODATA (E.G., no transactions). I assume you want transactions?

Depending on your requirements, you might be looking into implementing a data warehouse using something like this: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-view-in-fabric

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 543 Most Valuable Professional

#2

André Arnaud de Cal... 387 Super User 2026 Season 2

#3

CU-1234529-002 185

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans