Automatic Data Lineage

Dataedo builds data lineage automatically for the following environments:

Databases

Dataedo supports automatic data lineage for the following databases and applications:

Database/Application
Microsoft Dataverse
Microsoft Dynamics 365
Microsoft SQL Server
Microsoft Azure SQL Database
Microsoft Fabric - Data Warehouse
Microsoft Azure Synapse Analytics (formerly SQL Data Warehouse)
Microsoft SQL Server Analysis Services (SSAS) Multidimensional (OLAP Cubes)
Microsoft SQL Server Analysis Services (SSAS) Tabular
IBM Db2 LUW
MySQL
MariaDB
Oracle
Oracle E-Business Suite
PostgreSQL
Amazon Redshift
Snowflake

BI tools

Dataedo supports automatic data lineage for the following BI tools:

BI Tool
Amazon QuickSight
Tableau
Power BI
Microsoft Fabric - Power BI
Power BI Report Server
Microsoft SQL Server Reporting Services (SSRS)
Qlik Sense SaaS
Qlik Sense On-Prem
SAP BusinessObjects BI
Redash

ETL tools

Dataedo supports automatic data lineage for the following ETL tools:

ETL Tool
SQL Server Integration Services (SSIS)
Azure Data Factory (ADF)
Microsoft Azure Synapse Pipelines
dbt Core
dbt Cloud
Fivetran

Data catalog tools

Dataedo supports automatic data lineage for the following data catalog tools:

Data Catalog Tool
Apache Atlas
Azure Purview
Cloudera Catalog
Databricks Unity Catalog

SQL dialects

Dataedo parses and analyzes SQL code (views and for some dialects also stored procedures) and builds lineage automatically for the following SQL dialects:

SQL Dialect	Supported Environments
Transact-SQL	Microsoft SQL Server, Azure SQL Database, Azure Synapse
PL/SQL	Oracle, IBM Db2
MySQL	MySQL, MariaDB
PostgreSQL	PostgreSQL, Amazon Redshift
Snowflake	Snowflake