Transcript Speech Title Here

Adding
Project Management Smarts
to Applications Using
Office Project Server 2007
Ameya Bhatawdekar
Program Manager, Project
Microsoft Corporation
Paul Holdaway
Consultant, Microsoft Consulting Services (UK)
Microsoft Corporation
Agenda
Programmability Features in Project Server 2007
Web Services API
(a.k.a “Project Server Interface” (PSI))
Server Side Events
Reporting Solutions
Project Server 2007 Platform
New Web Services API
Project Server Interface (PSI)
Server Scheduling Engine
Rich Reporting Platform
Deep Integration with Office Server
WSS is Platform Underlying Project Server
Extensible User Interface: Web Parts
Project: An Enterprise Solution
LOB:
ERP
CRM
Project Web Access
Project Professional
Services
Project Server
Scheduling
Task Assignment
Timesheet
Server Events
Resource Plans
Event/Notifications
Reporting
Queue Service
Data Warehouse
Budgeting
Security
Programmability Features
Web Service API – Project Server
Interface (PSI)
Server Side Events
Reporting Database
Server Scheduling Engine
Project Server UI: Web Parts / DHTML
Grid / ActiveX Grid
Continued Support for VBA in Project
2007 Professional
Project Server Interface (PSI)
Web Services API - PSI Replaces PDS
Extensive Data & Functionality Coverage
Over 300 Public Methods
Firewall-Friendly
Accessed via SOAP over HTTP
Data transfer via ADO.NET Datasets
PSI Web Services
Archive
Admin
Assignment
Calendar
CubeAdmin
ObjectLinkProvider
Project
QueueSystem
Resource
CustomFields
Event Handler
LookupTables
Notifications
ResourcePlans
Statusing
Timesheet
WSS Interop
How Does The PSI Work?
Client Applications
User accesses
PWA
1
4
2 PWA authenticates user
Context
passed to
PSI
5 PSI Runs
in the context
of the user
PSI
PWA
SOAP
3rd
party
apps
domain\user
PSI
Forwarder
Context
3 PWA generates
user context
DAL
Project
Pro
Business
Objects
PSI
Proxies
PSI
IE
Authentication
Working
Scheduling
Engine
Eventing
Service
Published
Version
Queueing
Service
Project Server 2007
- Project Server Interface (PSI)
PSI: Benefits
Easier to Develop
Intellisense
Strongly Typed
Type Safety
Better Exception Handling
Comprehensive Coverage
Leverage Existing .NET Skills
C#, VB.NET, ADO.NET
PSI: Datasets
ADO.NET 2.0 Typed Datasets
Primary Data Transfer Agents
Business Entities  Typed DataSet
Benefits:
Relational Programming Model
Access Columns, Tables by Name
Type Safe
“Serializable” to Binary / XML Format
Disconnected Operations
Performance Gains
Project Server 2007
- Working with Datasets
Project: Server Side Events
New in Project Server 2007
No More SQL Triggers!
Extend & Customize Business Logic
Integration with LOB Systems
Participate in Workflows
Server Events Architecture
Events Process
PWA
PWA
PWA
PSI
Event
Event Event
HandlerHandler Handler
Event
Event Event
HandlerHandler Handler
Eventing
Service
Business
Objects
Business
Objects
Process boundary
PSI
Business
Objects
Event
Event Event
HandlerHandler Handler
Event
Event Event
HandlerHandler Handler
Event
Event Event
HandlerHandler Handler
Config
DB
Event
Event Event
HandlerHandler Handler
Event
Event Event
HandlerHandler Handler
Project: Event Types
Pre & Post Events
Pre Events
Before Data is Saved to Database
Cancel-able
Synchronous
Post Events
After Data Has Been Saved to Database
Not cancel-able
Asynchronous or Synchronous
Project: Event Handlers
Implemented as Managed Code
.NET Framework 2.0
Event Handlers Must Be Deployed to Each
Middle-Tier System in server-Farm
Event Handlers Must be Strongly Signed
(Security Requirement)
Support for Multiple Event Handlers for an
Event
Capability to Specify Execution Order
Authoring Event Handlers
Events Handler Classes Must Derive from
Respective EventReceiver Class
Override Method for Specific Event
Deploy Event Handler to Server
Register Event Handler
Project Server 2007
- Working with Server Events
Project: Reporting
New for 2007: Reporting Store
Near-Real-Time Updates
Trickle-Feed from Publishing Store
Optimized for Reporting Application
Full Documentation Support
OLAP Store for Analytics
Extensible…
Project: Server Data Movement
Publish
Draft
Report
Published
Reporting
Archive
Archive Project
Archive Metadata
Project: Reporting Infrastructure
Dedicated Reporting Database
Offers Pre-defined Views for User
Consumption
Collection of Cubes & Building Services
Out-of-the-Box
11 Cubes & 3 Virtual Cubes
Customization Support Offered Directly
from Project Web Access (PWA)
Data Layered in 3 Core Schemas
EPM, Timesheet & Collaboration (WSS) Data
Project: OLAP Cubes
EPM
Project Non Timephased
Assignment Non Timephased
Task Non Timephased
Resource Non Timephased
Assignment Timephased
Resource Timephased
WSS
Timesheet
Timesheet
EPM Timesheet
Project
OLAP
Database
Risks
Issues
Deliverables
Project Server 2007
- Building Project Server Reports
Extending Project Reporting
Requirement for Reports that Include
External Data Source(s) in Addition to
Project Data
Use Project Data with Other Business Metrics
in a Single Report
Need Cross-Project Data & Project Web
Access (PWA) Display
Reporting Programmability
Extensive Collection of PSIs
Reporting Database
Manage Data Transformation
Add External Data to Project
Cube-Building Services
Read Cubes’ Settings
Read Server & Database Status
Update Dimension, Measure & Calculated
Measure Definition
Events
for Project Enterprise Reporting
Pre & Post Events
Reporting Data Structure (RDS) Events
Cube Building Services (CBS) Events
Enables You to Know When (Before & After) Data
is “Transformed”
Data Coherency Considerations
Data Cache Management Should be Carried Out by
You…
Latency Considerations
Reporting Data Structure is Multi-Server / MultiThreaded
Summary
Project Server 2007 – Powerful Work &
Resource Management System
Rich Programmability & Extensibility Features
Project Server Interface (PSI)
New Web Service API
Extensive Data & Functionality Coverage
Server Events
Extend Server Functionality via Events
Rich & Extensible Reporting
Additional Resources
Office (Beta 2) Downloads Available
http://www.microsoft.com/office/preview/
Project 2007 SDK Available
http://www.msdn.com/project/
Project Team Blog
http://blogs.msdn.com/project/
Office Online Updates
Coming Soon…