Automatic Data Lineage

Dataedo builds data lineage automatically for the following environments.

Databases and applications

• 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

• 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

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

Data catalog tools

• 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:

1. Transact-SQL - Microsoft SQL Server, Azure SQL Database, Azure Synapse
2. PL/SQL - Oracle, IBM Db2
3. MySQL - MySQL, MariaDB
4. PostgreSQL - PostgreSQL, Amazon Redshift
5. Snowflake - Snowflake