SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Data discovery tools for SQL Server
Data enables companies to make informed decisions and understand needs of the customer and the business. In order to leverage data, data discovery tools help organizations visualize, analyze and get insights from it. They start by collecting data from multiple sources to then consolidate, classify, and catalog it into a single repository to simplify its evaluation.
Dataedo
Dataedo is a powerful data governance & data catalog solution. With its intuitive interface, Dataedo enables organizations to locate, understand, and leverage their data assets efficiently. By promoting seamless data discovery, Dataedo enhances collaboration and innovation, empowering users to make informed decisions effortlessly.
| Business Glossary: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
| Data visualization: |
|
| Free edition: |
|
| Metadata management: |
|
| Notifications: |
|
Atlan
Atlan is a modern and all-in-one platform that unifies your data discovery, cataloging, lineage, and governance experience. It empowers teams to easily discover and use data and create one place for all your data assets, tasks, and discussions.
| Business Glossary: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
| Data visualization: |
|
| Free edition: |
|
| Metadata management: |
|
| Notifications: |
|
Alteryx Connect
Alteryx Connect is an all-in-one data management and collaboration tool that changes how you discover and organize information for analytics in your organization. It discovers the types of information your data contains, where the information comes from, who is using it, and how it is used through highly social interactions.
| Business Glossary: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
| Data visualization: |
|
| Free edition: |
|
| Metadata management: |
|
| Notifications: |
|
Tableau Data Management
Tableau Data Management lets you discover, understand, connect, and trust your data. It offers automated data discovery and helps deliver trusted, self-service analytics by scaling data automation and operationalization throughout the entire data and analytics lifecycle.
| Business Glossary: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
| Data visualization: |
|
| Free edition: |
|
| Metadata management: |
|
| Notifications: |
|
Datapine
Datapine is a modern business intelligence platform that provides powerful features for data discovery and to extract more insights from the data. It provides one central place to view all data with features like fast & easy data connectors, powerful & interactive BI dashboards, and modern predictive analytics tools.
| Business Glossary: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
| Data visualization: |
|
| Free edition: |
|
| Metadata management: |
|
| Notifications: |
|
Power BI Dataset Discovery Hub
The Power BI dataset discovery hub empowers Power BI and Microsoft Teams users to discover and re-use organizational and curated datasets and answer their own business questions either in Power BI or in Excel. For data owners, the hub will empower them to manage their data assets in a central location. Overall, the data hub makes it easy to find, explore, and use the data items in your organization, such as datasets and datamarts.
| Business Glossary: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
| Data visualization: |
|
| Free edition: |
|
| Metadata management: |
|
| Notifications: |
|
TIBCO Spotfire
TIBCO Spotfire provides powerful and deep data visualization and exploration. The AI-driven and new UI lets you visually interact with your data and find insights in an immersive environment. Moreover, Spotfire recommendations instantly display visualizations for different relationships in your data as you analyze, making it far faster and easier to get the insights you expect
| Business Glossary: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
| Data visualization: |
|
| Free edition: |
|
| Metadata management: |
|
| Notifications: |
|
Domo
Domo provides AI-powered and automated data discovery with a simple drag-and-drop interface, making complex datasets consumable with a few clicks. Moreover, it allows to create customizable, interactive dashboards to fit any business scenario with Variables. Variables are custom-defined fields that users can adjust inside dashboards.
| Business Glossary: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
| Data visualization: |
|
| Free edition: |
|
| Metadata management: |
|
| Notifications: |
|
Dataiku
Dataiku interactively explores data and creates statistical analyses, charts, and dashboards to share insights with the broader team. It provides automatic profiling of columns, including the counts and distribution of values, top values, outliers, invalids, and summary statistics. Moreover, it includes a broad range of statistical tests and analyses, including univariate / bivariate / multivariate analyses, fit curves and distributions, location and distribution tests, and time series-specific analyses.
| Business Glossary: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
| Data visualization: |
|
| Free edition: |
|
| Metadata management: |
|
| Notifications: |
|
Qlik Sense
Qlik Sense is the best-in-class visualization and discovery tool that uses AI to help your users understand and use data more effectively, minimizing cognitive bias, amplifying discovery, and elevating data literacy. It combines a real-time data pipeline with action-oriented analytics capabilities, creating Active Intelligence that provides in-the-moment insights and drives immediate action.
| Business Glossary: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
| Data visualization: |
|
| Free edition: |
|
| Metadata management: |
|
| Notifications: |
|
erwin Data Intelligence
erwin Data Intelligence combines automation with market-leading data cataloging, data stewardship, and self-service data discovery in a single software suite so your enterprise can discover data, harvest data, structure and deploy data sources, analyze metadata, assess and manage data quality, and do a lot more. With erwin Data Intelligence, you can automate the discovery, assessment, and governance of enterprise data assets.
| Business Glossary: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
| Data visualization: |
|
| Free edition: |
|
| Metadata management: |
|
| Notifications: |
|
Trifacta
Trifacta offers a unique end-to-end data wrangling tool to conduct a data discovery process by taking raw data sources and transforming them into the appropriate format for analysis. With Trifacta, the user is able to see how the data will be used for different types of analysis. Trifacta has a six-step iterative data-wrangling process that leads to a more accurate analysis. The steps include discovering, structuring, cleansing, enriching, validating, and publishing. Moreover, it provides users with the best visualization for each specific type of data automatically.
| Business Glossary: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
| Data visualization: |
|
| Free edition: |
|
| Metadata management: |
|
| Notifications: |
|
SAP Agile Data Preparation
SAP Agile Data Preparation lets you discover, acquire, prepare, assess the quality of, enhance, and share data with a visual, interactive interface that helps eliminate the inefficiencies of traditional approaches – without depending on IT for help. You can quickly connect to and upload multiple data sets, including relational databases or files, on-premise and in the cloud. The software will then help you discover and understand the data, cleanse, enrich, and combine your data.
| Business Glossary: |
|
|---|---|
| Data Lineage: |
|
| Data Profiling: |
|
| Data visualization: |
|
| Free edition: |
|
| Metadata management: |
|
| Notifications: |
|
Data enables companies to make informed decisions and understand needs of the customer and the business. In order to leverage data, data discovery tools help organizations visualize, analyze and get insights from it. They start by collecting data from multiple sources to then consolidate, classify, and catalog it into a single repository to simplify its evaluation.
Collecting, cleaning and preparing data in order to gain insights from it is crucial for any business. Data discovery tools enable organizations to look deeper into data, get important insights and share them across the whole company. But at the same time, they help prevent exposure of sensitive data, and enable the organization to implement appropriate security measures.
Other features data discovery tools provide with are:
Machine learning capabilities, including predictive analytics
In-memory analytics, enabling faster query response times
Data preparation and tools to improve data quality
Metadata management
In order to help you find the right data discovery tool for your organization, we’ve listed some of the best softwares that will empower your team to detect informative patterns and extract valuable insights.