6 SQL Lineage Tools for Netezza

SQLFlow

https://www.gudusoft.com/data-lineage-visualization-discovery-tools/

SQLFlow is an online SQL data lineage tool that visually represents the overall flow of data. It offers automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud, and Hadoop environments by parsing SQL Script and stored procedure. It enables impact analysis at a granular level, drilling down into table, column, and query-level lineage.

Automatic discovery:
Data flow visualization:
Environment:	Online
Free edition:
Metadata management:
Version control integration:

Go to vendor website

Collibra Data Lineage

https://www.collibra.com/data-lineage

Collibra Data Lineage extracts and maintains lineage automatically from source systems, SQL dialects, ETL tools, and BI tools. It provides detailed technical lineage at the table, column, transformation, and SQL query levels to quickly understand the impact of potential changes. Moreover, its interactive lineage diagram shows a summary of lineage from source to destination.

Automatic discovery:
Data flow visualization:
Environment:	Online
Free edition:
Metadata management:
Version control integration:

Go to vendor website

Octopai

https://www.octopai.com/

Octopai Data Lineage XD is the most complete, in-depth, and automated lineage tool that provides end-to-end lineage at the system level from the entry point into the data landscape, all the way to reporting and analytics. Its cross-system lineage reflects data flows and dependencies using automated and augmented methods to provide the most extensive cross-system view of the entire data landscape.

Automatic discovery:
Data flow visualization:
Environment:	Online
Free edition:
Metadata management:
Version control integration:

Go to vendor website

Engrafo

https://www.engrafo.eu/

Engrafo automatically creates data catalogs, data flow diagrams, and data lineage. It can extract data lineage from all common SQL dialects and generate flow charts to create overview and information about critical ETL flows. Moreover, it extracts metadata from your BI Tools and automatically creates data lineage back to the data catalogs.

Automatic discovery:
Data flow visualization:
Environment:	Online
Free edition:
Metadata management:
Version control integration:

Go to vendor website

Secoda

https://www.secoda.co/data-lineage

Secoda provides end-to-end data lineage across your entire data stack. It automates column and table level data lineage. In additional, Secoda also brings in tests, events, and ETL into data lineage. All of Secoda's lineage is automated, but users can also manually contribute to lineage using Secoda's API.

Automatic discovery:
Data flow visualization:
Environment:	Online
Free edition:
Metadata management:
Version control integration:

Go to vendor website

MANTA

https://manta.io/supported-scanners/microsoft-sql-server

Manta offers a powerful scanner for the Microsoft SQL Server technology. Once configured, Manta can automatically connect to the MS SQL resource for extracting and analyzing the pertinent metadata within the selected databases. This metadata includes but is not limited to tables, views, indexes, SQL procedures, schemas, databases, columns, and triggers. Then, Manta can parse all the SQL programming code and logic stored within. This allows Manta to generate lineage down to the column level while showing all transformation logic associated with individual column elements.