5 SQL Lineage Tools for SAP Business Objects

Dataedo

https://dataedo.com/product/data-lineage

Dataedo provides SQL lineage tracking by visualizing how data flows through queries, transformations, and databases. This enhances transparency, supports troubleshooting, and ensures data accuracy across SQL-based environments.

Automatic discovery:
Data flow visualization:
Environment:	On-premises
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

OvalEdge

https://ovaledge.com

OvalEdge provides a powerful and automated way to visualize your Data Flow Effortlessly. Its algorithms build the lineage from the most accurate source, source code. It crawls the source code from various connectors. After that, it parses its language like SQL, PL/SQL, XML, etc., and then builds the lineage.

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.

Automatic discovery:
Data flow visualization:
Environment:	On-premises
Free edition:
Metadata management:
Version control integration:

Go to vendor website

Informatica Data Lineage

https://www.informatica.com/products/data-catalog/data-lineage.html

Informatica Data Lineage tool provides automated end-to-end data lineage with detailed and summary views of data movement across data pipelines. With Informatica, you can derive lineage from code in SQL scripts, stored procedures and AI/ML code. It streamlines tracking data flow from system- to column-level for detailed impact analysis.