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 / Microsoft Dynamics GP (Archived) / What is the difference...
Microsoft Dynamics GP (Archived)

What is the difference between the Mangement Reporter Data Mart and Legacy on Dynamics GP

(0) ShareShare
ReportReport
Posted on by Abdo Khoury 14,855

Dear 

I installed and configured Management Reporter on Dynamics GP 2015 for both the Data Mart and the legacy and as a result i got 2 sets of companies in the client

what is the difference between the Data Mart and the Legacy and when do you use either 

appreciate your feedback

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Justin Sutton Profile Picture
    Justin Sutton on at

    Hello Patrick,

    The Data Mart and Legacy data integrations in MR differ in how they get your data from GP.

    The Data Mart integration has it's own database that it regularly updates after updates to the GP database. This is a separate database which has the benefit of being able to be separated from GP, meaning you have less performance issues at the time of report generation.

    The Legacy integration, however, pulls directly from the GP database. This has the benefit of being 100% up-to-date, however, this leads to performance issues at times. Please be aware that the Legacy integration is just that, legacy. Moving forward, I recommend users swap over to Data Mart.

    Overall, it is up to you to decide which to use. If you have a big company, then the Legacy reports are going to take almost hours to run. If you have a small company, either one is a good option.

    Please let me know if you have any additional questions on this.

    Justin Sutton

    ------------------------------------------------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------------------------------------------------

    **This posting is provided 'AS IS' with no warranties and confers no rights.**

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,855 on at

    Hello Justin

    So as a conclusion and if i understood your point of view, if i want to choose between the two, it is better for me to go with the data mart so that if in the future MS decide to stop supporting Legacy, i will be on the safe side

    and the data mart would be the best option to proceed

    Am i right ?

  • Suggested answer
    Justin Sutton Profile Picture
    Justin Sutton on at

    Hello Patrick,

    My recommendation will almost always be to use Data Mart as it is the integration we are always adding functionality to. For instance, Currency Translations work in Data Mart as it is a newer feature.

    One other issue I can think of is performance. Data Mart requires a much more powerful server than Legacy, so if cost is a factor, Legacy may be a good option.

    There are many different things that you may want to look into.

    You can find all of our printable documentation here:

    www.microsoft.com/.../details.aspx

    Please let me know if you have any additional questions on this.

    Justin Sutton

    ------------------------------------------------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------------------------------------------------

    **This posting is provided 'AS IS' with no warranties and confers no rights.**

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans