Database Mapper Feature: Lineage and Impact Analysis

 

Understand the origin of your data

With SolarWinds Database Mapper, 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.

 

 

Database Mapper Data Lineage Analysis

Object Lineage in Database Mapper

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 Database Mapper 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 Database Mapper 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 Database Mapper

"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 Database Mapper 14-Day Trial

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

 

Cloud Solution

Download Free Trial

Installed Solution

Download Free Trial

Database Mapper Pricing Options

Database Mapper 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.

Database Mapper Essentials

Database Mapper Standard

Database Mapper Premium

$495/yr for 1 license

$795/yr for 1 license

$1,209/yr for 1 license

   

Contact us for volume-based discounts

$4,650/yr for 5 licenses

$8,799 for 10 licenses