SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Metadata Management tools for SQL Server Integration Services
List of metadata management tools
Metadata management tool is a solution that supplements the data stored by the enterprise environment with useful information. Proper metadata management is a crucial factor to make information searchable, easy to locate and understand. Such tools add meaningful context to raw data, making it convenient to discover even by non-IT members of an organization.
Dataedo
Dataedo allows companies to catalog their data in a central metadata repository in a matter of minutes, annotate each data asset, extract and document table relationships, build Business Glossary and map it to Data Dictionary, classify sensitive data, visualize data models with ER Diagrams and share documentation with data community in interactive web portal or HTML exports.
| Business Glossary: |
|
|---|---|
| Change history: |
|
| Data Classification: |
|
| Data Lineage: |
|
| Data Profiling: |
|
| On premises/cloud: | On premises |
| Rating of assets: |
|
| Reference data: |
|
| Support for workflow: |
|
erwin Data Catalog
erwin Data Catalog (erwin DC) is metadata management software that helps organizations learn what data they have and where it’s located, including data at rest and in motion. It tells you the data and metadata available for a certain topic so those particular sources and assets can be found quickly for analysis and decision-making.
| Business Glossary: |
|
|---|---|
| Change history: |
|
| Data Classification: |
|
| Data Lineage: |
|
| Data Profiling: |
|
| On premises/cloud: | On premises |
| Rating of assets: |
|
| Reference data: |
|
| Support for workflow: |
|
Alex Solutions
Alex Solutions is a globally recognised Metadata Management Solution (data catalog and data governance) designed to empower everyone to securely find, understand, protect, and use the data. It brings the world’s largest variety of out-of-the-box metadata scanners, that can be configured to collect a wide variety of metadata including usage information, sensitive data detection, end-to-end lineage, and data profiling information.
| Business Glossary: |
|
|---|---|
| Change history: |
|
| Data Classification: |
|
| Data Lineage: |
|
| Data Profiling: |
|
| On premises/cloud: | Cloud |
| Rating of assets: |
|
| Reference data: |
|
| Support for workflow: |
|
Ataccama Metadata Management & Data Catalog
Ataccama Metadata Management & Data Catalog is an AI-powered metadata management module. It’s a central storage for all of your metadata—imported from other sources, crowdsourced, or automatically captured in continuous data discovery processes.
| Business Glossary: |
|
|---|---|
| Change history: |
|
| Data Classification: |
|
| Data Lineage: |
|
| Data Profiling: |
|
| On premises/cloud: | On premises |
| Rating of assets: |
|
| Reference data: |
|
| Support for workflow: |
|
Octopai
Octopai automates metadata management and analysis, enabling enterprise BI groups to quickly, easily and accurately find and understand their data for improved operations, data quality and data governance.
| Business Glossary: |
|
|---|---|
| Change history: |
|
| Data Classification: |
|
| Data Lineage: |
|
| Data Profiling: |
|
| On premises/cloud: | Cloud |
| Rating of assets: | - |
| Reference data: |
|
| Support for workflow: |
|
Global IDs
The Global IDs Enterprise Data Automation (EDA) platform builds metadata using its discovery, profiling, classification, lineage, and catalog functions, overcoming barriers between silos and creating a unified map of the entire enterprise data landscape: the location of data, its meaning and dependencies, and its flow patterns through the ecosystem.
| Business Glossary: |
|
|---|---|
| Change history: |
|
| Data Classification: |
|
| Data Lineage: |
|
| Data Profiling: |
|
| On premises/cloud: | On premises |
| Rating of assets: |
|
| Reference data: |
|
| Support for workflow: |
|
IBM Watson Knowledge Catalog
IBM Watson® Knowledge Catalog is an open and intelligent data catalog for managing enterprise data and AI model governance, quality and collaboration. It provides unique capabilities that include automated data discovery and metadata generation, ML-extracted business glossary from most common regulatory terms, and many more.
| Business Glossary: |
|
|---|---|
| Change history: |
|
| Data Classification: |
|
| Data Lineage: |
|
| Data Profiling: |
|
| On premises/cloud: | Cloud |
| Rating of assets: |
|
| Reference data: |
|
| Support for workflow: |
|
Metadata management tools are usually multifunctional programs that provide a wide spectrum of usability. They include functionalities such as:
• Data catalog,
• compatibility with multiple connectors, making the tool a single source of truth about the data from different repositories,
• Business glossary,
• Data lineage,
• Data profiling,
• Impact analysis,
• Metadata ingestion and translation.
From the organization's point of view, the ability to export the created documentation into user-friendly formats is also important. What is more, some of the tools offer a community module, which facilitates the information flow.
Metadata management solutions oversee data across its entire lifecycle. This typically covers four primary areas: data analysis, data value, data governance, risk and compliance.
Proper metadata management implementation allows for standardized metadata definitions, management, and maintenance of information across the organization for greater business efficiency.
Today, as data becomes increasingly important to the growth of company performance, choosing the right way to manage it is equally essential.
To help you find the right tool for your organization, we have put together this list of best metadata management solutions.