SentryOne Document Feature: Lineage and Impact Analysis

 

Understand the origin of your data

With SentryOne Document, you can avoid wasting precious time trying to determine where data originates and how it’s being used. You can also easily evaluate the impact of changes to your systems before you make them. 

 

 

 

Track Data Lineage

Object Lineage in SentryOne Document

Track object lineage

Object Lineage allows you to answer the question “Where did this data come from?” A huge time-drain for all types of SQL developers and DBAs is tracing the source of data within a system. This component of SentryOne Document enables users to explore how data in one part of their environment is used in other parts. For example, if you need to determine where a certain field on your SSRS report comes from, you can use Object Lineage to trace that field back to a database, see the SSIS package that populated the column, and even trace that back to the source database. 

Object Lineage is both diagrammatic and interactive, allowing users to explore and drill down in their lineage model to view lineage details. This speeds up development by giving users the ability to view dependencies clearly and enables users to pinpoint the source of data in a report. 

Feature Highlights

  • Filter lineage links by dependency type, direction, and level. 
  • Drill down to the column or component-level 
  • Dramatically reduce the risk of change in your environment 

Simplify impact analysis

 

The SentryOne Document Impact Analysis component allows us to answer the question "What will be affected if I change this element of my environment?" This saves developers and DBAs countless hours trying to assess how a change to one part of their environment will impact others by enabling them to explore the dependencies in their environments.

Feature Highlights

  • Dependency tracing in both directions – what an object depends on and what objects depend on it
  • Evaluate impact for database objects, SSIS packages, SSAS dimensions and cubes, SSRS reports, Salesforce data, and Azure SQL Database / Datawarehouse objects.

impact-analysis

Impact Analysis in SentryOne Document

"MetaBank (MPS) documentation is always up-to-date, so it can be leveraged as a second line of defense for our processes."

— Ron Van Zanten, SVP of Data Systems, Meta Payment Systems

Download a Free SentryOne Document 30-Day Trial

Whether you choose the installed or cloud version of SentryOne Document, both of these options have the same features. 

 

Cloud Solution

Download Free Trial

Installed Solution

Download Free Trial

SentryOne Document Pricing Options

SentryOne Document is available in Essentials, Standard, and Premium editions through an annual subscription based on a 12-month term, paid in advance, with automatic renewal at the end of the term. 

SentryOne Document Essentials

SentryOne Document Standard

SentryOne Document Premium

$495/yr for 1 license

Buy

$795/yr for 1 license

Buy

$1,209/yr for 1 license

Buy

   

Contact us for volume-based discounts

$4,650/yr for 5 licenses

$8,799 for 10 licenses