web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Connect D365 FO with S...
Finance | Project Operations, Human Resources, ...
Answered

Connect D365 FO with Sql Database

(0) ShareShare
ReportReport
Posted on by vicky1234 66

Hi,

Is there a way to connect D365 FO with Management reporter database.

I have used the standard codes but it does not gets connected with the database.

Is it that we have a different way to connect to Sql database in D365 FO.

Thanks,

VM

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

    Hi Vicky,

    Can you tell what exactly you want to accomplish with a direct connection to a database?

  • vicky1234 Profile Picture
    vicky1234 66 on at

    I want to run a query via the code in MR database and save the results in Axdb tables.

    And the query is a bit complicated

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

    Hi Vicky,

    All information in the MR database comes from F&O. So, you have the requirement to get data back in F&O which is already stored in F&O? What is the exact business requirement?

  • vicky1234 Profile Picture
    vicky1234 66 on at

    Hi Andre,

    thanks fore replying,

    The requirement is that the client wants to fetch data from some tables of MR database and with some logic push the data in D365 tables .

    this custom D365 table will be used by 3rd party for reporting purpose.

    It will be a batch job that will run EOD.

    Also one more question is that whether we have the database names same as we have in Dev environment or is it different ? I will ask this in a separate question but just in case you know.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

    Hi Vicky,

    Can you be specific about which information should be pulled from the MR database? You can't access it directly, so I would like to think with you what information to retrieve. As mentioned, MR information is retrieved from F&O, so there should be a way to get all information gathered from F&O and put it in your custom table. MR is just storing and aggregating it in a different way to support also other Dynamics solutions.

  • vicky1234 Profile Picture
    vicky1234 66 on at

    Thanks once Again Andre.

    The requirement is to join the dimension tables of AX with tables of MR eg. MR is having tables like Reporting.ControlRowMaster ,Reporting.ControlRowCriteria . Reporting is the schema of this tables.

    So it will be like for example MainAccount join Reporting.ControlRowCriteria where MainAccount .fieldA == ControlRowCriteria .fieldB and the data of this query is pushed to a custom table ABC.

    This table will be further used by other applications eg. data lake.

    I checked in D365 but somehow i did not find any reference to  MR tables like ControlRowCriteria ,ControlRowMaster ,ControlRowDetail in Visual studio.

    If I get the data of these 3 tables in AX then I don't need to connect to MR databases.

    Also does these tables store any transaction data , or its just that they store the MR report design data and the data changes only when the MR report design is changed.

    If I get the data then the problem is resolved :)

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

    Hi Vicky,

    So, you would like to have some reporting setup also exported. Unfortunately, there is no option to do this. You can export the report blocks, but that is in an unreadable file format. You can't connect the MR database. The MR service is retrieving transactional data from F&O. The report designs are created using a designer app which directly connects to the MR database storage.

  • vicky1234 Profile Picture
    vicky1234 66 on at

    Thanks Andre for the reply.

    Just one thing I would like to understand , since I have access to the dev environment MR tables. I would like to understand whether the data in these 3 tables (ControlRowCriteria ,ControlRowMaster ,ControlRowDetail)  is static or it keeps on changing .

    I mean if the MR database is having only reporting setups in this tables then this should be static and would change only if the MR report design is changed.

    However I am not sure if this will help me in exporting to the prod envt , however just an idea.

    Is there any other solution that you suggest  ?

    Thanks,

    VK

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

    Hi Vicky,

    I think the contents in these tables will only change when you change the report setup. I haven't paid attention to these tables. I did some troubleshooting on the data mart integration before.

    If the reports are designed in a development environment first, you can export the contents of these tables and see if you can use this as input for your 3rd party service. Not ideal, but might work.

  • vicky1234 Profile Picture
    vicky1234 66 on at

    Thanks Andre

    I suggested the same initially however I am not sure on the structures of MR tables and designs so thought of checking.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans