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: Yes
Data Lineage: Yes
Data Profiling: Yes
Data visualization: No
Free edition: No
Metadata management: Yes
Notifications: Yes
Dataedo Data Search
Dataedo Data Profiling
Dataedo Data Lineage
Dataedo Business Glossary
Dataedo Sensitive Data Discovery
Dataedo Data Catalog

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: Yes
Data Lineage: Yes
Data Profiling: Yes
Data visualization: Yes
Free edition: No
Metadata management: Yes
Notifications: Yes

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: Yes
Data Lineage: Yes
Data Profiling: Yes
Data visualization: Yes
Free edition: No
Metadata management: Yes
Notifications: Yes

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: No
Data Lineage: Yes
Data Profiling: No
Data visualization: Yes
Free edition: No
Metadata management: Yes
Notifications: Yes

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: No
Data Lineage: No
Data Profiling: No
Data visualization: Yes
Free edition: No
Metadata management: No
Notifications: Yes

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: No
Data Lineage: Yes
Data Profiling: No
Data visualization: Yes
Free edition: Yes
Metadata management: No
Notifications: Yes

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: No
Data Lineage: No
Data Profiling: No
Data visualization: Yes
Free edition: No
Metadata management: No
Notifications: Yes

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: No
Data Lineage: Yes
Data Profiling: No
Data visualization: Yes
Free edition: Yes
Metadata management: No
Notifications: Yes

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: No
Data Lineage: Yes
Data Profiling: Yes
Data visualization: Yes
Free edition: No
Metadata management: Yes
Notifications: No

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: No
Data Lineage: Yes
Data Profiling: Yes
Data visualization: Yes
Free edition: Yes
Metadata management: Yes
Notifications: Yes

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: Yes
Data Lineage: Yes
Data Profiling: Yes
Data visualization: Yes
Free edition: No
Metadata management: Yes
Notifications: Yes

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: No
Data Lineage: Yes
Data Profiling: Yes
Data visualization: Yes
Free edition: No
Metadata management: Yes
Notifications: Yes

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: No
Data Lineage: No
Data Profiling: Yes
Data visualization: Yes
Free edition: No
Metadata management: Yes
Notifications: Yes

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.