PROBLEM : extract resource capacity data e.g. Resource A is a full time employee, I need to pull his monthly availablility in hours. This data can be any xml, txt etc format. It is needed for a downstream data warehouse application. What are my options for extracting this data? Web Services? ODBC/SQL call to the appropriate db tables - if anyone can point me to the right tables, that would be helpful (I am DB/SQL proficient).
Thanks for your help. My apologies for the delay, I just noticed your reply. I am new to this forum and getting to login has been a challenge.
To answer your question, we are on Version 8.X.
Can you elaborate on your suggestion solution? I can connect to the DB via MS Access (read only) and create the requisite SQL queries. Since this post 2 weeks ago, I have been able to figure the SQL to pull resource capacity (still need more testing). The question I still have in my mind is, is this the best way to get resource capacity and demand (from staffing profiles). Or is web services a better option (where I have no expertise, I am DB/SQL person).
Thank you for helping me out. Sorry for the delay, I am new to this forum.
I do not have a reporting solution, but want to pull (forecast) capacity & demand data from PPM. This data is needed for a downstream analytics package. So any help I can get to extract PPM data preferably using SQL would be best. I use MS Access to connect to PPM, but am flexible using another reporting tool. Eventually this may end up as a script/stored procedure or similar.
I am also trying to better understand what audit information is present in PPM. Specifically, I am looking usage stats (logins, type/frequency of updates/activity to update resource pools, resource info, staffing profiles etc. Kinda of usage heat map.