none
What are the Benefits of Synchronizing/ Replicating Project Online with an on-Premise SQL Database RRS feed

  • Question

  • Hi

    What are some of the reasons and/ or benefits that one may want to consider with regards to setting up and synchronizing Project Online with a on-Premise SQL database ?



    \Spiro Theopoulos PMP, MCITP. Montreal, QC (Canada)

    Sunday, December 14, 2014 5:23 PM

Answers

  • Yes, AFAIK, you are still only allowed to query the Reporting tables (Since now it is just one database for project web app.

    Here is a blog post from Paul Mather, that covers the process in detail.

    http://pwmather.wordpress.com/2014/03/26/projectonline-data-via-odata-and-ssis-in-sql-database-table-on-premise-msproject-sharepointonline-bi-ssrs-office365-cloud/


    Cheers,

    Prasanna Adavi, Project MVP

    Blog:   Podcast:    Twitter:    LinkedIn:   

    Monday, December 15, 2014 3:48 AM
    Moderator

All replies

  • Hi Spiro,

    One word, reporting....


    Ben Howard [MVP] | web | blog | book | P2O

    Sunday, December 14, 2014 9:47 PM
  • Hi Ben Can you be a bit more specific please, because we have "reporting" with Project Online too.

    \Spiro Theopoulos PMP, MCITP. Montreal, QC (Canada)

    Monday, December 15, 2014 12:37 AM
  • Spiro,

    Reporting via Project Online is limited to OData, and writing queries with OData starts getting complex at a certain point.

    So, if your organization in using third party BI tools, or want to use OLAP cubes, or in general want to use straight SQL queries instead of oData, it is generally beneficial to have the data in house for reporting.

    So in general, using the SQL Synchronization, will bring data into "your" organization, as opposed to being with Microsoft so you get a LOT more flexibility with reporting.

    Hope this helps your question.


    Cheers,

    Prasanna Adavi, Project MVP

    Blog:   Podcast:    Twitter:    LinkedIn:   

    Monday, December 15, 2014 2:48 AM
    Moderator
  • May I presume that we are still limited to the Reporting database in terms of the data which can be synchronized? Ie only the Reporting DB is exposed in either case. Is this correct?

    \Spiro Theopoulos PMP, MCITP. Montreal, QC (Canada)

    Monday, December 15, 2014 3:02 AM
  • Yes, AFAIK, you are still only allowed to query the Reporting tables (Since now it is just one database for project web app.

    Here is a blog post from Paul Mather, that covers the process in detail.

    http://pwmather.wordpress.com/2014/03/26/projectonline-data-via-odata-and-ssis-in-sql-database-table-on-premise-msproject-sharepointonline-bi-ssrs-office365-cloud/


    Cheers,

    Prasanna Adavi, Project MVP

    Blog:   Podcast:    Twitter:    LinkedIn:   

    Monday, December 15, 2014 3:48 AM
    Moderator