SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Data lineage tools for Firebird
Data lineage tools are software that allows to extract, view and analyze data lineage. Data lineage is the process of understanding and visualizing data flow from the source to different destinations. It allows to create a map of the data journey through the entire ecosystem.
Dataedo
Dataedo allows you to extract lineage automatically or design flows manually and visualize how data moves through the system with interactive diagrams. Dataedo supports object and column-level data lineage.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
ER/Studio
ER/Studio is an enterprise data modeling, architecture, and governance tool. It comes with a data lineage tab which is used to primarily document ETL processes from scratch. With visual data lineage support, you can visually document source/target mapping and sourcing rules for data movement across systems.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
Keboola
Keboola is a cloud-based data integration platform that helps clients combine, enhance, and publish crucial information for their internal analytics projects and data products in a quick and easy fashion. It collects all kinds of operational metadata, describing user activity, job activity, data flow, schema evolution, data pipeline performance, compliance with a client’s security rules, etc. Based on the metadata, we are able to build data lineage on the fly and automatically. This makes it possible to understand where the data is coming from and how it is used, both for analytical and regulatory purposes.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
Data lineage forms the foundation for accurate data analytics and management. The core features of data lineage focuses on:
• Identifying data quality issues.
• Performing root cause analysis.
• Enabling to understand which data sources are outdated or which datasets are relevant.
• Minimizing the risk of migration projects.
• Providing transparency over the life cycle of data.
Data lineage tools map the data flow and help you understand where the data originated, how it flows and transforms. To help you find the right tool for your company, we prepared a list that includes some of the best data lineage tools.