SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Business Glossary tools for Microsoft SQL Server Analysis Services (SSAS)
List of tools that help build, maintain an share business glossaries.
Business Glossary is a collection of definitions and terms used within a business unitorganization. It is not used to define data, but rather to define what a particular term means from a business perspective. The definitions are mapped and logically linked to entities in the database. This enables structured communication between teams and allows them to reveal potential errors resulting from incorrect nomenclature.
Dataedo
Dataedo Business Glossary tool provides glossary of business terms, their definitions, relationships between each other and mapping to data assets elements. It allows creating different types of terms, such as term, category, policy and rule. Using Dataedo Business Glossary you can define relationships between terms, categories, rules and policies in the catalog.
| Data Policies and Rules: |
|
|---|---|
| Export: | HTML,MS Excel,PDF |
| Integration with Technical Metadata: |
|
| Linkage to reports/apps: |
|
| Reference data: |
|
| Support for workflow: |
|
Collibra Data Governance Center
Collibra Data Governance Center enables you to organize and understand data in your enterprise. It allows you to define the terminology, rules and regulations that matter to your business, document your metadata and its use, and create, review and update data policies.
| Data Policies and Rules: |
|
|---|---|
| Export: | HTML,PDF |
| Integration with Technical Metadata: |
|
| Linkage to reports/apps: |
|
| Reference data: |
|
| Support for workflow: |
|
Talend Data Catalog
Talend Data Catalog automatically crawls, profiles, organizes, links, and enriches all your metadata. The tool supports data privacy and regulatory compliance with intelligent data lineage tracing and compliance tracking. With a collaborative user experience, it enables anyone to contribute metadata or business glossary information.
| Data Policies and Rules: |
|
|---|---|
| Export: | CSV,MS Excel,XML |
| Integration with Technical Metadata: |
|
| Linkage to reports/apps: |
|
| Reference data: |
|
| Support for workflow: |
|
There are many tools for creating business glossaries. Whether sophisticated or not, they allow to create:
• access and alternate names,
• descriptions,
• explanations of how to calculate metrics,
• links to other elements.
To ensure access to all terms from different platforms, many business glossary tools are cross-platform compatible. More advanced tools provide a workflow to ensure that term definitions are updated and approved. In addition to the glossary creation features, the tools allow you to export to user-friendly and easy-to-share formats like PDF and HTML.
Proper communication between teams in an organization is crucial for the success of the project. Similarly, it is important to interpret data correctly. Each of the teams working together (business team, developers, marketing teams), use different nomenclature and terms. Within a team the logical meaning of data elements, acronyms, etc. are defined and understood only by a narrow group of members. This makes the area of inconsistency really wide. Even small misunderstandings can lead to fatal consequences. This is where the business glossary comes into play.
What's more, using glossaries not only makes the communication more reliable, but also improves efficiency and speeds up the decision-making process (e.g. wondering if "customer" means a single person, an organization, and repeating the consideration next time the project is approached).
In our list, we have included noteworthy business tools for creating and reviewing business glossaries.