The Reporting database (RDB) is the staging area for generating reports and OLAP cubes. Data in the Reporting database is comprehensive and is updated nearly in real time. The tables and views are optimized for read-only report generation; for example, the RDB tables are denormalized to provide redundant data and reduce the number of relational tables. As data is updated in real time in RDB, in case if you are considering extracting data from it to some other data store, consider reading how data gets to the RDB and Report Data Service. Schema documentation of the reporting database as well as the OLAP cubes is available and can be downloaded from Project 2010 Reference: Software Development Kit, in the documentation\schemas subdirectory.
- SSIS can be used to extract data from reporting database and merge this data into a corporate warehouse
- SSAS can be used to source and enhance cubes and OLAP database exposed by project server
- SSRS can be used to generate reports on the top of OLTP reporting database and cubes contained in OLAP database exposed by Project Server.