A lightweight ETL tool for SQL Server and files.

CSV, TSV, Excel and custom-delimiter files, described once as a file template with column types, a header row and validation rules.

SQL Server, PostgreSQL, MySQL and SQLite, through saved read-only queries with parameters. Needs the Database module.

SFTP, FTP and FTPS servers, local and network folders, HTTP and REST addresses with paging and an incremental watermark, Azure Blob Storage and Amazon S3. Needs Transfer on a Server.

Turn one layout into another with copy, case, trim, pad, substring, replace, concatenate, and date and number format rules. Try an expression on a sample row in the Expression Builder first.

Validate File lists every problem by row and column. Quick Transform cleans whitespace, duplicates, dates, phone numbers and lowercase emails. See data quality before import.

Crosswalks translate one system's codes to another's and fail the row when a code has no entry. Record Matching finds duplicates with exact, normalized and fuzzy rules. Both are Server features.

Insert, update or insert, or replace rows in an existing table, with reject files and an all-or-nothing option. On SQL Server the rows are streamed with bulk copy and applied with set-based statements. Other databases are written row by row. An administrator must switch on writes for the connection. CSV into SQL Server.

Keep a target table in step with a source table, one way, in reverse or both ways, with Preview and Validate before any write. Change detection is full compare, a timestamp column, a row hash or SQL Server change tracking. Server with Database. Database table replication.

A query step can remember what it delivered so each row goes out one time, even when a job reruns. Server with Flow. SQL to SFTP nightly extract.

Chain steps into a job: import from a source, execute a query, transform, write to a database, push results, notify and wait. Schedules are manual, once, daily, weekly, monthly or repeating, in a time zone you choose. Retry a job up to 10 times and choose per step whether a failure stops it. Server pipelines add For each, Conditional, Parallel and Aggregate.

Job Monitor shows every run with its steps, rows, duration, trigger and delivered files, and a job can email you when it fails. Push History keeps each delivery's file name, size and SHA-256.

SQL Server Integration Services is part of the SQL Server platform and packages are built in Visual Studio. DataBridge is configured in its own interface, with no package development step, and is aimed at moving and mapping files and tables on a schedule.

DataBridge does not open, convert or run SSIS packages. It is not a drop-in replacement for packages you already have, so check your own workloads against the feature list before you move anything.

Templates, mappings, Transform Data, Validate File and Data Diff. Files are read in the browser and not uploaded. CSV and TSV up to 10 MB, Excel up to 5 MB, 100,000 rows per file.

A single-user Windows app with Database and Transfer pages that really run, and scheduled jobs while the app is open.

Unattended schedules, pipelines, database sync, Extract, users and an audit log, on your own Windows server. What each edition includes.