Database Mapper Lineage

Update: SentryOne Document is now SolarWinds Database Mapper (DMR). See the Database Mapper product page to learn more about features and licensing. Want to explore Database Mapper? An interactive demo environment is available without any signup requirements.

 This feature is not available with Essentials or Standard licensing. If you'd like to use this feature, please visit our product pricing page to learn more.

Database Mapper Lineage


Database Mapper Lineage

The Database Mapper Lineage feature allows you to discover where data originates and where it gets used. It simplifies the process of tracing the lineage and impact of data within a system by enabling you to explore the dependencies in your environment. 

Feature Highlights

  • Diagrammatic and interactive form saves time
  • Speeds up development by allowing you to view dependencies clearly
  • Enables you to pinpoint the source of data in objects
  • Allows business analysts to make clear judgments about the correctness of data
  • Enables you to identify areas where errors may be introduced

Note:  A snapshot must be taken before Lineage allows you to view the dependencies for a solution.

Using Database Mapper Lineage

After creating a solution using the Database Mapper configuration tool, and taking a snapshot, you can view the lineage for your solution. Complete one of the following steps to open Database Mapper Lineage:

Select the Database Mapper Lineage buttonon the Database Mapper Solutions Dashboard to open Lineage Analysis for your solution.

Select the Lineage tab to open Lineage Analysis, then select a solution from the drop-down list. 

Database Mapper select the Lineage tab
Select Lineage tab

Database Mapper Lineage select Solution
Select Solution
Database Mapper Lineage Solution selected
Selected Solution

Navigating Database Mapper Lineage

Database Mapper Lineage Toolbar

In Database Mapper Lineage, the view diagram panel takes up a majority of the window. All the settings selected with the Lineage toolbar apply to the currently selected object within the Solution Explorer to create a visual representation of the object's lineage. The following table describes the buttons and settings within the Lineage toolbar:

Toolbar buttonDescription
Database Mapper Select Solution Lineage toolbar buttonUse the Solution drop-down list to select the solution you want to display lineage.
Database Mapper Manage Aliases Lineage toolbar buttonThe Manage Aliases button opens the Manage Solution Aliases window and  allows you to clarify the location of implicit items for this solution.

Note:  After aliases have changed, Database Mapper requires a snapshot of the solution in to refresh the dependency links within lineage analysis. For more information about solution aliases, see the Database Mapper Solution Aliases article.
Database Mapper Granularity Detail Lineage toolbar buttonThe Granularity Detail drop-down allows you to adjust the granularity of the objects that are included within the current session of lineage analysis. The following options are available:
  • High Detail:  Allows you to see down to the column, measure, and attribute level of lineage.
  • Medium Detail:  Allows you to see down to the table, component, SSRS item, KPI, and measure group level of lineage.
  • Low Detail:  Allows you to only see the database, package, and report level of lineage.
Database Mapper Reset View Lineage toolbar buttonThe Reset View button allows you to refresh the lineage data from the Database Mapper database.
Database Mapper Legend Lineage toolbar button The Legend button allows you to toggle viewing of the legend.
The Text View switch allows you to toggle viewing the lineage in a textual or graphical representation. For a large and complex graph, this text option can help you make sense of the inbound and outbound dependencies.

Example with Environment Map lineage:
Text view
Graph view

Database Mapper Dependency Direction Lineage toolbar buttonThe Dependency Direction drop-down allows you to select the direction types of the dependencies you want to include within the current session of Lineage Analysis. An object's dependencies are typically created when an object is included within another object's definition. The following options are available:
  • Bi-directional:  Both inbound (lineage) and outbound (impact) dependencies are included within the current session.
  • Inbound Only:  Only relationships that an object depends on are included within the current session.
  • Outbound Only:  Only relationships that are impacted by objects are included within the current session.
Database Mapper Track Selection Lineage toolbar buttonThe Track Selection button allows you to disable the feature that causes the diagram to re-draw every time a new selection is made within the Solution Explorer.
Database Mapper Dependency Levels Lineage toolbar buttonThe Dependency Levels drop-down allows you to increase or decrease the number of levels of separation from the currently focused object to display within the Lineage Diagram.

Important:  Including too many dependency levels within the Lineage Diagram may cause difficulty in reading it.
Database Mapper Filter by key Lineage toolbar buttonThe Filter by Link Type button allows you to toggle the visibility of relationships. The key filter toggles the visibility of relationship links that involve the use of foreign keys.
Database Mapper Filter by object Lineage toolbar buttonThe object filter button allows you to toggle the visibility of relationship links that involve object dependencies.
Database Mapper Filter by Data Lineage toolbar buttonThe data lineage filter button allows you to toggle the visibility of relationship links that involve the impact or dependency of another object's data.
Database Mapper Lineage Filter Toolbar button Select the Filter button to open the Technology Filter menu. Select the desired filter options and then select Apply to apply the filter to your lineage graph.

Solution Explorer 

The Solution Explorer contains a hierarchically organized tree of all objects within the current detail level that contain lineage. Select an object with Track Selection enabled to re-draw the focus of the lineage diagram to the newly selected object within the Solution Explorer.Database Mapper Lineage Solution Explorer selection with Track Selection active

Select to expand and collapse selected objects and display the object's children. 

Database Mapper Lineage Solution Explorer Expand object
Expand Object

Database Mapper Lineage Solution Explorer Object expanded
Object Expanded

Note:  If an object does not have a in the Solution Explorer, the object does not have any child objects that contain lineage, or the current detail level prevents it from expanding further.Database Mapper Lineage Solution Explorer Object fully expanded

Searching the Solution Explorer

Search the current solution for the exact object you want to view lineage for with the Search bar. Enter what you want to search for, then select Search to display the results.Database Mapper Lineage Solution Explorer Search bar

Select an object from the search results to display the corresponding lineage graph.Database Mapper Lineage select object from Search results

Select Back to explorer view to return to the previous Solution Explorer view.

Note:  Your Search Results will vary based on the Granularity Detail level you have selected.

Lineage Graph Views

The icons and colors within the diagram help you to quickly identify the object, and technology types associated with each node.  The following legend displays in the Solution Explorer when you select Show Legend:  Database Mapper Lineage Technology Legend

Hover over an object in the graph to display a tool-tip about the object. Database Mapper Lineage hover over object to display tooltip

Hover over inbound or outbound dependency routes to display a tool-tip about the route path.Database Mapper Lineage hover over route to display tooltip

Lineage Graph Route Legend

Line ColorDescription
BlueBlue lines indicate an object reference.
GreenGreen lines indicate data lineage.
BlackBlack lines indicate a Foreign key reference.
PurplePurple lines indicate references from multiple categories (Foreign key, object, data lineage).

Lineage Graph Context Menu Options

OptionDescription
Extend ItemDisplays more dependency levels for the currently selected object.
Database Mapper Lineage Extend ItemDatabase Mapper Lineage Object depdencies extended
Focus on thisSelect Focus on this to re-draw the diagram with the currently selected object as the main focus.
Database Mapper Lineage Focus On thisDatabase Mapper Lineage Focused object graph
View MetadataOpens the DDL script for the selected object. Database Mapper Lineage Metadata DDL Script window
Jump to documentationOpens the documentation view for the selected object.
Database Mapper Lineage Jump to documentationDatabase Mapper Documentation from Lineage selection
View Data DictionaryOpens the Data Dictionary window for the selected Lineage object. Select Edit to makes changes to your Data Dictionary Values.

Note:  You can only edit documentation values that have Data Dictionary configured.
Database Mapper Lineage View Data Dictionary Context menu optionDatabase Mapper Lineage Data Dictionary window

Granularity Detail Views

Select an object in the Solution Explorer to display the lineage diagram for the object. The following detail levels are available:

Granularity Detail Graph Example
LowDatabase Mapper Lineage Low Detail Level
MediumDatabase Mapper Lineage Medium Detail Level
HighDatabase Mapper Lineage High Detail Level

Dependency Level Views

Select an object in the Solution Explorer to display the lineage diagram for the object. Dependencies display based on the selected dependency level view. The following dependency level views are available:

Dependency LevelGraph Example
1Database Mapper Lineage 1 Dependency level
2Database Mapper Lineage 2 Dependency levels
3Database Mapper Lineage 3 Dependency Levels

Dependency Directions

DirectionImage
Bi-directionalDatabase Mapper Linage Bi-directional
Inbound OnlyDatabase Mapper Lineage Inbound Only
Outbound OnlyDatabase Mapper Lineage Outbound Only

Moving the Lineage Graph

You can adjust the view of the Lineage graph by doing one of the following:

MovementDescriptionExample
Moving a NodeLeft-clicking on a node and then dragging the mouse allows you to move a single node around the diagram without affecting the other nodes.Database Mapper Lineage Moving a Node
PanningLeft clicking on the view diagram allows you to pan the lineage diagram and adjust the visual if it does not all fit within the screen.Database Mapper Lineage Panning graph
ZoomingUse the mouse wheel to zoom in and out to see more details within the diagram.Database Mapper Lineage Zooming In on graph