Reconcile any data, where it already lives
EasyRec connectors expose every source as SQL tables in real time. Your teams query CSV, Excel or XML with the SQL they already know, instead of a proprietary scripting language.
Why use EasyRec connectors
Standard SQL
Joins, unions, filters and conversions with any SQL construct. Minimal training, easy maintenance.
No preloading
Data is read in real time from its existing location: nothing to stage, archive or synchronise.
Volume & speed
High-performance drivers designed for millions of rows, with no archiving capacity issues.
Included with EasyRec
Databases
Any database with a JDBC driver: no vendor lock-in.
- Oracle, Sybase, MS SQL Server
- PostgreSQL, MySQL, MariaDB, Teradata
- BigQuery, Hadoop
- In-memory and NoSQL databases
CSV & fixed width
Delimited and fixed-column files.
- Single or multiple files
- Join files together
- Convert columns to number or date
- Tested on multi-gigabyte files
Excel
Native workbooks, as produced by the business.
- .xlsx, .xls and Excel XML
- Merged cells supported
- Read from a specific range
- Formula evaluation
XML
From trade messages to configuration exports.
- Wizard with automatic segment detection
- Schema-based mapping, namespace handling
- SAX or DOM parsing for performance
- XML sorter, no XSL needed
JSON
APIs and nested documents.
- JSONPath parser
- Nested structures
- Automatic format detection
Table-layout reports.
- Dedicated JDBC driver
- Detection wizard with adjustable ruler
- Automatic column delimiter detection
SWIFT, FIX & properties
Payment, trading and configuration formats.
- Single or multiple files
- Join files together
File-based reconciliation without false breaks
Configuration exports are mostly XML, where node order, paths, timestamps and IDs change from one export to the next. Basic diff tools flag them all. EasyRec compares what actually matters.
ZIP packages
Reconcile the content of ZIP files and configuration packages, recursively.
Local folders
Reconcile the content of local directories file by file.
Git repositories
Compare branches, tags or commits of a Git repository.
SSH
Reconcile directories on a remote Unix server, with inclusion and exclusion filters.
Advanced comparison for every file-based connector
- Fast checksum-based comparison
- Flexible filename matching rules
- Orderless XML comparison
- Ignore blanks, headers, DOCTYPE and indentation
- Custom transformations, e.g. removing unique IDs
- Regular expressions
- Embedded diff viewer showing only relevant differences
Have a format we have not listed?
If it can be read, it can be reconciled. Tell us about your sources and we will show you how EasyRec handles them.