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 SQL Server
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.
Azure Purview
Microsoft Purview, or Azure Purview, is a unified data governance solution that offers automated data discovery, lineage identification, and data classification. It lets you understand the origin of your data with interactive data lineage visualization.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
OvalEdge
OvalEdge offers a comprehensive lineage solution to show a complete the complete data cycle. OvalEdge algorithms parse various kinds of source code to build the lineage automatically and then it is enhanced by experts with proper descriptions.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
Truedat
Truedat is an open source data governance business solution tool that lets you have an end to end vision of your data from a business and technical point of view. Truedat data lineage module allows the visualization of the information life cycle, as well as the interconnection between each system of the organization, which allows to have a complete traceability of the data, as well as impact analysis in the event of possible changes in data structures or processes.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Free |
| 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: |
|
Talend Data Catalog
Talend Data Catalog gives your organization a single, secure point of control for your data. Its data flow lineage feature allows you to narrow in on specific objects and shows you how these objects are related to each other, within a model, an external metadata repository, or a configuration. The data flow lineage is based upon connection definitions to data stores and physical transformation rules which transform and move the data.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
Dremio
Dremio is a SQL Lakehouse Platform built from the ground up to deliver high-performing BI dashboards and interactive analytics directly on the data lake. It offers effective data lineage support, as the relationships between your data sources, virtual datasets, and all your queries are maintained in Dremio’s data graph, telling you exactly where each dataset came from.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
Secoda
Secoda is a data discovery tool that offers an intuitive, collaborative, and easy to implement data discovery built. It automatically extracts queries to generate data lineage. Currently, it is supporting table lineage for Snowflake, dbt, Redshift, and BigQuery, with support for Postgres, MySQL, and Microsoft SQL Server coming soon. Secoda data lineage can help data teams identify the downstream and upstream dependencies of a table easily. On each dependency, you will be able to see how many levels away a particular table is, with the ability to view the data in a visual form coming soon.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
erwin Data Catalog
erwin Data Catalog automates enterprise metadata management, data mapping, code generation, and data lineage for faster time to value and greater accuracy for data movement and deployment projects. It lets you generate on-demand lineage down to the column level and visualize data flows from source systems all the way to the reporting layers, including all transformations. Fully configurable and navigable lineage diagrams provide high-level business views as well as detailed technical depictions.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
IBM InfoSphere Information Governance Catalog
IBM InfoSphere Information Governance Catalog is a web-based tool that allows you to explore, understand, and analyze information. It lets you run data lineage to create trusted information that supports data governance and compliance efforts. You can perform lineage analysis to understand where data comes from or goes to by using shared table information, job design information, or operational metadata from job runs.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Commercial |
| Data migration tools lineage: |
|
| Data warehouses lineage: |
|
| ETLs: |
|
| Free edition: |
|
| Hadoop: |
|
| NoSQL: |
|
| Pipelines lineage: |
|
| RDBMS: |
|
Kylo
Kylo is an open source enterprise-ready data lake management software platform. It lets you search and explore data and metadata, view lineage, and profile statistics. Visual process lineage and provenance provide confidence in the origin of data. Automatic data profiling provides capabilities for data scientists and assurance in data quality.
| BI Tools lineage: |
|
|---|---|
| Commercial: | Free |
| 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.