Skip to main content

Product summary

The following table summarizes Validata features and capabilities.

Feature

Notes

Version

1.1.0

Deployment

Supported data systems

  • Databases: MySQL, Oracle, PostgreSQL, SQL Server.

  • Data warehouses: BigQuery, Databricks, Snowflake.

Supported data types

  • Standard scalar types (numeric, string, temporal, boolean).

  • Data types such as binary are not supported. See Supported data systems for details.

Validation methods

  • Built-in methods include:

    • Full-dataset validation: Vector Validation, Fast Record Validation, Full Record Validation

    • Partial-dataset validation: Key Validation, Interval Validation

  • Additional methods include Custom Validation.

Validation pair comparison outcomes

  • Data comparison outcomes:

    • In-Sync

    • Out-of-Sync (Content Mismatch, Extra in Source, Extra in Target)

    • Halted

  • Other outcomes:

    • Canceled

    • Skipped

Validation schedule

  • One-time (manually triggered)

  • Recurring schedule (hourly, daily, weekly).

Reconciliation

  • SQL-based reconciliation scripts generated for a validation pair if the comparison outcome is Out-of-Sync or Halted.

  • You can download the reconciliation script from the Validation Pair Report.

Report store

  • You can view comparison reports in the Validata UI or download the JSON reports.

  • Validation reports are stored in Validata Historian. Historian is hosted on a database that ships with Validata and is installed and configured as part of Validata deployment. You can also host Historian in an Oracle or PostgreSQL database. See Configuring Validata Historian for details.

Observability

  • Receive alerts via email, Slack, or Microsoft Teams when a validation starts, completes, or fails to complete, and at other major events.

  • Monitor the CPU and memory resources consumed by the Validata server.