Lineage on-premise DB2/LUW or Z/os

[rjsilva1987]

We've an on-premises DB2/LUW and Z/Os database and we need to show a lineage of them. Can Unity Catalog or Purview do this? If we've the best, what would it be? Or would working with both be a better option?

[Kaniz_Fatma]

Hi @rjsilva1987, Both Unity Catalog and Purview can help you with data lineage, but let’s explore the specifics:

1. Unity Catalog:

   • Unity Catalog is part of Databricks’ data governance and metadata management solution.
   • It provides data lineage capabilities, allowing you to track data movement and transformations.
   • Unity Catalog is tightly integrated with Databricks, making it a good choice if you’re already using Databricks for analytics and data processing.

2. Purview:

   • Purview (formerly known as Azure Purview) is a Microsoft service for discovering, classifying, and managing data.
   • It supports scanning and cataloguing various data sources, including DB2.
   • Purview is part of the broader Azure ecosystem, so consider it if you’re using other Azure services.

3. Working with Both:

   • If you need comprehensive lineage across different platforms, consider using both Unity Catalog and Purview.
   • Unity Catalog can handle Databricks-specific workloads, while Purview covers a broader range of data sources.