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 SQL Server
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.
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.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
Google Cloud Data Catalog
Google Cloud Data catalog is a fully managed and highly scalable data discovery and metadata management service that empowers organizations to quickly discover, manage, and understand all their data in Google Cloud. It offers a simple and easy-to-use search interface for data discovery, a flexible and powerful cataloging system for capturing both technical and business metadata.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
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.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
Azure Data Catalog
Azure Data Catalog is an enterprise-wide metadata catalog that makes data asset discovery straightforward. It’s a fully-managed cloud service that lets any user (analyst, data scientist, or developer) register, enrich, discover, understand, and consume data sources.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
Qlik Data Catalyst
Qlik Data Catalyst is a metadata driven data catalog that has technical and business descriptions, data profiles, data lineage, and data tags that make data search and delivery simple. It builds a secure, enterprise-scale catalog of all the data your organization has available for analytics, no matter where it is.
| Data Catalog: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
erwin Data Catalog
erwin Data Catalog is an automated metadata harvesting, data catalog, code generation, and data lineage software. This automation results in greater accuracy and faster time to value for data governance and digital transformation efforts, including data warehouse, data lake, Data Vault, and other Big Data deployments, cloud migrations, etc.
| 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: |
|
Sidecar
Sidecar data catalog is a modern, intuitive and comprehensive tool to discover, classify and enrich all your data assets. Automatically index all the metadata in a centralized repository and provide a clear view of the complex and fragmented data management environments to your data consumer. With the Business Glossary capabilties, you can easily enrich all your data assets with business context, clear definitions, rules and transformations. Foster team work among the user community by exchanging ideas on the data assets with the collaboration tool. Add custom tags and classifcations to organize your assets and manage your sensitive data to comply with GDPR, HIPAA, CPRA, etc... Data consumers will spend less time searching for the right data and focus on delivering faster insights.
| 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.