Data integration architecture

更新: 2009-04-30

This topic provides a brief architectural overview of data integration.


Data integration architecture has several layers. The following illustration shows roles and relationships between the source data and clients that use 规划服务器. The mission for data integration is to move data into the application database. After data is in the application database, clients will use that data. The illustration is followed with a description of related parts.


This illustration is an excerpt from The Rational Guide to Monitoring and Analyzing with Microsoft Office PerformancePoint Server 2007, by Nick Barclay and Adrian Downes, and is property of Mann Publishing Group (978-1-932577-41-9), copyright November 2007, all rights reserved. No part of this chapter may be reproduced, stored in a retrieval system, or transmitted in any form or by any means—electronic, electrostatic, mechanical, photocopying, recording, or otherwise—without the prior written permission of the publisher, except in the case of brief quotations embodied in critical articles or reviews.

Data Sources

Data sources are stored as part of the business data of an organization. The data may come from the operational systems of the organization. Because operational systems contain raw data that is generally not in an appropriate format for analysis, you must first load data into a staging database. Then you can load it into the application database.


The process for bringing data from other sources into the staging database is a manual process that is not supported by 规划服务器.

PerformancePoint Planning Server Application Store

规划服务器 installs its own databases to contain the metadata for models and dimensions, and the system operations. It contains data structures for dimensions, hierarchies, and models that you can use for analysis and planning.

Staging Database

The staging database is a separate data cache (storage area) that allows business users of PerformancePoint Excel 加载项 to have continued access to application data. They have access even when data is being imported from various external sources and prepared for loading.

Data Integration

Data integration in 规划服务器 is the process of loading reference and fact data from the staging database into the application database. This process is more thoroughly described in Data integration process.


Clients that use the 规划服务器 application store include applications such as the following:

  • 规划业务建模器

  • PerformancePoint Excel 加载项

  • 监控服务器

  • SQL Server Reporting Services

These clients contribute to a complete Performance Management (PM) application and include the capability for business scorecarding, analytics, and planning.

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable content for PerformancePoint Planning Server.