locked
Extract data trough from EPM RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Everybody,

    I am wondering if there is a standard in EPM to export data from the database (like the hours worked).

    Is there a service for that in EPM, or is the sharepoint business connectivity services usable for this feature?

    It should work like a kind a Enterprise Service Bus, but there is no Bizztalk available..

    Data should be exported from EPM and picked up by Oracle or a other platform.

    Thanks,

    Pete

    Monday, January 23, 2012 9:02 AM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Project Server has a dedicated reporting database that pretty much all the data you enter within the system and can be queried directly to retrieve the info you may be after. Unlike SharePoint, access to this query this database is fully supported, so BCS is probably not needed. The schema for the DB is published and available in the Project Server 2010 sDK (http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=15511)

    Hope this helps,

     

    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Monday, January 23, 2012 10:25 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I agree with Alex solution.  I wanted to add that Reporting services can extract the data and format into many common formats that other applications can use just as XML and that could be dropped into BizTalk.   Use SSIS if this needs to be an automated process.

    Cheers!

    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA, MCC 2011
    www.WhartonComputer.com
    Monday, January 23, 2012 1:55 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Would like to add a bit more, there are different Views available, specially in the reporting database with the name xxxx_UserView, where xxx can be Timesheet, Project, Resource and so on. Hope that helps you.

     

    Thanks, Kashif
    Monday, January 23, 2012 6:56 PM