none
T-SQL Access to Project Server 2010+ Reporting Database RRS feed

  • Question

  • Hi,

    I haven't worked with MS Project Server 2010 before, but I'm very familar with SQL Server and T-SQL.  We may have a project with a client that requires transfer of data from MS Project Server to other 3rd party systems.

    I was wondering if it possible to create a connection to the  Project Server 2010 reporting database (via VBA, .NET, etc) and run T-SQL commands against it in order to extract read only datasets for integration purposes.  Note that the code would be executed in an external application. I suspect it is but can't find a resource that explains that clearly.

    Any help appreciated.

    Tim M


    • Edited by TeamTech Friday, March 22, 2013 8:25 AM
    Friday, March 22, 2013 8:22 AM

Answers

  • The downloadable Project SDK has a full schema for the reporting database. You can use any of the usual tools for accessing teh reporting db. The reporting db is only updated after Project professional users publish their projects. If you want to access the latest schedule data you need to use the PSI interface. Get started with sample code in the Project SDK.

    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

    • Marked as answer by TeamTech Monday, March 25, 2013 12:44 AM
    Friday, March 22, 2013 8:50 AM
    Moderator

All replies