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 SQLite
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: |
|
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: |
|
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: |
|
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.