Cross System Lineage

Cross System Lineage is a feature or capability provided by Octopai, a data management and metadata management platform. Octopai is designed to help organizations understand, govern, and optimize their data assets across various systems and platforms.

Cross System Lineage specifically focuses on tracking and visualizing the flow of data across different systems within an organization. It provides a comprehensive view of how data moves from its source to its destination, traversing through multiple systems, applications, and processes.

With Cross System Lineage, Octopai enables users to gain insights into the end-to-end data lineage, regardless of the complexity of the data ecosystem. It allows users to trace the data path across systems such as databases, data warehouses, data lakes, ETL (Extract, Transform, Load) processes, BI (Business Intelligence) tools, and more.

The key benefits of Cross System Lineage include

1. Understanding data flow: Users can track the flow of data from its origin to its final destination, providing a clear understanding of how data is transformed and used throughout the organization.
2. Impact analysis: Cross System Lineage helps users identify the impact of changes or issues in one system on downstream systems. It allows organizations to assess the potential consequences of modifications, ensuring data integrity and minimizing risks.
3. Compliance and governance: By providing visibility into the movement of data across systems, Octopai's Cross System Lineage assists in meeting compliance requirements and data governance initiatives. It helps organizations maintain data lineage documentation and ensure data accuracy, privacy, and security.
4. Troubleshooting and root cause analysis: When data-related issues occur, Cross System Lineage aids in identifying the root causes and troubleshooting effectively. It enables users to pinpoint where problems arise within the data flow and take appropriate actions to resolve them.

Overall, Cross System Lineage offered by Octopai enhances data understanding, enables efficient data management, and facilitates informed decision-making across complex data landscapes by visualizing the end-to-end flow of data across systems.

V - View |  SY - Synonym |  DIM - Dimension  |  P - Procedure  |  T - Table  |  FN - Function  |  MG - Measure Group  |  TT - Tabular Table  |  SP - Store Procedure  |  MV - Materialized View  |  M - Measure  |  DS - Dataset  |  UNK - Unknown

 

Cross System Lineage Functionalities over each object

Clicking on each Data Object Bubble will show a Radial button:

1. Hop to Inner View - Internal Lineage View of the component
2. Lineage Expansion - Impact Analysis
3. More Actions - See/Hide Target & See/Hide Source
4. Information - Component Properties
5. Lineage Expansion - Root Cause Analysis
6. Lineage Focus - Change focus to this item
7. Hop to Catalog Module - Automatic Data Catalog (if available)

Updates

Enhanced Focused Path Analysis

Our focused path analysis tool has been updated to offer better usability and clearer visual indications. In this release, we've added the following enhancements:

• Visual Indicators for Selected Objects: When analyzing cross-system data flows, any object selected for focused path analysis will now display a visual indication. This makes it easier for users to identify which objects are part of the focused path.
• Improved Object Selection: If an object cannot be selected for focused path analysis, it means the map is already reduced to that specific path. The map will show all objects going through the selected object and their connected objects.
• Stable Map Filters: If your analysis is focused on a specific path, filters cannot be activated. This ensures the stability of the map, as any filter changes would trigger a map recalculation. For optimal results, we advise users to configure filters before applying focused path analysis.