Data profiling tools for MS Access

Data Profiling tools allow analyzing, monitoring, and reviewing data from existing databases in order to provide critical insights. Data profiling can help organizations improve data quality and decision-making process by identifying problems and addressing them before they arise.

Dataedo

Dataedo is a metadata management & data catalog tool with a data profiling feature. It allows you to use sample data to learn what data is stored in your data assets. You can browse min, max, average and median values, see top values, as well as value and row distribution to understand the data better before using it.

Access control: Yes
Commercial: Commercial
Desktop/Cloud: Desktop
Excel workbooks: Yes
Flat files: Yes
Free edition: No
Metadata identification: Yes
NoSQL sources: Yes
Runs on: (for desktop): Windows
Sensitive data discovery: Yes
SQL sources: Yes
Statistics of data: Avg,Max,Min,Stdev
Tagging data: -
Data Profiling in Desktop
Dataedo Data Profiling

Global IDs Data Profiling Suite

Global IDs Data Profiling Suite is a data discovery and profiling tool that automates the discovery of data assets, automates data profiling, and provides an active inventory of all data assets.

Access control: No
Commercial: Commercial
Desktop/Cloud: Desktop
Excel workbooks: Yes
Flat files: Yes
Free edition: No
Metadata identification: Yes
NoSQL sources: Yes
Runs on: (for desktop): Linux
Sensitive data discovery: Yes
SQL sources: Yes
Statistics of data: -
Tagging data: Yes

Datiris Profiler (discontinued)

Datiris Profiler is an intuitive data profiling tool. Its key features include cross-table analysis, domain validation, pattern analysis, conditional profiling, command-line interface, and many more. Besides that, with features such as batch profiling, you can queue up and profile data quickly and spend your time analyzing instead of gathering it.

Access control: No
Commercial: Commercial
Desktop/Cloud: Desktop
Excel workbooks: Yes
Flat files: Yes
Free edition: No
Metadata identification: Yes
NoSQL sources: No
Runs on: (for desktop): Windows
Sensitive data discovery: No
SQL sources: Yes
Statistics of data: -
Tagging data: Yes

IBM InfoSphere Information Analyzer

IBM InfoSphere Information Analyzer provides data profiling and analysis to accurately evaluate the content and structure of your data for consistency and quality. It utilizes a reusable rules library and supports multi-level evaluations by rule record and pattern. It also facilitates the management of exceptions to established rules to help identify data inconsistencies, redundancies and anomalies, and make inferences about the best choices for structure.

Access control: Yes
Commercial: Commercial
Desktop/Cloud: Desktop
Excel workbooks: Yes
Flat files: Yes
Free edition: No
Metadata identification: Yes
NoSQL sources: Yes
Runs on: (for desktop): Linux,Windows
Sensitive data discovery: Yes
SQL sources: Yes
Statistics of data: Avg,Stdev
Tagging data: Yes

Oracle Data Profiling and Data Quality for Data Integrator

Oracle Data Profiling is a data investigation and quality monitoring tool. It allows business users to assess the quality of their data through metrics, to discover or infer rules based on this data, and to monitor the evolution of data quality over time.

Access control: No
Commercial: Free
Desktop/Cloud: Desktop
Excel workbooks: No
Flat files: Yes
Free edition: Yes
Metadata identification: Yes
NoSQL sources: No
Runs on: (for desktop): Linux,Windows
Sensitive data discovery: No
SQL sources: Yes
Statistics of data: -
Tagging data: No

Open Source Data Quality and Profiling

Open Source Data Quality and Profiling tool is an open source project dedicated to data quality and data preparation solutions. This tool is developing high performance integrated data management platform which will seamlessly do data integration, data profiling, data quality, data preparation, dummy data creation, meta data discovery, anomaly discovery, data cleansing, reporting, and analytic.

Access control: No
Commercial: Free
Desktop/Cloud: Desktop
Excel workbooks: Yes
Flat files: No
Free edition: Yes
Metadata identification: Yes
NoSQL sources: Yes
Runs on: (for desktop): Mac OS,Windows
Sensitive data discovery: No
SQL sources: Yes
Statistics of data: -
Tagging data: No

Acuate Data Profiling

Acuate Data Profiling tool enables you to find data problems quickly. It lets you select from a range of profiling rules to analyze your data. It can analyze data by character type or by word and lets you dive deeper into the details by drilling down into the data.

Access control: No
Commercial: Commercial
Desktop/Cloud: Desktop
Excel workbooks: Yes
Flat files: Yes
Free edition: No
Metadata identification: Yes
NoSQL sources: No
Runs on: (for desktop): Windows
Sensitive data discovery: No
SQL sources: No
Statistics of data: -
Tagging data: No

Data Ladder

Data Ladder’s DataMatch Enterprise offers one of the easiest to use data profiling tools in the market. It quickly provides enough metadata to construct a cogent profile analysis of data quality and quantifies the scope and depth of necessary add-ons to make the project successful. Once it does the profiling, it proceeds to perform data matching, cleansing, deduplication and standardization, finally achieving data validation.

Access control: No
Commercial: Commercial
Desktop/Cloud: Desktop
Excel workbooks: Yes
Flat files: Yes
Free edition: No
Metadata identification: Yes
NoSQL sources: Yes
Runs on: (for desktop): Windows
Sensitive data discovery: No
SQL sources: Yes
Statistics of data: Avg,Max,Min
Tagging data: No

Talend Data Fabric

Talend Data Fabric combines data integration, integrity, and governance in a single, unified platform. Talend Data Fabric's capabilities allow you to extract, process, and profile data from virtually any source to your data warehouse. Data profiling lets you quickly identify data quality issues, discover hidden patterns, and spot anomalies through summary statistics and graphical representations.

Access control: No
Commercial: Commercial
Desktop/Cloud: Desktop
Excel workbooks: Yes
Flat files: Yes
Free edition: No
Metadata identification: Yes
NoSQL sources: Yes
Runs on: (for desktop): Mac OS,Windows
Sensitive data discovery: No
SQL sources: Yes
Statistics of data: -
Tagging data: Yes

Toad Data Point

Toad Data Point is a multi-platform database query, data prep, and reporting tool. It lets you visually profile and sample database tables and data sets for patterns, unique values, duplicates, missing information, min./max. values and more.

Access control: No
Commercial: Commercial
Desktop/Cloud: Desktop
Excel workbooks: Yes
Flat files: Yes
Free edition: No
Metadata identification: Yes
NoSQL sources: Yes
Runs on: (for desktop): Windows
Sensitive data discovery: No
SQL sources: Yes
Statistics of data: Avg,Max,Min,Stdev
Tagging data: Yes

WinPure Clean & Match

The Data Profiling / Statistics module within WinPure Clean & Match is a user-friendly and powerful data profiling tool that can help your business to discover patterns and meaning in your data and to check the quality of your data by analyzing formats, types, completeness, and value counts. It presents you with a complete set of statistics that you can use to help clean and correct your data, and to prepare it better for data matching.

Access control: No
Commercial: Commercial
Desktop/Cloud: Desktop
Excel workbooks: Yes
Flat files: Yes
Free edition: Yes
Metadata identification: No
NoSQL sources: No
Runs on: (for desktop): Windows
Sensitive data discovery: No
SQL sources: Yes
Statistics of data: -
Tagging data: No

Astera Centerprise

Astera Centerprise is an end-to-end data integration software that enables you to integrate, cleanse, and transform data in a code-free environment. Its built-in data profiling feature lets you easily examine your source data and get detailed information about its structure, quality, and integrity. Custom data integration and quality rules can also be defined to validate incoming data and identify missing or invalid records.

Access control: Yes
Commercial: Commercial
Desktop/Cloud: Desktop
Excel workbooks: Yes
Flat files: Yes
Free edition: No
Metadata identification: No
NoSQL sources: No
Runs on: (for desktop): Windows
Sensitive data discovery: No
SQL sources: Yes
Statistics of data: Avg,Max,Min
Tagging data: No

DataCleaner

The heart of DataCleaner is a strong data profiling engine for discovering and analyzing the quality of your data. Find the patterns, missing values, character sets and other characteristics of your data values.

Access control: No
Commercial: Free
Desktop/Cloud: Desktop
Excel workbooks: Yes
Flat files: Yes
Free edition: Yes
Metadata identification: No
NoSQL sources: Yes
Runs on: (for desktop): Linux,Mac OS,Windows
Sensitive data discovery: No
SQL sources: Yes
Statistics of data: -
Tagging data: No

Alation Data Catalog

Alation’s data profiling capabilities help reduce the time spent in the data exploration phase. With Alation’s data profile, data consumers have the metrics they need to easily discern the quality of any data object. Alation displays important characteristics, statistics, and numerical graphs about the data — enabling data scientists and data engineers to quickly take action. The data profiling now also includes new charts and customizations.

Access control: No
Commercial: Commercial
Desktop/Cloud: Cloud
Excel workbooks: No
Flat files: Yes
Free edition: No
Metadata identification: Yes
NoSQL sources: Yes
Runs on: (for desktop): -
Sensitive data discovery: Yes
SQL sources: Yes
Statistics of data: -
Tagging data: Yes

The use of data profiling tools can lead to higher-quality, more reliable data or eliminating errors that add costs to data-driven projects. Eliminating these costly errors involve processes such as:

• Collecting descriptive statistics.
• Collecting data types, length and recurring patterns.
• Tagging data with keywords, descriptions or categories.
• Performing data quality assessment.
• Discovering metadata and assessing its accuracy.

The most efficient way of handling the data profiling process is to automate it with a data management solution. We prepared a list of open-source data profiling tools that help you carry out the analysis of your data and identify the issues.