Reporting Database - HowTo integrate additional WSS-Lists (beside Issues,Risks,Deliverables) RRS feed

  • Question

  • The out of the box list items that consist the Risk and Issues registers are available in the Reporting Database MSP_WSSIssue / MSP_WSSRisk and MSP_WSSIssue_OlapView / MSP_WSSRisk_OlapView.

    I want to extend the "Project team site" template with additional lists and dump the content of this lists also to the reporting database as separate tables..

    anyone tried this before and can give me some starting points?:
    - How and when are the default-WSS-lists extracted/synchroniced between sharepoint>MSSQL?
    - Is there some way to register additional WSS-lists to the DB-update process?

    My current plan would be to either dump the WSS-List content via SSIS-Packages to SQL-Tables on a regular schedule or query the list-content directly via SSRS (without dumping before to SQLDB)

    Wednesday, January 19, 2011 10:31 AM