Online

Looking to sign up for Data Governor? Learn more here.

Successful Business Intelligence is all about the data!

Perspective Information Lifecycle Management suite features a unique set of management tools that leverage the full power of the Microsoft Business Intelligence Platform. Perspective provides your business user with friendly interfaces that allow uncomplicated access to information, so that it is easy to verify the accuracy and currency of data used for decision making.

You may have a number of ETL processes that run at various times to integrate your data from disparate Sources, into a single warehouse. To manage a few ETL packages may be achievable. However, when there are many, the task to control, maintain and schedule them becomes more arduous.

Data Governor empowers you to:

  • Provide transparency on the number of rows that have been loaded by each Task

  • Explicitly publish the currency of data to report consumers

  • Schedule dependant Jobs to run in sequence rather than guessing when each Job is due to complete

  • Quickly interrogate Task errors and Task duration

Our goal is to ensure that your Data Management Tasks are governed and achieved at the highest possible level, helping you get the most out of your Microsoft BI investment every step of the way.

The purpose of this user guide is to provide information to users on how to access and use the features of this tool. Detailed descriptions, step-by-step instructions, and examples are provided for a better understanding.

This is intended for the end users of Data Governor. Using this guide, they will get an understanding of the product and its related features.

The targeted audience of Data Governor can be broadly classified in two key areas:

  • ETL Developer - users that will configure the tool, define the steps for each of the Task Jobs and schedule the packages
  • DBA - users that monitor Data Governor logs and error reports to investigate potential package failures

Product Overview

Data Governor provides a central console to manage and audit data integration processes. It also provides visibility and control to ensure timely delivery of data for analysis and reporting. The process flow below provides a high level overview of how Data Governor features:

DGProcessFlow

Features

The core features of Data Governor can be summarized in the list below:

  • Central console to control all data integration processes
  • Flexible reordering of Job sequencing
  • Stores complete history of all ETL processes
  • Provision of alerts for failed Tasks
  • Reports on execution time and row statistics
  • Deploy Data Governor Tasks and Jobs between environments

Benefits

The key benefits of Data Governor include the following:

  • Eliminates the time required to build a logging framework for ETL processes
  • Simplifies the management of incremental processing to speed up data refreshes
  • Provides alerts of failed Tasks
  • Manages data processing dependencies
  • Automates reporting of Task execution time
  • Provides a complete auditable history of all ETL processes
  • Easily transfer Tasks and Jobs from a Development to Production environment