Supported data systems

In this edition, Validata supports the following data systems:

You can use Validata to compare data in the same data system, such as tables in a PostgreSQL database running on-premise and tables in a PostgreSQL database running in a cloud VM, or compare data between different data systems, such as tables in Amazon RDS for Oracle and tables in BigQuery. When comparing data across different systems, Validata applies normalization rules to handle differences in how each system stores datatypes such as numeric precision, date formats, and character padding. For details on these comparison rules, see Datatype comparison rules.

Schemas, Tables, and Columns with a dot character (.) in their names are not supported, as this will cause issues with identifiers used in queries to fetch the table data. For example, the table name “employee.data" would be enclosed as "employee"."data", which is interpreted as two 2-part names.