SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Data quality tools for Azure SQL Database
Data quality tools measure how good and useful a data set is to serve its intended purpose. High quality data can lead to better decision-making and faster insights as well as reduce the costs of identifying and dealing with bad data in the system. It can also save time and allow companies to focus on more important tasks.
Dataedo
Dataedo is a data governance & data catalog tool that helps you ensure data quality while documenting data. It allows you to understand where your data is coming from through data lineage, peak into values itself to validate quality with data profiling, and gather invaluable feedback from the community.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
Trifacta
Trifacta is an open and interactive cloud platform for data engineers and analysts to collaboratively profile, prepare, and pipeline data for analytics and machine learning. It presents automated visual representations of data based upon its content in the most compelling visual profile. In addition, every profile is completely interactive, allowing the user to simply select certain elements of the profile to prompt transformation suggestions.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
BigID
BigID offers actionable data intelligence by empowering you to find, classify, catalog, profile and get context for all your data in the cloud or data-center, at-rest or in-motion, structured or unstructured at petabyte scale. It lets you identify sensitive data using hundreds of pre-built NLP, Deep Learning, and pattern classifiers.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
Ataccama ONE
Ataccama ONE offers self-driving data quality management by letting you quickly understand the state of your data, validate & improve it, prevent bad data from entering your systems, and continuously monitor data quality.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
Aperture Data Studio
Aperture Data Studio combines self-service data quality with globally curated data sets into a single data quality platform. This empowers modern data practitioners to build a consistent, accurate, and holistic view of their consumer data quickly and effortlessly. It lets you set custom workflows for data profiling, cleansing, validation, transformation, enrichment, and deduplication.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
RightData
RightData is a self-service suite of applications that helps you achieve Data Quality Assurance, Data Integrity Audit and Continuous Data Quality Control with automated validation and reconciliation capabilities.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
Atlan
Atlan uses DataOps to create a new paradigm for building trust in your data. It auto-generates data quality profiles which make detecting bad data dead easy. From automatic variable type detection & frequency distribution to missing values and outlier detection, Atlan offers everything.
| Commercial: | Commercial |
|---|---|
| Data cleansing: |
|
| Data Discovery & Search: |
|
| Data Profiling: |
|
| Data standarization: |
|
| Free edition: |
|
Data quality tools are the scripts that support the data quality processes and they heavily rely on identification, understanding, and correction of data errors. Data quality tool enhances the accuracy of the data and helps to ensure good data governance all across the data-driven cycle.
The common functions that each data quality tools must perform are:
• Data profiling
• Data monitoring
• Parsing
• Standardization
• Data enrichment
• Data cleansing
Choosing the right data quality tool is essential and impacts the final results. To help you with the right selection, we prepared a list of tools that will assist you with maintaining a high level of data quality.