Extension to reporting database.

[rohit barde]

Hi All,
I have to add some fileds to reporting database from published database.
could anyone tell me what steps i should follow for this. if any document
is availabe it will be very helpful.

 

[Stephen Sanderlin]

Without any detail on what kind of things you want written into the RDB,
it's impossible for me to give you any sort of specific guidance.



The method you use to extend the RDB depends on your requirements. For
example, you can leverage the RDB events
(http://msdn.microsoft.com/en-us/library/aa494918.aspx) or create a
Windows service to retrieve the information from the PSI and insert it
into the reporting database.



The Project Programmability blog also has an excellent sample RDB
extension at
http://blogs.msdn.com/project_progr...tensions-local-custom-fields-custom-code.aspx.


--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com

 

[rohit barde]

Hi Stephen,
I want to add few fields in reporting database tables from published database.
thease fileds are not in reporting DB but are their in published DB