ETLBox DirectSync
Sync data reliably between systems

Simple to configure, powerful under the hood. A Windows desktop app for data migrations, testing, and development - and the etlrun directsync command line to deploy the same pipeline anywhere: cloud, Azure, containers, Linux.

DirectSync
Simple
Easy configuration - no code required
Streaming
Large datasets; ETLBox processes in stream
Deploy anywhere
CLI runs on Windows, Linux, containers - it's .NET

See it in action

Watch a short walkthrough of DirectSync configuring a sync and running it end-to-end.

See for yourself how great DirectSync works in this short walkthrough - or watch it on YouTube: https://youtu.be/zKrkaGrcvkE?si=UfUP1tsCZCI8-nGa

How it works

Pick source, set target, define mapping - run in the app or deploy with the CLI.

1

Configure source

Choose source type: database (SQL Server, PostgreSQL, MySQL, Oracle, etc.) or file (CSV, Excel, JSON, XML, Parquet). Connection and format options are validated.

2

Configure target

Set the target - database or file. Configure table, insert/merge behavior, or output path and format.

3

Mapping & transformation

Map source columns to target columns, rename and adjust types. Use options like distinct, merge strategies, and transformations.

4

Run or export

Execute in the app or export configuration as JSON. Run the same pipeline with the CLI on Windows, Linux, in containers, or in the cloud. with the CLI: etlrun directsync --config <path> .

Features

Simple to configure, powerful to run - database and file sync, streaming engine, and CLI that runs anywhere.

Database & file sync

Sync between databases, database to file, or file to database. One tool: staging to warehouse, CSV/Excel/JSON into tables, or export from DB to files. Configurable mapping and merge strategies.

Streaming engine

ETLBox processes in stream: large datasets without full memory load, with pipeline-based throughput.

Mapping & transformation

Map columns, rename, adjust types. Distinct, merge options, and extensible transformation rules.

Error handling

Configurable error destination: redirect faulty rows to file or table; rest of the run continues.

CLI & automation

Export configuration as JSON and run with the CLI. Works on Windows, Linux, in containers, and in the cloud - it's .NET. using etlrun directsync --config <path> .

Data preview

View first rows of the source in the app, sort and filter - verify connection and parsing before running.

Manual vs. DirectSync

One configuration in the app - deploy the same pipeline anywhere with the CLI.

Manual / scripts

Without DirectSync

  • Script maintenance: Custom ETL scripts per source/target, hard to reuse.
  • No single model: UI and batch often separate, double configuration effort.
  • Memory load: Large datasets can push custom solutions to their limits.
  • Error handling: Often all-or-nothing - one bad row stops the run.
ETLBox DirectSync

With DirectSync

  • One configuration: Configure in the desktop app - same config for the CLI and automation.
  • Streaming engine: ETLBox processes in stream - no memory issues even with large data.
  • Error destination: Redirect bad rows; rest of the pipeline keeps running.
  • Platform-independent deployment: Run etlrun directsync anywhere - Windows, Linux, containers, Azure.

FAQ

Answers about DirectSync, data sources, and automation.

DirectSync uses the ETLBox engine: databases (SQL Server, PostgreSQL, MySQL/MariaDB, Oracle, DB2, Snowflake, SQLite, SAP ASE, and more) plus files (CSV, Excel, JSON, XML, Parquet). Source and target can be combined freely.
The desktop app runs on Windows. The CLI (etlrun directsync) is .NET-based and runs on Windows, Linux, in containers, and in the cloud - use it for CI/CD, scheduled tasks, or Azure.
ETLBox works in a streaming way: data is not fully loaded into memory but read, transformed, and written in pipelines. That allows reliable processing of very large datasets.
Yes. Configure once in the desktop app and export as JSON. Run the same pipeline with etlrun directsync --config anywhere - ideal for repeated or automated runs.
You can enable an error-destination option: problematic rows are redirected to a file or target of your choice without failing the whole run.

Plans

Recommended

Free

Free

Personal use and testing. Use DirectSync to experience and test all of its functionality.

  • Perfect for individual developers to explore and test
  • All components and functionalities included
  • Limited to 5,000 rows per data flow
  • Desktop app (Windows) and CLI (Windows, Linux, etc.)

Licensing: Standard EULA · Only for testing and evaluation

Download
Company-wide use

Company

Request a quote per developer / year

Use DirectSync in all your developments inside your company.

  • Licensed by developer
  • Unlimited application and server installations
  • Company-wide use of DirectSync

Licensing: Standard EULA · New license key provided annually

Request a quote
Redistributable

Enterprise OEM

Request a quote per customer / year

Redistributable DirectSync for integration into your software products. When etlrun needs to be distributed with your product.

  • Integrate DirectSync functionality into your software products
  • Redistribution rights for DirectSync in your own products
  • No back-linking or mentioning of DirectSync required

Licensing: Licensed by number of customers · Redistribution EULA · Annual vendor license

Request a quote
Get started for free

Download DirectSync

Get the free version for Windows. Use the desktop app for migrations, testing, and development - then deploy with the CLI anywhere.

Version 1.X