Data catalog tools for SQL Server Integration Services

List of data catalogs tools

Data catalog is a structured collection of data used by an organization. It is a kind of data library where data is indexed, well-organized, and securely stored. Most data catalog tools contain information about the source, data usage, relationships between entities as well as data lineage. This provides a description of the origin of the data and tracks changes in the data to its final form.

Collibra Catalog

Collibra Catalog empowers business users to quickly discover, understand, contribute, and govern the data that matters so they can generate impactful insights that drive business value. It also allows data stewards to certify datasets so that business users can trust the data that they use in their analysis.

Automated Cataloging: Yes
Business Glossary: Yes
Commenting/Community: Yes
Commercial: Commercial
Data Classification: Yes
Data Lineage: Yes
Data Profiling: Yes
Export: MS Excel
Free edition: No
Rating of assets: Yes

Dataedo

Dataedo is an on-premises data catalog & metadata management tool. It allows you to catalog, document, and understand your data with a data dictionary, business glossary, and ERDs. It reads your schema and lets you easily describe each data element with descriptions, business-friendly aliases, and custom fields. It features a data community module, which allows you to crowdsource knowledge about data from everyone in your organization.

Automated Cataloging: Yes
Business Glossary: Yes
Commenting/Community: Yes
Commercial: Commercial
Data Classification: Yes
Data Lineage: Yes
Data Profiling: Yes
Export: HTML,MS Excel,PDF
Free edition: No
Rating of assets: Yes
Dataedo Data Catalog
Dataedo Sensitive Data Discovery
Dataedo Report Catalog
Dataedo Data Search
Dataedo Referenece Data Management
Dataedo Data Catalog - list of data sources
Dataedo Data Community
Dataedo Business Glossary
Dataedo Data Profiling
Dataedo Data Lineage
Dataedo ERD

erwin Data Catalog

erwin Data Catalog (erwin DC) automates the processes involved in harvesting, integrating, activating and governing enterprise data according to business requirements. To summarize, erwin DC creates and maintains a sustainable metadata foundation for data preparation, management, governance and consumption, automating manual tasks to increase efficiencies, quality and time to value for data development and deployment.

Automated Cataloging: Yes
Business Glossary: Yes
Commenting/Community: Yes
Commercial: Commercial
Data Classification: Yes
Data Lineage: Yes
Data Profiling: Yes
Export: MS Excel,PDF
Free edition: No
Rating of assets: No

Alex Solutions

Alex Solutions is a marketplace for enterprise data that enables data-centric business outcomes. It provides a flexible, technology agnostic, highly scalable, unified enterprise data catalog. It also enables business users to define and maintain key business terms and link them to physical data assets, processes, and outputs.

Automated Cataloging: No
Business Glossary: Yes
Commenting/Community: No
Commercial: Commercial
Data Classification: No
Data Lineage: Yes
Data Profiling: Yes
Export: -
Free edition: No
Rating of assets: No

Ataccama Metadata Management & Data Catalog

Ataccama ONE 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.

Automated Cataloging: Yes
Business Glossary: Yes
Commenting/Community: Yes
Commercial: Commercial
Data Classification: Yes
Data Lineage: Yes
Data Profiling: Yes
Export: CSV,JSON,MS Excel,XML
Free edition: No
Rating of assets: No

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 enables you to organize, define and manage enterprise data to provide the right context to drive value across imperatives like regulatory compliance to data monetization.

Automated Cataloging: Yes
Business Glossary: Yes
Commenting/Community: Yes
Commercial: Commercial
Data Classification: Yes
Data Lineage: Yes
Data Profiling: Yes
Export: JSON,MS Excel,XML
Free edition: Yes
Rating of assets: Yes

Global IDs

The Global IDs Data Catalog automates the linking of logical business data models to physical data assets, keeps the metadata up to date, and scales with the size of your enterprise, from small to very large.

Automated Cataloging: Yes
Business Glossary: Yes
Commenting/Community: -
Commercial: Commercial
Data Classification: Yes
Data Lineage: Yes
Data Profiling: Yes
Export: XML
Free edition: No
Rating of assets: No

Talend Data Catalog

Talend Data Catalog automatically crawls, profiles, organizes, links, and enriches all your metadata. It makes easy to search and access data, then verify its validity before sharing with peers. Up to 80% of the information associated with the data is documented automatically and kept up-to-date through smart relationships and machine learning, continually delivering the most meaningful data to the user.

Automated Cataloging: Yes
Business Glossary: Yes
Commenting/Community: Yes
Commercial: Commercial
Data Classification: Yes
Data Lineage: Yes
Data Profiling: Yes
Export: CSV,JSON,MS Excel,XML
Free edition: No
Rating of assets: Yes

Octopai

Octopai provides an efficient data catalog functionality that significantly reduces the manual overhead of this process. It automates the process of metadata discovery and data lineage, and quickly assemble the metadata needed to create an effective data catalog.

Automated Cataloging: Yes
Business Glossary: Yes
Commenting/Community: No
Commercial: Commercial
Data Classification: No
Data Lineage: Yes
Data Profiling: No
Export: -
Free edition: No
Rating of assets: No

Data catalogs are part of data management tools. They enable automatic metadata management with user-friendly form that makes data easy to understand even for non-IT members of the organisation.

The key feature of data catalogs is to provide metadata context to the user in a way that allows different teams within the organization (both IT and Non-IT) to discover and understand relevant data.

From the organization's perspective, the important functions of data catalog tools are also:
• storage of data resources from different repositories as well as from different engine systems - compatibility with multiple connectors,
• automation of data management processes,
• advanced resource search by name, type, date of change, owner, etc.
• data lineage,
• automated data Classification,
• Discovering data relationship and dependencies between objects,
• Business Glossary, unifying nomenclature and definitions of terms,
• Data Profiling,

Data stewards, business teams, and data analysts often struggle with the problem of what specific data means, where it comes from, and which elements it is directly related to. These are just a few problems for which Data catalog tools have been created. Based on the imported repositories, data catalogs enable automated cataloging and organizing of data, solving the problem of time-consuming querying of the resources.

To avoid misunderstandings data catalog tools provide a Business Glossary, through which the nomenclature is systematized. It contains business terms along with their definition, relationship to each other, as well as its location in the hierarchy of all data assets.

There are many apps for data catalog tasks on the market. We have listed complex data cataloging software that can also solve data profiling, data lineage, and data classification problems, as well as open-source data catalog tools.