Project Online DB ( synced with On premise SQL Server) RRS feed

  • Question

  • Hi,

    I know that we can sync the Project Online reporting DB with on premise SQL DB. But when we sync using SSIS with Odata connection can we replicate only the reporting data or can we replicate the entire reporting tables?

    Using Odata connection with the tables can be created in SQL Server ( Similar to the tables we select in Excel workbook using Odata connection).

    Can we replicate the entire reporting DB of Project Online [all REPORTING Tables alone] instead of replicating only the reporting data

    Please suggest.

    Tuesday, October 31, 2017 2:31 AM


  • Hello,

    You only have access to the OData API for reporting, you do not have direct access to the reporting schema in the database so can only replicate what is available in the OData API. There are other APIs in Project Online such as the REST API (_api/ProjectServer/) that does contain some data not available in the reporting schema.


    Paul Mather | Twitter | | CPS | MVP | Downloads

    • Marked as answer by Sudhir Ch Tuesday, October 31, 2017 2:50 PM
    Tuesday, October 31, 2017 9:17 AM

All replies