Book Image

Microsoft System Center 2016 Service Manager Cookbook - Second Edition

By : Steve Buchanan, Steve Beaumont, Anders Asp, Dieter Gasser, Andreas Baumgarten
Book Image

Microsoft System Center 2016 Service Manager Cookbook - Second Edition

By: Steve Buchanan, Steve Beaumont, Anders Asp, Dieter Gasser, Andreas Baumgarten

Overview of this book

Keep your organization up to speed with the Microsoft System Center 2016 Service Manager Cookbook. Over 100 practical recipes for SCSM 2016 give you all the tools to master IT service management.
Table of Contents (23 chapters)
Microsoft System Center 2016 Service Manager Cookbook - Second Edition
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Customer Feedback
Preface

Introduction


Service Manager periodically transfers data that is stored in the operational database to the Service Manager Data Warehouse databases through a process called Extract Transform and Load (ETL). The processes required for keeping the data in the Data Warehouse in sync with the operational database are controlled by the Service Manager Data Warehouse Management Server role.

The ETL process is started on a scheduled interval. The first step is the extract workflow, which reads new data from the operational database and writes it to the DWStagingAndConfig database. The raw data is then picked up by the transform workflow, which does any reformatting required for bringing the data into the final format optimized for reporting prior to storing it in the DWRepository database. The load workflow then transfers the data to the DWDataMart database where it can be used for reporting.

The reasons for transferring data to the databases of the Service Manager Data Warehouse are the following...