Search Project Server 2010 data using SharePoint BCS and FAST Search
Hello just published the following solution on MSDN Code Gallery: http://code.msdn.microsoft.com/PS2010Search (a good follow up to this solution I published in 2008 on CodePlex: Search Project Server data using MOSS' BDC and Enterprise Search - CodePlex Solution Starter)
The following project demonstrates how to setup Microsoft SharePoint 2010 Business Connectivity Services (BCS) and SharePoint 2010 FAST Search to query Project Server 2010's Project Project Web App (PWA) entities: Project, Task, and Resource. This code sample leverages the recently released 2010 Information Worker Demonstration and Evaluation Virtual Machine (RTM) as well as the Microsoft Project 2010 Demonstration and Evaluation Installation Pack. While the documentation explains how to configure search within that demo VM and dataset you could easily leverage this document to implement the same functionality in your own Project Server 2010 and SharePoint 2010 environment. If you have any questions or feedback please leverage MSDN Code Gallery to ask questions (“Discussions” tab).
Sample queries from this solution to wet your appetite (check out step by step document for more sample queries):
Project with the Project Health KPI set to Green:
Manually Scheduled tasks:
Resources belonging to the IT department: