Datamart design considerationfor Project Online Historical Data RRS feed

  • Question

  • As you may know, PO doesn't have any capacity to save snapshots of current data, meaning that if you want to compare this Month capacity, project completion, or timesheet status to last month, you are out of luck.

    I always thought about pulling a weekly data dump into SQL azure and store the data. Of course it sounds simple on paper, but I wanted to see if anyone has tested this and what issues have they seen (latency, data corruption, oData issues) etc.

    Thanks again for your input.


    Thursday, February 23, 2017 11:20 PM


All replies