<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=789673508300973&amp;ev=PageView&amp;noscript=1">
Skip to main content
Solutions · Platform

Data Testing Wherever Your Data Lives

In the cloud, on your servers or behind your firewall, Validatar connects to your data.

Cloud warehouses, on-premises databases, files, BI reports, and APIs. Run Validatar in our cloud or on your own servers, and reach data behind your firewall with the Validatar Data Agent.

Compare data across platforms

Wherever your data lives

Validatar
In the cloud
  • Snowflake
  • Databricks
  • Google BigQuery
  • Amazon S3
On your servers
  • SQL Server
  • Oracle
  • Teradata
  • PostgreSQL
Behind your firewall

Reached by the Validatar Data Agent

  • On-premises databases
  • Windows directories
  • SFTP

Databases, cloud storage, BI reports, and files, side by side in Validatar's catalog.


How Does Validatar Reach Your Data?

Run Validatar in our cloud or on your own servers. Add the Data Agent wherever data sits behind a firewall.

Validatar CloudSaaSValidatar ServerSelf-hosted
Where it runsValidatar's multi-tenant cloud, hosted in the USYour own environment, on premises or in the cloud of your choice
Who maintains itWe do. Nothing to install or upgradeYour team, on Windows or Linux, with SQL Server or PostgreSQL behind it
SecuritySOC 2 Type II and HIPAA compliant
Visit our Trust Center →
Inside your own security perimeter
Best forThe fastest startTeams whose rules require self-hosting

Validatar Data Agent, for either option

Data behind your firewall stays reachable without opening it up. The agent inside your network picks up work, runs the queries next to your data, and sends back the results.

Your network

Databases Files and storage BI reports and APIs
Data Agent

Windows, Linux, or Kubernetes

Validatar

Cloud or Server

Results and execution history

Using Snowflake or Databricks as the processing engine? The agent sends test data straight into your own account, and results stay there. See where results live ↓

1

Picks up work

The agent connects out to Validatar to get the tests it should run.

2

Runs next to your data

Queries run inside your network, through ODBC or Python on the agent's host.

3

Sends results back

Results go to Validatar Cloud or Server, or straight to your Snowflake or Databricks account.

Installed inside your network on Windows, Linux, or Kubernetes, to reach data behind your firewall that can't be exposed.

How the Data Agent works →

Architecture · Powered by Snowflake and Databricks

Where Do Your Test Results Live?

Choose a processing engine for each data source. With Snowflake or Databricks, comparisons run inside your own account and results are stored there. Only the summary of each comparison goes back to Validatar.

Built-in engineSnowflakeDatabricks
Where comparisons runIn memory on the Validatar web serverInside your Snowflake accountOn a Databricks SQL warehouse in your environment
What goes to ValidatarBoth datasets, for processingOnly the summary resultOnly the summary result
Where results are storedThe Validatar repository, Snowflake, or DatabricksA dedicated results repository in your Snowflake accountA catalog and schema you control in Databricks
Data from other sourcesRead by Validatar or the Data AgentQuery results are sent by the Data Agent straight into SnowflakeQuery results are pushed into temporary tables in Databricks

Your data stays in your platform

Data already in Snowflake or Databricks is compared where it sits. Data from other sources goes through your Data Agent into your account, not through Validatar Cloud.

Query your test history like any other data

Repository replication syncs Validatar's metadata, test executions, profiles, and trust scores into a Snowflake or Databricks schema on a schedule, ready for BI dashboards, alerts, and governance tools.

For engineers

Architecture: Powered by SnowflakeWhat runs where, and what comes back to Validatar. How processing engines workHow comparisons run inside Snowflake or Databricks. Replicating your Validatar metadataSync test results and trust scores into your own schema.

What Can Validatar Connect To?

Ready-made connectors come with quick tests and macros, so standard sources are tested on day one. 

Cloud platforms

Snowflake →Databricks →Microsoft AzureAmazon Web Services

Cloud warehouses and lakes

Google BigQueryAmazon RedshiftAzure SynapseMicrosoft FabricAWS AthenaAzure Data Lake Storage

Databases

SQL ServerOraclePostgreSQLMySQLTeradataNetezzaAmazon RDS

Files and storage

Amazon S3Azure Blob StorageSFTPWindows directories

Apps, reports, and APIs

SalesforcePower BIJiraREST APIs

Data catalogs

AlationAtlanCollibra

Anything else

ODBCCDataPython framework

See every connector template →See connectors in the product →See cloud integrations in the product →


Platforms and Deployment FAQ

Short answers for architects and security teams.

Should we use Validatar Cloud or Validatar Server?

Cloud is fastest to start, with nothing to maintain. Server runs in your own environment for teams whose rules require it. Compare the two.

Can Validatar test data behind our firewall?

Yes. The Validatar Data Agent runs inside your network and reaches databases that can't be exposed to the internet.

What if our source isn't on the list?

Most sources connect through ODBC or CData. For custom APIs and file types, the open Python framework lets you build your own connection.

Can we compare data across two different platforms?

Yes. A test can read one side from one platform and the other side from another, such as Oracle and Snowflake. See data reconciliation.

Further reading

More from the Holistic Data QA blog →

Solutions on any platform

Cloud Migrations Data Reconciliation ETL Testing & Monitoring Data Quality Data and AI Governance

For engineers

Connecting to dataHow Validatar connects to each kind of source. Validatar Data AgentReach data behind your firewall. Validatar Cloud architectureWhat runs where when we host Validatar. Validatar Server architectureWhat runs where when you host it yourself.

See Validatar on Your Platforms

Tell us where your data lives, and we'll show you how Validatar reaches it.

Request a Demo → Compare Cloud and Server