Microsoft provides the software development kits for developers to learn the Microsoft Project 2007 platform. It includes the information about how to integrate and extend the Project Server 2007.
Microsoft Project update the data to the reporting database (RDB) whenever you publish the project. The update from the Microsoft Project to the reporting database is at a per project, ad hoc basis. You do not need to schedule a ETL process to run over night.
It provides 14 OLAP Cube for custom reporting. The data from the reporting database will be further pushed into the OLAP cube, the same architecture as their prior release.