SQL Lineage Tools for Excel
Dataedo
Dataedo allows you to extract lineage automatically or design flows manually and visualize how data moves through the system with interactive diagrams.
Automatic discovery: | |
---|---|
Data flow visualization: | |
Environment: | On-premises |
Free edition: | |
Metadata management: | |
Version control integration: |
MANTA
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: |
Informatica Data Lineage
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.
Automatic discovery: | |
---|---|
Data flow visualization: | |
Environment: | Online |
Free edition: | |
Metadata management: | |
Version control integration: |