SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Data intelligence tools for Amazon Redshift
Data intelligence tools refer to the artificial intelligence and machine learning tools used by companies in order to analyze and transform data into information that is valuable and relevant for improving the company's operations.
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.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
Alation Data Catalog
Alation pioneered the data catalog market and is now leading its evolution into a platform for a broad range of data intelligence solutions including data search & discovery, data governance, stewardship, analytics, and digital transformation. Thanks to its powerful Behavioral Analysis Engine, inbuilt collaboration capabilities, and open interfaces, Alation combines machine learning with human insight to successfully tackle even the most demanding challenges in data and metadata management.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
Informatica Enterprise Data Catalog
Informatica Data Catalog is a machine learning-based data catalog that lets you classify and organize data assets across any environment to maximize data value and reuse, and provides a metadata system of record for the enterprise. It automatically scans and catalogs data across the enterprise, indexing it for enterprise-wide discovery using simple, Google-like search.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
Lumada Data Catalog
Lumada Data Catalog software leverages AI, machine learning, and patented fingerprinting technology to automate the discovery, classification, and management of your enterprise data. It simplifies access and promotes collaboration allowing an organization to more intelligently use their data.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
OvalEdge
OvalEdge is a data catalog tool that automatically organizes and catalogs your data using machine learning and advance algorithms. You can organize data using tags, usage statistics, user names, and other markers – so it’s easily retrievable with everyday language.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: | - |
Alteryx Connect
Alteryx Connect is a social data cataloging and data exploration platform for the enterprise. The powerful data cataloging provided by Alteryx Connect centralizes business terms and definitions, metrics, and information assets for maximum consistency, discoverability, and collaboration.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
Truedat
Truedat is an open source data cataloging and governance tool that allows to quickly unify and explore combined metadata from different sources on the same interface. It enables to organize & enrich information through configurable workflows and monitor data governance activity.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
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.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
Tree Schema
The Tree Schema data catalog provides all of the essential catalog capabilities including rich-text documentation, data lineage, assigning data stewards and technical owners to your data assets, tagging your assets and much more. You can point Tree Schema to your database and fully populate your catalog in under 5 minutes. Tree Schema also supports non-traditional data sources including S3, Kafka and DynamoDB.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
Atlan
Atlan is a modern, cloud native data catalog. It's ease of use and intuitive interface enables diverse personas including engineers, data stewards and business users to discover, understand and trust data. Atlan leverages machine learning and a bots ecosystem to automate documentation and stewardship tasks such as automatic data profiling, data quality alerts and glossary tagging. It is built on an Open API architecture, and has a pay as you go pricing model, making it a good fit for teams of all sizes.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
Stemma
Stemma is a fully managed data catalog, powered by the leading open-source data catalog, Amundsen. By bridging the gap between data producers and data consumers, Stemma enables you to gain total trust in your data. Stemma provides enterprise management (easy deployment, enterprise-grade security) and richer metadata. It makes finding trustworthy data easy and offers an always up-to-date view of your data's usage at any time through automated documentation based on common usage patterns.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
The use of data intelligence tools improves the understanding of data and leads to better decision making in the future. There are other, various benefits that data intelligence tools can bring into the company. Some of them are:
• Providing correct context for datasets.
• Improving data quality.
• Increasing data accessibility.
In an evolving world of technology, data intelligence is crucial for the company's growth. It can help understand consumer preferences as well as a company's investment and its effectiveness. Through data analysis the company can view which areas can be optimized and present approaches that might be more beneficial for the future.
To help you find the right tool for your organization, we have put together this list of best data intelligence tools.