testdatatools
Tools/Jailer
Enterprise TDM

Jailer

Jailer exports small connected slices of relational databases. A local extraction model controls which rows and related records are included. Export and import filters support transformations and key remapping. 1

Sources reviewed

Manufacturer / project: Jailer project / Ralf Wisser

When does it fit?

Consider it when a relational database subset is the deliverable and your team can maintain the extraction rules. The base subset workflow does not require a cloud AI service. 1 · 2

Fit still depends on your mandatory requirements.

What should you check before choosing?

A subset can still contain sensitive data; define and verify filters before export. Check cycles and relationships without declared foreign keys. Version 17.2.5 comparison features do not establish LOB equality in cross-database comparisons. 1 · 2 · 3

What must your PoC prove?

Select one customer, include related rows and test a cycle. Check filters and key remapping after target loading. Repeat from a clean source snapshot and restore the extraction model with the required driver.

Acceptance plan, not a product test result. Execution scope and limits.

Deployment and license

Local Java application with JDBC drivers, GUI and command-line/programmatic workflows. Verify the actual driver and SQL dialect. Reviewed release: 17.2.5, 2 October 2026. 1 · 2 · 3

Apache-2.0 according to the repository. Database, driver and optional AI service terms are separate. 1 · 2 · 3

Confirm the entitled version and operating requirements.

How you work with it

Maintain an extraction model and filters, export related rows and load the target. Models are local artifacts. SQL, JSON, YAML, XML and DbUnit exports are documented; another engine executing the model is unverified. 1 · 2 · 3

Export does not establish compatibility with another runtime.

Documented capabilities

Synthetic generationUnclear
De-identification / maskingExport filters and key remapping
Subsetting / subset planningExport selected rows and required related records
Data virtualizationUnclear
Seeded replay, scopedUnclear

Documentation is not a measured benchmark. Unclear is missing evidence; the comparison matrix explains the gap.

Sources and scope

Sources can cover different releases; they do not establish measured performance.

Open the cited sources (3)
  1. Jailer repository

    Java/JDBC relational subsetting; SQL, JSON, YAML, XML and DbUnit export; Apache-2.0 license.

    Source checked: 2026-10-11
  2. Export and import filters

    SQL-based export filters and import key remapping; output privacy requires appropriate rules.

    Source checked: 2026-10-11
  3. Jailer 17.2.5, 2 October 2026

    Column comparisons and synchronization-script work; cross-database comparison does not compare LOBs.

    Source checked: 2026-10-11

Use the same acceptance checks for your shortlist