Consider model-based generation when virtual copies are not required
Fits teams that define business scenarios as reviewable models, such as approved, rejected and duplicate payment cases.
Rule-based results can be repeated under documented conditions. Pin engine, inputs, seed, execution settings and output ordering; assess learned output separately. Check IDE versions, connectors and licensed modules.
PoC: Model customer, account and transaction cases, including an invalid reference. Check rules, keys, cleanup after failure and repeatability; restore the exported project in a clean environment.
License: Commercial Enterprise product; request an edition-specific offer. Source
Sources for DATAMIMIC Enterprise PlatformEvaluate Privacy together with Subset and Runtime for the required workflow
Best suited to database teams that need reusable masking templates, constrained synthetic rows, deterministic values and separation of project development from deployment.
Privacy should not be credited with Subset product functionality by default; Runtime is separate, runtime deployment is not available for every database, and some workflows require elevated database permissions.
License: Documentation refers to a purchased license key; no public price or edition pricing was found in the reviewed vendor sources. Source
Sources for DATPROF PrivacyLegacy Optim estates: evaluate lifecycle and migration before switching
Consider it for an existing Optim estate that needs relational subsets, transformations and reuse of established definitions. Include license continuity and migration effort in the decision.
End of marketing is announced for Solution PID 5724-U48 on 9 December 2026 and Enterprise PID 5725-G97 on 11 November 2026. Neither reviewed lifecycle page gives an end-of-support date. Do not transfer these dates to modern Optim TDM.
PoC: Extract a connected business object; check keys and masking after loading. For migration, inspect converted masking expressions and redaction fallbacks. Confirm target version and support separately.
License: Commercial IBM software with edition-specific terms. Obtain written confirmation of ordering, renewal and support for the exact PID; marketing-end and support-end are separate questions. Source
Sources for IBM InfoSphere Optim TDM 11.7Related business-entity subsets; not a storage-virtualization replacement
Consider it when tests need a coherent customer or order across several systems, with shared provisioning and masking rules. Evaluate the required Fabric and business-entity model alongside the data workflow.
A small disposable fixture may not justify the entity-model and infrastructure setup. The reviewed AI path requires training and documents a single LU/schema, non-hierarchical entity boundary. Do not equate entity snapshots with storage-level virtual databases.
PoC: Select a customer and related orders from two systems. Check missing relationships and consistent masking. Change a lookup list and repeat. Restore the project in a clean licensed environment and record manual work.
License: Commercial proprietary software. The order defines licensed scope; obtain a quote for environments, users and relevant modules. Source
Sources for K2view Test Data ManagementEvaluate a CLI-based masking and subset pipeline
Consider it when you need smaller source-derived databases for development or QA, with a CLI-oriented preparation workflow. The documentation names SQL Server, PostgreSQL, MySQL/MariaDB and Oracle; verify the exact engine version.
Subsetting requires foreign-key relationships. Validate application-level relationships that are absent from the database schema. Use a dedicated disposable test environment. A masked copy still needs a separate privacy assessment; successful execution is not an anonymity guarantee.
License: Documentation requires a license and offers a trial during authentication. The public product URL redirected to SQL Provision during this review; current commercial packaging and price must be confirmed with Redgate. This redirect alone does not establish retirement. Source
Sources for Redgate Test Data ManagerEvaluate an alternative automated data preparation workflow
Best for engineering teams that want workflow-driven database masking, synthetic test-data generation, and relational subsetting integrated into development pipelines.
TDK is the current platform documented for these test-data operations; Synthesized also publishes a distinct Python SDK, so confirm which product and workflow a comparison names.
License: The reviewed documentation describes platform licensing and administration but does not publish current prices or a complete license schedule. Source
Sources for Synthesized TDKSource-derived subsets and transformations
Consider it when your team needs smaller copies of existing application databases, with sensitive fields transformed and the required relationships preserved.
It works from existing source data; use a from-scratch generator when the target schema has no representative source records. Connector support for subsetting varies. Oracle collection columns (nested tables and VARRAYs) are set to NULL, with a job warning, according to v1876 release notes. Verify these types and your exact version before replacing a production-copy workflow. With skip-create-db enabled, v1892 fixes a SQL Server preparation failure involving temporal tables and schema-bound views; check your release.
PoC: Subset existing customer, account and transaction data, including an invalid reference. Check sensitive fields, missing parents, connector limits and version-specific warnings.
License: Current public pricing and licensing terms were not established from the reviewed product documentation; contact Tonic for a quote. Source
Sources for Tonic StructuralUse one common PoC for the shortlist
What should a Delphix migration PoC measure?
Suppose four test environments share one prepared baseline. One team needs a fresh copy while another is investigating a failure. That is an illustrative requirement, not a product benchmark. Give every candidate the same schema, source snapshot and acceptance checks.
- Record the current baseline: database and connector versions, licensed components, preparation time, storage and operator time.
- Check the delivered result. Compare exact selected rows, required replacements and one application outcome. A row count alone can miss a broken relationship.
- Interrupt a refresh or load. Verify that an incomplete result stays unavailable, then measure recovery and reset. Check whether another environment is affected.
- Rehearse the return to the existing workflow. Record which rules, projects and operational steps must be maintained after the switch, together with license and infrastructure costs.
Download the common acceptance checklist · Follow a small PostgreSQL masking example
Does Delphix only provide virtualization?
No. Perforce also documents masking and a Synthetic Data product, with a September 2026 GA announcement. Evaluate the licensed release and its technical limitations; older comparisons may describe an earlier product state. Perforce release updates.
What could make switching the wrong choice?
Do not replace virtual copies with a generator if your teams need point-in-time refresh, reset or existing environment semantics. Measure the required workflow and rehearse rollback.