Integration of Project Server 2007 with Oracle Applications

[Sam]

Scenario

we have finance dept and HR dept and we have implemented EPM 2007 . now
management main consults with Budgeting and costing.

they dont want to again enter data about resource (standard rates,overtime
rates , fixed cost , cost/use) e.t.c

and want to integrate from HR dept and Finance Dept applications.and those
departments are using Oracle applications and in the oracle database this
data is
already exist of users.
I am adding users in project server 2007 manually and one by one . but not
synchronizing from active directory.

how i can integrate from these oracle applications of HR and Finanace Dept
and get data of those users which are already added in the project server
2007 Database.
what is the starting point to do this ?
tell me free resources for solving this or some free experts from which i
can ask with chat. and if code in vb.net which i can use for integration.
what is the best and easy way. because I am not a developer ? or any utility
is available.

kindly reply me in detail and hurry.

 

[Rod Gill]

Firstly AD simplifies things a lot. Secondly you have a series of issues to
resolve before even starting!~ Project data, financial data and HR data have
overlaps, but needs can be quite different. The differences can be enough to
significantly erode The value of your entire EPM system. For example:
Accounts are concerned about cash in and out of The bank account. For
example once a resource works 40h HR and accounts consider all hours above
that as "free". Project managers know that the cost of a project is all
hours regardless of whether or not the hours are above or below the 40h
mark. There are no free hours. If a resource does 5 extra hours, there is an
opportunity cost.

HR is also only worried about whether 40h have been done in the week or not.

HR also does not want the rates for each resource entered into a system that
has no security (anyone who can open project or view PWA will see resource
rates. You can prevent this in PWA but not Project. So, you will need to get
an average rate for each skill band and assign average rates (that include
employment overheads etc to further hide real salary levels.

next you may not want automated updates because you lose control over your
own EPM system. I'm also assuming here that every system uses the same
spelling for each resource (if you don't use AD this may not be true).

That scratches the surface. Integrating these types of systems is no easy
task. the physical integration is the easy bit, agreeing process and
workflow is where the work is.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Scenario

we have finance dept and HR dept and we have implemented EPM 2007 . now
management main consults with Budgeting and costing.

they dont want to again enter data about resource (standard rates,overtime
rates , fixed cost , cost/use) e.t.c

and want to integrate from HR dept and Finance Dept applications.and those
departments are using Oracle applications and in the oracle database this
data is
already exist of users.
I am adding users in project server 2007 manually and one by one . but not
synchronizing from active directory.

how i can integrate from these oracle applications of HR and Finanace Dept
and get data of those users which are already added in the project server
2007 Database.
what is the starting point to do this ?
tell me free resources for solving this or some free experts from which i
can ask with chat. and if code in vb.net which i can use for integration.
what is the best and easy way. because I am not a developer ? or any
utility
is available.

kindly reply me in detail and hurry.



__________ Information from ESET Smart Security, version of virus
signature database 4637 (20091125) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4637 (20091125) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Sam]

That's mean you are giving me suggestions that i will not try to integrate.
and alternatively write standard rates directly in the resource sheet.

is it possible that one person EPM Administrator which add resources in EPM
can specify standard rates and overtimes of all resources one time. and
whenever need to change arise of standard rates. then specify by EPM
administrator only.or is it possible that EPM administrator specify Cost Rate
table of all employees may be A,B.C,D. and if project manager try to change
the standard rates in cost rate table and in resource sheet then Project
professional deny for this.
if this scenario will be successfull then all responsibility to enter
standard rates and make cost rate tables of all employees of EPM
Administrator.

Waiting for reply.

Regards

SAM
MCP,MCTS,MCITP

 

[Rod Gill]

Only the Administrator (or anyone with edit Enterprise Resources
permissions) can set rates. In many countries there are legal ramifications
of displaying who is being paid what to everyone, to say nothing of "why are
they paid more than me?" arguments. That is why most sites get Accounts to
produce bands of costs that include admin overheads for all Resources. That
way you get effective rates for costing purposes and hide pay details for
individuals.


Project Manager can change rates in their own projects but next time they
open the project, rates will reset to same as Enterprise Global.
--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

That's mean you are giving me suggestions that i will not try to
integrate.
and alternatively write standard rates directly in the resource sheet.

is it possible that one person EPM Administrator which add resources in
EPM
can specify standard rates and overtimes of all resources one time. and
whenever need to change arise of standard rates. then specify by EPM
administrator only.or is it possible that EPM administrator specify Cost
Rate
table of all employees may be A,B.C,D. and if project manager try to
change
the standard rates in cost rate table and in resource sheet then Project
professional deny for this.
if this scenario will be successfull then all responsibility to enter
standard rates and make cost rate tables of all employees of EPM
Administrator.

Waiting for reply.

Regards

SAM
MCP,MCTS,MCITP



__________ Information from ESET Smart Security, version of virus
signature database 4650 (20091130) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4650 (20091130) __________

The message was checked by ESET Smart Security.

http://www.eset.com