Switching from Data Mart to Legacy Provider

(0) Share

Report

Posted on by Community Member

Hello:

If there is such a thing, can someone please send to me step by step instructions on how to "change" Management Reporter from the Data Mart to the Legacy Provider?

Yes, I'm well aware that Microsoft is going to stop supporting the Legacy Provider. But, that date is not set in stone.

More importantly, the Data Mart is giving us erroneous results. We can't keep recreating it.

From what I understand, I'm not the only one "out there" who is having trouble with the Data Mart.

If I'm unable to get Management Reporter working for my company, I'm going to be fired. Please help!

John

*This post is locked for comments

I have the same question (0)

All responses (20)

Answers (1)

Richard Wheeler 75,850 Moderator on at

Like (0)

Report

Well let's hope it does not come down to that. I have never tried this but it might work. Can you try to export the building blocks, then disable the integration and delete the MR database and the DataMart and install the legacy provider and then import the building blocks? You could do a complete MR uninstall after exporting the building blocks and then a reinstall using the legacy provider and import the building blocks.

Was this reply helpful? Yes No
Verified answer

MattPaulen 6,912 on at

Like (5)

Report

You can have both connectors installed at the same time. When the legacy connector is installed, it will add a new set of companies for each of your GP databases and the naming will look like XXX-CURR. Then you'd just need to point your reports and trees to those -CURR companies. It's up to you if you want to then remove the datamart but you could essentially even set up two sets of reports, one for legacy and one for datamart if you wanted.

Was this reply helpful? Yes No
Lyn Barr 1 on at

Like (2)

Report

Matt's answer should work just fine, and is pretty simple & fast. I've done it many times.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Matt: You're a life-saver! I did exactly what you suggested and am getting accurate numbers!

Thank you, so much!

I hope that Microsoft doesn't discontinue use of the Data Mart any soon!

John

Was this reply helpful? Yes No
Lyn Barr 1 on at

Like (1)

Report

I really don't see how they can; the data mart is still too buggy at this point.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Whoops! I meant to say that I hope that Microsoft doesn't discontinue use of the Legacy Provider, anytime soon! And, hopefully--by the time they do--maybe the Data Mart will work.

Sorry, for the confusion. My mind hasn't worked well, since entering my mid-40s!

John

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Matt:

There's one thing that I forgot to ask you. Have you ever found yourself running reports on both the Data Mart and the Legacy Provider? In case anyone asks me, I just want to know what's the point--so to speak--of running reports against both.

Thanks, again!

John

Was this reply helpful? Yes No
MattPaulen 6,912 on at

Like (1)

Report

I've set it up in the past to have two sets of reports for a couple of customers so they can get comfortable that the Data Mart is actually working as it should be. But if you are having negative results with the Data Mart on a consistent basis, I'd suggest removing the integration because it can be pretty taxing on the server.

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,058 Moderator on at

Like (1)

Report

John,

I know this thread is quite a month old... but have you been able to do some performance validation for the report generation in Legacy Connector vs. DataMart connector ?

I'm not convinced by the benefits of the DM in MR 2012, unless you probably have a large amount of GP companies.. with only a dozen, I've not seen much differences when running consolidated reports.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Beat:

Although we are still vetting our initial reports, so far, the Legacy Provider has proved invaluable as compared to the Data Mart. We have never had any inaccuracies, since the switchover.

Thanks, for following up!

John

Was this reply helpful? Yes No