SQL ServerSQL Server and Azure SQL Database are core platforms for many business-critical applications, but test data is often still provisioned via manual scripts and database backups. XDM integrates both systems into a unified test data platform, enabling cloning, subsetting and masking across on-prem and cloud environments. Teams work with reusable models and workflows instead of ad-hoc scripts, while XDM automates data movement, structure handling and compliance.
XDM’s modification engine anonymizes or pseudonymizes sensitive data during extraction and loading, using the same central rules for SQL Server, Azure SQL and all other connected systems. Deterministic masking ensures that identical input values are transformed into consistent outputs across tables, environments and platforms, preserving referential integrity while meeting GDPR and internal policies. Existing SQL Server tables can be used as lookup sources for realistic values, and the same mechanisms support generating synthetic test data from a few records for ad-hoc tests to large volumes for load and stress testing. This allows you to combine realistic Microsoft-based test scenarios with strict data protection and governance requirements.
Through the XDM Data Shop, non-technical users request SQL Server or Azure SQL test data using business terminology rather than table names, while XDM workflows execute all technical steps in the background. Approval flows, execution windows and integrated scheduling ensure that heavy jobs run at suitable times and comply with operational rules. The same tasks and workflows can be triggered and parametrized via the public REST API, making SQL Server and Azure SQL test data provisioning a standard step in CI/CD pipelines, external schedulers and test automation frameworks. Combined with Icebox versioning, you can save and restore SQL Server and Azure SQL data states at any time, enabling repeatable regression tests and reliable rollback options.
XDM is a complete test data management platform that enhances agile teamwork, automates test data workflows, and supports multiple databases with secure masking.
Secure sensitive data with XDM’s Masking Tool. Protect privacy and ensure compliance with advanced data masking for all environments.
