Informatica Cloud Data Validation vs Datafold
Verdict: Informatica Cloud Data Validation scores 8.3/10 against 7.8/10 for Datafold on our data score for data reconciliation tools.
Informatica Cloud Data Validation and Datafold lead on 0 checks each; 7 are even, out of 7 checks (yes/no, price and seats) where we have data for both.
Choose Informatica Cloud Data Validation for informatica IDMC customers validating integration jobs and PowerCenter-to-cloud migrations. Choose Datafold for analytics engineering teams using dbt and teams validating warehouse migrations.
Scoreboard: 7 checks
| Check | Informatica Cloud Data Validation | Datafold |
|---|---|---|
| Free plan | Even | Even |
| Free trial | Even | Even |
| Smaller seat minimum | Even | Even |
| Row-level reconciliation | Even | Even |
| Cross-database comparison | Even | Even |
| File-to-database comparison | Even | Even |
| Scheduled test runs | Even | Even |
| Total | 0 | 0 |
At a glance
| Informatica Cloud Data Validation | Datafold | |
|---|---|---|
| Score | 8.3/10 (#3) | 7.8/10 (#5) |
| Best for | Informatica IDMC customers validating integration jobs and PowerCenter-to-cloud migrations | Analytics engineering teams using dbt and teams validating warehouse migrations |
| Free plan | No | No |
| Paid from (annual) | See vendor | See vendor |
| Paid from (monthly) | — | — |
| Free trial | — | — |
| Minimum seats | 1 | 1 |
| Platforms | Cloud (IDMC) with Secure Agent | Cloud (SaaS, multi-tenant), Dedicated single-tenant cloud, Customer-hosted in AWS, GCP or Azure (operated by Datafold) |
Features
| Tool | Score | Row-level reconciliation | Cross-database comparison | File-to-database comparison | Scheduled test runs | Alerts (email, Slack or Teams) |
|---|---|---|---|---|---|---|
| Informatica Cloud Data Validation | 8.3/10 | Yes | Yes | Yes | Yes | Yes |
| Datafold | 7.8/10 | Yes | Yes | Yes | Yes | Not confirmed |
- Only Informatica Cloud Data Validation confirms: Alerts (email, Slack or Teams).
Pros and cons
Informatica Cloud Data Validation
Pros- Connects to Snowflake, Databricks Delta, Google BigQuery, Redshift, Oracle, SQL Server, Teradata, SAP HANA, Salesforce and more
- Compares Avro, CSV, JSON, ORC and Parquet files in ADLS Gen2, and flat or Parquet files in S3
- Reports list unmatched, missing and extra records; scheduling and email notifications are built in
- Wizard-based test creation with automatic column mapping
- Only available inside Informatica IDMC; needs a Cloud Data Validation license plus several transformation licenses
- The Secure Agent that runs tests needs at least 32 GB memory; sub-organizations are not supported
- Pricing is consumption-based (IPUs) and not published
Datafold
Pros- Value-level, row-and-column diffs across databases, including Snowflake, Databricks, BigQuery, Redshift, Oracle, SQL Server and Teradata
- File diffing for CSV/TSV, Excel and Parquet files in S3, ADLS or GCS, including file-to-table comparisons
- CI integration runs diffs on each pull request with dbt, Airflow or any git repository
- SOC 2, HIPAA and GDPR compliance; SSO via SAML, Okta and Google
- No public pricing; the pricing URL redirects to a contact form and multi-tenant sign-up is by invitation
- In the current version, data diff monitors do not send notifications yet (Slack, Teams and PagerDuty alerts are documented for Datafold Classic)
- File diffing does not list JSON or XML files
Frequently asked questions
How do Informatica Cloud Data Validation and Datafold compare on features and price?
Informatica Cloud Data Validation and Datafold lead on 0 checks each; 7 are even, out of 7 checks (yes/no, price and seats) where we have data for both.
Is Informatica Cloud Data Validation better than Datafold?
Informatica Cloud Data Validation scores 8.3/10 against 7.8/10 for Datafold on our data score for data reconciliation tools. Informatica Cloud Data Validation is best for informatica IDMC customers validating integration jobs and PowerCenter-to-cloud migrations; Datafold is best for analytics engineering teams using dbt and teams validating warehouse migrations.
Which is cheaper, Informatica Cloud Data Validation or Datafold?
Check each vendor's pricing page; one of them does not publish an entry price.
Do Informatica Cloud Data Validation and Datafold have free plans?
Informatica Cloud Data Validation: no. Datafold: no.
See the full Data Reconciliation Tools ranking for other options.
Sources
- Informatica Cloud Data Validation: official pricing page · Informatica Data Validation: introduction · Informatica Data Validation: test case connections · Informatica Data Validation: creating a test case · Informatica Data Validation: test cases · Informatica IDMC pricing page
- Datafold: official pricing page · Datafold Data Diff page · Datafold CI/CD testing page · Datafold docs: data connections · Datafold docs: file diffing · Datafold docs: data diff monitors · Datafold docs: deployment options