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 Google Big Query
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: |
|
Informatica Enterprise Data Catalog
Informatica Enterprise Data Catalog allows to add rich business context to the data by associating business terms with the right technical metadata. It enables automatic association of business terms with the technical metadata, which helps eliminate a tedious manual process for data governance. This allows business and IT stewards to collaboratively manage business metadata that includes efficient human workflow automation.
| Data Policies and Rules: |
|
|---|---|
| Export: | CSV,MS Excel,Plain text,XML |
| Integration with Technical Metadata: |
|
| Linkage to reports/apps: |
|
| Reference data: |
|
| Support for workflow: |
|
Alteryx Connect
Alteryx Connect is one of a kind of data governance and collaborative exploration platform for data asset discovery, sharing, and validation. It can be used as an enterprise business glossary where you define your standard business terms in a data dictionary and link them to assets in the data catalog so that context and meaning of assets are consistent across teams with a common vocabulary.
| Data Policies and Rules: |
|
|---|---|
| Export: | CSV,MS Excel,PDF |
| Integration with Technical Metadata: |
|
| Linkage to reports/apps: |
|
| Reference data: |
|
| Support for workflow: |
|
OvalEdge
OvalEdge is a data governance tool that allows to build a business glossary and define data quality rules. It enables to manage data access through policies, controls, and workflows.
| Data Policies and Rules: |
|
|---|---|
| Export: | - |
| Integration with Technical Metadata: |
|
| Linkage to reports/apps: |
|
| Reference data: |
|
| Support for workflow: |
|
Alation Data Catalog
Alation’s Business Glossary enables the creation of definitions, policies, rules, and KPIs through a rich, user-friendly interface. By leveraging machine learning, Alation’s Business Glossary automatically suggests business terms, identifies stewards and subject matter experts based on usage patterns, and incorporates crowdsourcing and collaboration to easily scale documentation.
| Data Policies and Rules: |
|
|---|---|
| Export: | MS Excel |
| Integration with Technical Metadata: |
|
| Linkage to reports/apps: |
|
| Reference data: |
|
| Support for workflow: |
|
Atlan
Atlan Business Glossary allows data producers and consumers in an organization to create a living tribal knowledge network across all of their data assets. Powered by a knowledge graph, Atlan allows users to define business terms, categories, policies, relationships and more. Atlan's machine learning based bot ecosystem automates several repetitive tasks associated with maintaining a business glossary such as auto tagging business glossary terms to data assets, propagating classification and glossary tagging rules via lineage, bulk associate glossary terms to data assets via an API and more. Its easy to use google like search interface makes it easy for business users to find the meaning of business terms within seconds while ensuring the compliance of business metadata across the enterprise.
| Data Policies and Rules: |
|
|---|---|
| Export: | - |
| Integration with Technical Metadata: |
|
| Linkage to reports/apps: |
|
| Reference data: |
|
| Support for workflow: |
|
Select Star
Select Star has a metrics feature that allows you to define key terms and values based on data that aim to answer specific business questions. Select Star can automatically detect dimensions that you may want to group or pivot on, but you can remove these if desired or search for others.
| Data Policies and Rules: |
|
|---|---|
| Export: | CSV,JSON |
| 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.