Validatar in partnership with CData Software has made CData's catalog of 228 data sources through ADO.NET providers available directly within Validatar Cloud and Validatar Server.
See below for the full list of available data sources. Search by name, table or authentication method, or filter by category, then open a source to see what Validatar can read, how to set up authentication and begin exploring.
Read-only access
Validatar is primarily designed for read only access from these sources. 182 of the providers have a Readonly connection property. By default, Validatar sets Readonly=True on those connections, and the provider then accepts SELECT queries only: inserts, updates, deletes and stored procedure calls fail.
The other 46 providers have no such property, so connect them with credentials that can only read. The page for each source names the permission to grant.
Browse the library
RDBMS (24)
| Data source | What you can test |
|---|---|
| Access | Connect Validatar to Microsoft Access to test tables and saved queries in .mdb and .accdb files, and check desktop data against the systems that depend on it. |
| AlloyDB | Connect Validatar to Google AlloyDB to test the PostgreSQL-compatible tables behind your applications and check that analytics copies still match them. |
| Azure Analysis Services | Connect Validatar to Azure Analysis Services to query tabular models, measures and KPIs with SQL, and confirm model figures match the warehouse beneath them. |
| Azure Synapse | Connect Validatar to Azure Synapse to reconcile each pipeline load with the systems it came from and catch broken dimension keys before reports refresh. |
| DB2 | Connect Validatar to IBM DB2 to test tables and views on z/OS, IBM i or Linux, UNIX and Windows, and reconcile system-of-record data with your warehouse. |
| EnterpriseDB | Connect Validatar to EnterpriseDB to test EDB Postgres Advanced Server tables and check, table by table, that data moved from Oracle arrived intact. |
| Greenplum | Connect Validatar to Greenplum to test distributed and external tables on the MPP warehouse, and check each load against the external table it was read from. |
| IBM Informix | Connect Validatar to IBM Informix to test operational tables where they run and confirm that the warehouse and replicas still match them. |
| Impala | Connect Validatar to Apache Impala to test Parquet-backed tables on Hadoop and catch late or missing data before reports read it. |
| Lakebase | Connect Validatar to Lakebase to test its Postgres tables and match them key by key with related tables in your analytics layer. |
| MariaDB | Connect Validatar to MariaDB to compare a primary with its read replica and warehouse copies, and find the zero dates and stray ENUM values that break downstream loads. |
| MySQL | Connect Validatar to MySQL to test tables and views on your own servers or on AWS, Azure and Google Cloud, and reconcile them with your warehouse. |
| Oracle | Connect Validatar to Oracle Database to test tables and views, reconcile them with downstream systems and track data quality across releases. |
| PostgreSQL | Connect Validatar to PostgreSQL to profile tables, compare them with downstream copies and monitor data quality, on premises or in the cloud. |
| SAP Business One | Connect Validatar to SAP Business One to test sales orders, purchase orders, items and accounts, and reconcile ERP figures with your warehouse. |
| SAP HANA | Connect Validatar to SAP HANA to test row and column store tables and calculation views, and reconcile HANA figures with source and reporting systems. |
| SAP HANA XS Advanced | Connect Validatar to SAP HANA XS Advanced to test the CDS views and calculation views your XSA applications expose, and compare them with HANA base tables. |
| SAP Hybris C4C | Connect Validatar to SAP Hybris C4C to test leads, opportunities, accounts and activities, and compare CRM pipeline figures with your warehouse. |
| SingleStore | Connect Validatar to SingleStore to watch ingest lag on its distributed tables and compare per-minute event counts with the source feeding them. |
| SQL Analysis Services | Connect Validatar to SQL Server Analysis Services to query cubes, dimensions and measures with SQL or MDX, and reconcile cube numbers with the warehouse. |
| Sybase | Connect Validatar to Sybase to check SAP Adaptive Server Enterprise tables and reconcile long-running ASE systems with the platforms taking over from them. |
| Sybase IQ | Connect Validatar to Sybase IQ to test column-store tables in Sybase IQ or SAP SQL Anywhere, and reconcile analytic totals with source systems. |
| Teradata | Connect Validatar to Teradata to compare warehouse tables with their migrated cloud copies and check daily loads before the business day starts. |
| xBase | Connect Validatar to xBase to test .dbf tables from FoxPro, Clipper and dBase systems, and compare legacy files with the databases taking their place. |
Big Data & NoSQL (28)
| Data source | What you can test |
|---|---|
| Amazon Athena | Connect Validatar to Amazon Athena to test the tables and views in your AWS Glue Data Catalog, and check data in S3 before it reaches reports. |
| Amazon DynamoDB | Connect Validatar to Amazon DynamoDB to check items for missing attributes and duplicate keys, and compare item counts with downstream copies. |
| Anaplan | Connect Validatar to Anaplan to read workspaces, models and export output, and compare plan figures with the actuals in your warehouse or ERP. |
| Azure Data Catalog | Connect Validatar to Azure Data Catalog to compare registered tables, columns and data profiles with the real sources, and find assets with no description or expert. |
| Azure Table | Connect Validatar to Azure Table Storage to watch entity counts per partition and catch tables that stop receiving new entities. |
| BigQuery | Connect Validatar to Google BigQuery to reconcile datasets with the systems that feed them and catch late partitions, in standard or legacy SQL. |
| Cassandra | Connect Validatar to Apache Cassandra or DataStax Enterprise to test wide-column tables with SQL and reconcile them against the stores they feed. |
| Cloudant | Connect Validatar to IBM Cloudant to profile JSON documents with SQL and compare each database's contents with the copy in your warehouse. |
| CockroachDB | Connect Validatar to CockroachDB to reconcile its tables with your warehouse and catch the null spikes and orphaned rows an application release can leave behind. |
| Cosmos DB | Connect Validatar to Azure Cosmos DB to find missing or mistyped fields in container documents and compare container counts with the tables loaded downstream. |
| Couchbase | Connect Validatar to Couchbase to test JSON documents in buckets, scopes and collections, and compare them with the tables your pipelines build from them. |
| CouchDB | Connect Validatar to Apache CouchDB to test JSON documents and views with SQL, and catch a database whose document count drops overnight. |
| Databricks | Connect Validatar to Databricks to test Delta tables and views at each layer of the lakehouse and reconcile them with the source systems that feed them. |
| Elasticsearch | Connect Validatar to Elasticsearch to compare what your search indexes hold with the database they are built from, down to document counts and field values. |
| Google Spanner | Connect Validatar to Google Spanner to test tables, interleaved ones included, and reconcile operational data with BigQuery or another analytics warehouse. |
| GraphQL | Connect Validatar to a GraphQL API to query its types as tables and compare what the API returns with what your pipelines loaded. |
| HBase | Connect Validatar to Apache HBase to test tables, column families and rows with SQL, and compare sparse HBase data with the systems that feed it. |
| Hive | Connect Validatar to Apache Hive to check partitioned tables on Hadoop as each day's data lands, and reconcile Hive totals with the systems upstream. |
| Kafka | Connect Validatar to Apache Kafka to query topics as tables, check message contents and compare event streams with the tables they land in. |
| MarkLogic | Connect Validatar to MarkLogic to test document data through template views, profile the fields your templates extract and compare them with downstream tables. |
| MongoDB | Connect Validatar to MongoDB to test document collections with SQL, catch schema drift and compare documents with the tables built from them. |
| Neo4J | Connect Validatar to Neo4j to test nodes, relationships and their properties with SQL, and compare graph data with the relational systems it is built from. |
| Phoenix | Connect Validatar to Apache Phoenix to test the SQL tables and secondary indexes it keeps on HBase, and catch rows where a table and its index disagree. |
| Presto | Connect Validatar to Presto or Trino to test catalogs, schemas and tables across every source the cluster federates, and compare data between them. |
| Redis | Connect Validatar to Redis to query keys, hashes, lists, sets and streams with SQL, and check cached values against the system of record. |
| Redshift | Connect Validatar to Amazon Redshift to check each load against its source, Spectrum external tables included, and spot stalled loads from the system tables. |
| Snowflake | Connect Validatar to Snowflake to profile tables, compare them with source systems and monitor warehouse data quality on a schedule. |
| Spark | Connect Validatar to Apache Spark SQL to test databases, tables and views in the Spark catalog, and compare job outputs with their inputs. |
CRM & ERP (36)
| Data source | What you can test |
|---|---|
| Act CRM | Connect Validatar to Act! CRM to test contacts, companies, opportunities and activities, and find duplicate or incomplete customer records. |
| Act-On | Connect Validatar to Act-On to test contact lists, opt-outs, hard bounces and campaign reports, and keep suppression lists aligned with your CRM. |
| ActiveCampaign | Connect Validatar to ActiveCampaign to test contacts, deals and automations, and catch deals with no value or contacts missing the fields your segments filter on. |
| Acumatica | Connect Validatar to Acumatica ERP to test customers, invoices, bills, journal transactions and inventory, and reconcile ERP balances with your warehouse. |
| Bullhorn CRM | Connect Validatar to Bullhorn CRM to test candidates, job orders, submissions and placements, and reconcile placements with payroll and billing. |
| Certinia | Connect Validatar to Certinia to test projects, resources, timecards, expenses and billing, and reconcile services revenue with your warehouse. |
| Dynamics 365 | Connect Validatar to Dynamics 365 to test Accounts, Leads and Cases, and check that the picklist and status values in your instance match what reports decode. |
| Dynamics 365 Business Central | Connect Validatar to Dynamics 365 Business Central to test customers, items, sales orders and the general ledger, one company at a time or across all of them. |
| Dynamics CRM | Connect Validatar to Dynamics CRM to test Accounts, Contacts and Campaigns, plus your custom entities, in on-premises and hosted instances alike. |
| Epicor Kinetic | Connect Validatar to Epicor Kinetic to test parts, jobs and sales and purchase orders, along with the supplier and inventory records behind production reporting. |
| Exact Online | Connect Validatar to Exact Online to test GL accounts, journal entries and bank entries per division, and reconcile cloud ERP figures with your warehouse. |
| Highrise | Connect Validatar to Highrise to test People, Companies and Deals, and keep a small-business CRM clean enough to report from. |
| HubDB | Connect Validatar to HubDB to test the rows behind your HubSpot CMS pages and watch table and column definitions for unplanned changes. |
| JD Edwards | Connect Validatar to JD Edwards to test the account ledger, payment proposals, contract revenue and benefits enrollment data your AIS Server exposes. |
| NetSuite | Connect Validatar to NetSuite to test transactions, customers, items and custom records, and reconcile ERP figures against your warehouse. |
| Odoo | Connect Validatar to Odoo to test partners, sales orders, invoices and stock, for whichever Odoo apps you run. |
| Oracle Financials Cloud | Connect Validatar to Oracle Financials Cloud to test invoices, receivables, receipts and expense reports, and reconcile finance data with your warehouse. |
| Oracle HCM Cloud | Connect Validatar to Oracle HCM Cloud to test absences, benefit enrollments and assignment costing, and catch HR data gaps before payroll and headcount reports run. |
| Oracle SCM | Connect Validatar to Oracle SCM to test inbound shipments, cycle counts, subinventories and cost adjustments across inventory, manufacturing and order management. |
| Outreach.io | Connect Validatar to Outreach to test prospects, sequences and calls, and reconcile sales engagement activity with your CRM. |
| Pipedrive | Connect Validatar to Pipedrive to test Deals, Persons and Activities, and keep pipeline numbers in step with your warehouse. |
| Sage 300 | Connect Validatar to Sage 300 to test general ledger, receivables, payables and order entry data, from invoices and receipts to fiscal sets. |
| Sage X3 Cloud | Connect Validatar to Sage X3 Cloud to test the ERP tables its REST API returns and reconcile row counts and totals with the copies in your warehouse. |
| Salesforce | Connect Validatar to Salesforce to test Accounts, Opportunities, Leads and custom objects, and catch CRM data problems before they reach your reports. |
| SAP | Connect Validatar to SAP ERP to test tables such as KNA1, VBAK and EKKO, and reconcile customer, sales order and purchase order data with your warehouse. |
| SAP Ariba Source | Connect Validatar to SAP Ariba Source to test sourcing projects, suppliers and contracts, and compare supplier records with your ERP vendor master. |
| SAP ByDesign | Connect Validatar to SAP Business ByDesign to test customers, suppliers, orders and invoices, and reconcile cloud ERP data with your warehouse. |
| SAP Netweaver Gateway | Connect Validatar to SAP Netweaver Gateway to test materials, orders and other entity sets your OData services expose from S/4HANA, S/4HANA Cloud or SAP ERP. |
| ServiceNow | Connect Validatar to ServiceNow to test incidents, change requests, SLAs and CMDB configuration items, custom tables included, before the numbers reach IT service reports. |
| Sugar CRM | Connect Validatar to Sugar CRM to test Accounts, Opportunities, RevenueLineItems and Cases, and spot pipeline gaps before the forecast meeting. |
| SuiteCRM | Connect Validatar to SuiteCRM to test Accounts, Leads, Cases and Invoices, and check the open-source CRM data that feeds sales and support reporting. |
| Tally | Connect Validatar to Tally to test ledgers and stock items, and check trial balance and outstanding bills reports against your warehouse. |
| Vault CRM | Connect Validatar to Vault CRM to test Accounts, Calls, Territories and ConsentLines, and compare field activity and consent records with your commercial warehouse. |
| Workday | Connect Validatar to Workday to test workers, open positions and compensation plans, and reconcile HR and finance data with your warehouse. |
| Zoho CRM | Connect Validatar to Zoho CRM to test Leads, Deals, Quotes and Sales Orders, custom modules included, and keep CRM figures in line with finance. |
| Zoho Inventory | Connect Validatar to Zoho Inventory to test Items, Warehouses, SalesOrders and InventoryAdjustments, and reconcile stock and order data with your books. |
Marketing (30)
| Data source | What you can test |
|---|---|
| Adobe Analytics | Connect Validatar to Adobe Analytics to test page views, visits, orders and revenue, and compare web analytics numbers with sales recorded in your warehouse. |
| Adobe Experience Manager | Connect Validatar to Adobe Experience Manager to test the content nodes, properties and metadata in its JCR repository, on premises or in AEM as a Cloud Service. |
| Cvent | Connect Validatar to Cvent to test Events, Attendees, Sessions and EventBudgetItems, and reconcile registrations and spend with CRM and finance. |
| Connect Validatar to Facebook to test Pages, Posts and PageAndPostInsights, and check social metrics before they land in marketing dashboards. | |
| Facebook Ads | Connect Validatar to Facebook Ads to test Campaigns, AdSets, Ads and AdInsights, and reconcile ad spend with finance and attribution reports. |
| Google Ad Manager | Connect Validatar to Google Ad Manager to test Orders, LineItems, Placements and delivery reports, and reconcile delivered impressions with what you bill. |
| Google Ads | Connect Validatar to Google Ads to test campaigns, ad groups, keywords and stats reports, and compare ad spend and conversions with your own records. |
| Google Analytics | Connect Validatar to Google Analytics 4 to check traffic, engagement and conversion numbers, and compare them with the copies in your warehouse. |
| Google Campaign Manager 360 | Connect Validatar to Google Campaign Manager 360 to test standard, Floodlight and reach reports, and match ad server numbers to your warehouse. |
| Google Search | Connect Validatar to Google Search to query web and image results from your Custom Search Engines, and monitor which of your pages appear for the search terms you track. |
| HubSpot | Connect Validatar to HubSpot to test contacts, companies, deals and tickets, and monitor marketing data before it feeds attribution reports. |
| Connect Validatar to Instagram to test media, stories, comments and account insights from your business profiles, and catch gaps before they skew social reporting. | |
| Connect Validatar to LinkedIn to monitor follower counts and company page statistics, and catch a missing day of social data before anyone reports on it. | |
| LinkedIn Ads | Connect Validatar to LinkedIn Ads to test campaign groups, campaigns and their daily analytics, and spot a lead gen form that has stopped producing responses. |
| MailChimp | Connect Validatar to MailChimp to test audiences, list members, campaigns and e-commerce orders, and catch list problems before a send goes out. |
| Marketo | Connect Validatar to Marketo to test leads, programs, program members and activity history, and confirm marketing data matches your CRM. |
| Microsoft Ads | Connect Validatar to Microsoft Ads to test account structure down to the keyword, and check performance reports against the spend and clicks your warehouse recorded. |
| Oracle Eloqua | Connect Validatar to Oracle Eloqua to test contacts, accounts, campaigns and email activity, and keep B2B marketing data in line with your CRM. |
| Oracle Sales | Connect Validatar to Oracle Sales to test accounts, contacts, opportunities and revenue lines, and reconcile pipeline figures with your warehouse. |
| Connect Validatar to Pinterest to test campaign and ad group analytics against your spend records, and watch catalog feeds for processing issues. | |
| Salesforce CRM Analytics | Connect Validatar to Salesforce CRM Analytics to test datasets and lenses, and confirm the numbers behind your analytics dashboards match Salesforce and your warehouse. |
| Salesforce Marketing | Connect Validatar to Salesforce Marketing Cloud to test subscribers, lists, sends, journeys and data extensions, and compare email results with your warehouse. |
| Salesforce Pardot | Connect Validatar to Salesforce Pardot to test prospects, lists, visitor activity and email stats, and check them against your Salesforce CRM data. |
| Salesloft | Connect Validatar to Salesloft to test people, accounts, cadences and calls, and find dialer calls that never made it into your CRM. |
| SendGrid | Connect Validatar to SendGrid to monitor bounces, blocks, spam reports and delivery stats, and compare contact lists with your CRM. |
| Snapchat Ads | Connect Validatar to Snapchat Ads to test ad accounts, campaigns, ad squads and ads, and reconcile their stats with your marketing warehouse. |
| Splunk | Connect Validatar to Splunk to test saved searches, datasets and data models with SQL, and watch indexes and fired alerts for gaps. |
| SurveyMonkey | Connect Validatar to SurveyMonkey to test surveys, questions, collectors and responses, and compare response counts with the survey data in your warehouse. |
| Twitter Ads | Connect Validatar to Twitter Ads to check that campaigns, line items and promoted tweets line up, and compare daily ad spend with your own media numbers. |
| YouTube Analytics | Connect Validatar to YouTube Analytics to test channel, video and playlist metrics, traffic sources and demographics, and compare them with your warehouse. |
Collaboration (49)
| Data source | What you can test |
|---|---|
| Active Directory | Connect Validatar to Active Directory to test users, groups and computers, and catch stale accounts, unapproved group members and users filed in the wrong OU. |
| Airtable | Connect Validatar to Airtable to test records in the bases your account can open, including the attachments and collaborators linked to each one. |
| Asana | Connect Validatar to Asana to test tasks, projects and portfolios, and check the delivery and time tracking numbers built on them. |
| Azure DevOps | Connect Validatar to Azure DevOps to test work items, builds, pipelines, releases and pull requests, and check the engineering metrics your reports draw from them. |
| Basecamp | Connect Validatar to Basecamp to test projects, to-dos and messages, and see which client work has no owner or has gone quiet. |
| Bitbucket | Connect Validatar to Bitbucket Cloud to test repositories, pull requests and commits, and check the review and permission data behind your engineering reports. |
| Claude Compliance | Connect Validatar to Claude Compliance to test activity records, chats and organization users, and reconcile them with your identity and audit systems. |
| Confluence | Connect Validatar to Confluence to test spaces, pages, labels and permissions, and monitor the documentation teams are expected to keep current. |
| DocuSign | Connect Validatar to DocuSign to test envelopes, recipients, templates and billing data, and confirm signed agreements match the deals and contracts in your other systems. |
| Connect Validatar to an IMAP or POP mailbox to monitor inbound messages, confirm expected reports and attachments arrive, and count what lands each day. | |
| Excel | Connect Validatar to Excel workbooks, on a file share or in cloud storage, to test sheets and named ranges before their numbers reach a report. |
| Excel Online | Connect Validatar to Excel Online to test worksheets in workbooks stored in SharePoint Online, and compare shared spreadsheets with the systems they feed. |
| GitHub | Connect Validatar to GitHub to test repositories, issues, pull requests and organization members, and find stale access and missing security scans. |
| Gmail | Connect Validatar to Gmail to test messages, labels and mailbox settings such as delegates and forwarding, and watch the inboxes your processes depend on. |
| Google Calendar | Connect Validatar to Google Calendar to test calendars, events and access control rules, and compare scheduled time with the rotas and bookings in your other systems. |
| Google Contacts | Connect Validatar to Google Contacts to profile contacts, contact groups and organizations, and find gaps before contact data reaches your CRM. |
| Google Directory | Connect Validatar to Google Directory to test Google Workspace users, groups, admin roles, devices and third-party app tokens, and find access nobody signed off. |
| Google Sheets | Connect Validatar to Google Sheets to check targets, mappings and finance figures kept in shared spreadsheets against the tables they feed. |
| Greenhouse | Connect Validatar to Greenhouse to test candidates, applications, jobs and offers, and reconcile recruiting data with HR records and headcount plans. |
| HCL Domino | Connect Validatar to HCL Domino to test the documents behind each form in a Notes database, starting with Person and Account records. |
| Jira | Connect Validatar to Jira to test issues, sprints and worklogs, and check the delivery metrics your warehouse builds from them. |
| Kintone | Connect Validatar to Kintone to test records in your custom apps, including apps in guest spaces, and check who can see each field and record. |
| Linear | Connect Validatar to Linear to test issues, cycles, projects and customer needs, and spot missing estimates and slipped milestones early. |
| Microsoft Entra ID | Connect Validatar to Microsoft Entra ID to test users, groups, devices and sign-ins, and check licenses and admin roles against what your policies allow. |
| Microsoft Exchange | Connect Validatar to Microsoft Exchange to test Inbox, Outbox and calendar data, and monitor the shared mailboxes your teams and processes depend on. |
| Microsoft Planner | Connect Validatar to Microsoft Planner to test plans, buckets, tasks and assignments, and watch the task data that team status reports depend on. |
| Microsoft Teams | Connect Validatar to Microsoft Teams to test teams, channels, members and call records, and catch ownership gaps and shifts that do not match payroll. |
| Monday.com | Connect Validatar to Monday.com to test boards, items, columns and workspaces, and compare the work tracked there with your other systems. |
| Office 365 | Connect Validatar to Office 365 to test Outlook mail and calendars, OneDrive files and Bookings appointments, and compare them with your scheduling and finance records. |
| Okta | Connect Validatar to Okta to test app assignments, MFA factors and system logs, and reconcile identity data with HR records and access reviews. |
| OneNote | Connect Validatar to OneNote to monitor notebooks, sections and pages across users, groups and sites, and see whether shared notebooks are kept current. |
| Oracle Service Cloud | Connect Validatar to Oracle Service Cloud to test incidents, contacts, organizations and knowledge answers, and reconcile service data with your CRM and warehouse. |
| PingOne | Connect Validatar to PingOne to test populations, applications and the users in them, and check admin roles and consents against your access policy. |
| Quickbase | Connect Validatar to Quickbase to test the records in your apps' tables, check field and role permissions, and watch for structural changes in the apps themselves. |
| Raisers Edge NXT | Connect Validatar to Raiser's Edge NXT to test constituents, gifts, campaigns and funds, and reconcile fundraising totals with your finance system. |
| SAP Business Warehouse | Connect Validatar to SAP Business Warehouse to test cube measures, compare BW figures with source systems and monitor reporting data before it reaches dashboards. |
| SAP BusinessObjects BI | Connect Validatar to SAP BusinessObjects BI to check documents, schedules, universes and users, and spot broken or stale BI content before report readers do. |
| SAP SuccessFactors | Connect Validatar to SAP SuccessFactors to test employee, position, compensation and time off data, and keep HR figures consistent with payroll and finance. |
| SAP SuccessFactors LMS | Connect Validatar to SAP SuccessFactors LMS to test learning items, curricula, scheduled offerings and learning histories, so compliance training reports rest on complete data. |
| SharePoint | Connect Validatar to SharePoint to test list data, keep an eye on the lists teams maintain by hand and compare them with the systems they feed. |
| SharePoint Excel Services | Connect Validatar to Excel workbooks stored in SharePoint to test worksheets and named ranges, and catch spreadsheet errors before the numbers feed a report or a load. |
| Slack | Connect Validatar to Slack to check channels, members, user groups and access logs, and compare workspace data with your HR and identity records. |
| Smartsheet | Connect Validatar to Smartsheet to test sheet rows, reports and workspace metadata, and catch missing dates, owners or values in the plans teams track there. |
| Talkdesk | Connect Validatar to Talkdesk to test call reports, queues, campaigns and do-not-call lists, and reconcile contact center figures with your CRM and billing records. |
| Trello | Connect Validatar to Trello to test boards and cards, and find stale or unassigned work before it skews delivery reports. |
| WordPress | Connect Validatar to WordPress to check posts, pages, media, comments and users, and catch missing categories, orphaned authors or stale content across your sites. |
| Zendesk | Connect Validatar to Zendesk to test tickets, organizations, SLA policies and satisfaction ratings, and keep support reporting tied to the customers in your CRM. |
| Zoho Creator | Connect Validatar to Zoho Creator to test the forms, reports and records behind your low-code apps, and find bad entries before they spread to other systems. |
| Zoho Projects | Connect Validatar to Zoho Projects to test projects, tasks, issues and time logs, and reconcile logged hours with payroll or client billing. |
File & API (26)
| Data source | What you can test |
|---|---|
| Amazon S3 | Connect Validatar to Amazon S3 to monitor buckets and objects, and confirm the files your pipelines expect arrive on time and at a sensible size. |
| Avro | Connect Validatar to Avro to query Avro files as tables, profile their fields and compare record counts with the systems that produced them. |
| Azure Data Lake Storage | Connect Validatar to Azure Data Lake Storage to monitor filesystems, directories and files, and confirm pipeline outputs land on time and at the size you expect. |
| Box | Connect Validatar to Box to test Files, Folders, Collaborations and metadata, and flag content that is shared too widely or missing from its folder. |
| CSV | Connect Validatar to CSV to test delimited files as tables, check headers and row counts, and compare file extracts with the systems they came from. |
| Dropbox | Connect Validatar to Dropbox to watch drop folders, shared links and team members, and catch missing deliveries or files shared too broadly. |
| FHIR | Connect Validatar to FHIR to test Patient, Encounter, Observation and Claim resources, and reconcile clinical data on the FHIR server with your analytics copy. |
| FTP | Connect Validatar to FTP to monitor server directories and file sizes, and alert when a scheduled delivery is late or arrives empty. |
| Google Cloud Storage | Connect Validatar to Google Cloud Storage to monitor buckets, objects and object versions, and check that pipeline files arrive complete and on schedule. |
| Google Drive | Connect Validatar to Google Drive to test Files, Permissions and Revisions across shared drives, and spot stale files or overly open sharing. |
| HDFS | Connect Validatar to HDFS to confirm batch outputs in your Hadoop cluster are present and complete, and to audit permissions on the directories that matter. |
| IBM Cloud Object Storage | Connect Validatar to IBM Cloud Object Storage to monitor buckets and objects, and alert when expected files go missing or arrive at the wrong size. |
| JSON | Connect Validatar to JSON to test JSON files and API responses as tables, and catch missing fields, broken nesting or row counts that do not add up. |
| LDAP | Connect Validatar to LDAP to test User, Group and Person entries in your directory, and reconcile accounts with HR and application user lists. |
| Microsoft Dataverse | Connect Validatar to Microsoft Dataverse to test standard and custom tables such as Account and Contact, and check option set values against your reports. |
| Microsoft OneDrive | Connect Validatar to Microsoft OneDrive to monitor Files, Folders, FileVersions and Permissions, and catch late uploads or files shared outside the team. |
| OData | Connect Validatar to OData to test the entity sets of any OData v2, v3 or v4 service, and compare them with the systems behind the service. |
| Parquet | Connect Validatar to Parquet to test Parquet files and partitioned datasets as tables, and compare lake data with the warehouse tables loaded from it. |
| Power BI XMLA | Connect Validatar to Power BI XMLA to query Power BI datasets, and reconcile report measures with the warehouse tables they are built on. |
| REST | Connect Validatar to REST to test the JSON or XML any REST API returns, and compare API results with the database records they should match. |
| RSS | Connect Validatar to RSS to read feed items as rows, and alert when a feed goes quiet, repeats items or drops required fields. |
| SAS Data Sets | Connect Validatar to SAS Data Sets to query SAS7BDAT files as tables, profile variables and observations, and compare them with the database copies built from them. |
| SAS xpt | Connect Validatar to SAS xpt to read version 5 transport files as tables, and check submission data sets against the source data they were built from. |
| SFTP | Connect Validatar to SFTP to check inbound and outbound file exchanges, and find files that are late, misnamed or left behind on the server. |
| Twilio | Connect Validatar to Twilio to test Messages, Calls and Recordings, and compare message and call volumes with the usage your warehouse reports. |
| XML | Connect Validatar to XML files and XML web services to check that each file or feed parses into the rows and values your pipelines expect. |
Accounting (16)
| Data source | What you can test |
|---|---|
| Avalara AvaTax | Connect Validatar to Avalara AvaTax to test Transactions, Tax Codes, Nexus and Customers, and catch tax records that disagree with your ERP or warehouse. |
| Dynamics NAV | Connect Validatar to Dynamics NAV to test customers, sales orders and purchase orders published as web services, and match NAV order totals to your warehouse. |
| Freshdesk | Connect Validatar to Freshdesk to test Tickets, Contacts, Companies and Agents, and spot support data gaps before they skew SLA reporting. |
| MYOB AccountRight | Connect Validatar to MYOB AccountRight to test sale invoices, purchase bills, journals and payroll data, and reconcile company file figures with your warehouse. |
| QuickBooks | Connect Validatar to QuickBooks to test Invoices, Bills, Journal Entries and Customers, and reconcile your company file with the warehouse that reports on it. |
| QuickBooks Online | Connect Validatar to QuickBooks Online to test invoices, bills, payments and journal entries, and reconcile the books with your warehouse. |
| QuickBooks Time | Connect Validatar to QuickBooks Time to test Timesheets, job codes, schedule events and payroll reports, and catch time tracking errors before payroll runs. |
| Reckon | Connect Validatar to Reckon to test Invoices, Bills, ReceivePayments and Accounts, and reconcile your Reckon books with downstream finance reports. |
| Reckon Accounts Hosted | Connect Validatar to Reckon Accounts Hosted to profile invoices, bills, journal entries and employee earnings, and compare them with the reports your finance team reads. |
| Sage 200 | Connect Validatar to Sage 200 to test sales orders, nominal codes, products and posted transactions, and reconcile them with your finance reporting. |
| Sage Cloud Accounting | Connect Validatar to Sage Cloud Accounting to test sales invoices, purchase invoices, bank accounts and ledger accounts, and catch posting errors early. |
| Sage Intacct | Connect Validatar to Sage Intacct to test AP bills, AR invoices and dimensions such as Department and Class, and tie subledger balances to the figures your warehouse reports. |
| SAP Concur | Connect Validatar to SAP Concur to test expense Reports, Entries, Attendees and travel requests, and check that spend in Concur matches what reaches your ledger. |
| TaxJar | Connect Validatar to TaxJar to test Orders, Refunds, NexusRegions and customer exemptions, and compare reported sales tax with your order system. |
| Xero | Connect Validatar to Xero to test invoices, bills, payments and bank transactions, and reconcile accounting data with your warehouse. |
| Zoho Books | Connect Validatar to Zoho Books to test invoices, bills, bank transactions and the chart of accounts, and reconcile Zoho figures with your warehouse. |
E-Commerce (19)
| Data source | What you can test |
|---|---|
| Adobe Commerce | Connect Validatar to Adobe Commerce to test products, orders, invoices and inventory, and reconcile store sales with your ERP and warehouse. |
| ADP | Connect Validatar to ADP Workforce Now to test workers, payroll runs, time cards and time off balances, and reconcile payroll with the general ledger. |
| Amazon Marketplace | Connect Validatar to Amazon Marketplace to test orders, listings, inventory and financial events, and reconcile Amazon sales with your ERP. |
| Authorize.Net | Connect Validatar to Authorize.Net to test settled batches, transactions, customer profiles and subscriptions, and reconcile card payments with your ledger and bank deposits. |
| BigCommerce | Connect Validatar to BigCommerce to test orders, products, customers, price lists and coupons, and catch catalog or order data problems before they reach finance. |
| Blackbaud FE NXT | Connect Validatar to Blackbaud Financial Edge NXT to test accounts, funds, grants and journal entries, and reconcile nonprofit ledgers with budgets and fundraising data. |
| eBay | Connect Validatar to eBay to test listings and orders, and reconcile marketplace payments and refunds with your finance systems. |
| eBay Analytics | Connect Validatar to eBay Analytics to monitor traffic reports, seller standards and customer service metrics, and alert when listing or seller performance slips. |
| Paylocity | Connect Validatar to Paylocity to test employees, earnings and pay statements, and catch payroll and tax setup errors before payday. |
| PayPal | Connect Validatar to PayPal to test transactions, invoices, disputes and payouts, and reconcile PayPal balances with your general ledger. |
| SAP Ariba Procurement | Connect Validatar to SAP Ariba Procurement to test purchase orders, order line items, invoice headers and contract compliance, and reconcile spend with your ERP. |
| SAP Fieldglass | Connect Validatar to SAP Fieldglass to test active workers, work orders, approved time sheets, expense sheets and SOWs, and check external labor costs against your ERP. |
| ShipStation | Connect Validatar to ShipStation to test orders, shipments, labels and inventory, and confirm every paid order ships on time and matches your store records. |
| Shopify | Connect Validatar to Shopify to test orders, products, customers and inventory, and reconcile store sales with finance and the warehouse. |
| Square | Connect Validatar to Square to test payments, refunds and catalog items, and reconcile point-of-sale takings with your ledger. |
| Stripe | Connect Validatar to Stripe to test charges, invoices, subscriptions and refunds, and reconcile payments with your books and warehouse. |
| Wave Financial | Connect Validatar to Wave Financial to test invoices, customers and sales taxes, and catch errors in small-business books before a tax filing. |
| WooCommerce | Connect Validatar to WooCommerce to test orders and refunds, and reconcile store revenue with your payment provider and accounting. |
| Zuora | Connect Validatar to Zuora to test subscriptions, invoices, credit memos, payments and billing runs, and reconcile billing with your general ledger and CRM. |
Related articles
Product names and logos on this page are trademarks of their respective owners. They identify the data sources Validatar connects to and do not imply endorsement.