none
how to use user profile data in project server 2013? RRS feed

  • Question

  • hi,

    I've recently configured user profile  service application on the share point farm. now I was wondering how I can use user profile data ,which are stored in a different database,  in my project server reports.

    I have some data such as employee ID and skills in user profile database which can be used in project sever reports.

    there is userID in profile database, while there is resourseUID in project sever database. how can I join them?

    Wednesday, July 1, 2015 6:19 AM

All replies

  • Sam,

       While there is a user profile database - I don't think its a supported activity to JOIN it into your reporting database queries.  If I had this requirement I would look into creating a SQL SSIS package to extract the information via the user profile REST interface https://msdn.microsoft.com/EN-US/library/office/dn790354.aspx#bk_UserProfile 

    Not easy - and it may not be the most effective way to get the data if it is sourced elsewhere.

    Good luck.

    J.


    James Boman BSc. MCP:EAD -

    Thursday, July 2, 2015 2:08 AM