Modern software development requires representative test data that can be easily and fast made available. DATPROF Subset extracts specific selections out of production databases and makes it directly available within the test environment.
Benefits of data subsetting
Working with data subsets is fast! Refresh more often and enable each team with their own test data
Save costs on hardware and infrastructure by using small subsets of production data for test and development
Give each team their own test data to speed up their development by removing dependencies between teams
Multi database subsetting
Create subsets of your databases, containing only a portion of the records, while still being referentially intact over multiple databases such as CRM, ERP and finance systems.
Our patented algorithm detects foreign key cycles and bidirectionally filters data from parent-child relationships. This enables you to efficiently subset thousands of tables, resulting in quick and compact test data.
Automatic data model classification
The automatic classification functionality analyses the data model to determine how tables should be filtered. This assists you in quickly creating subsets of large and complex databases.
Extract and copy specific data selections that are referentially intact and functional consistent to ensure that all constraints are preserved and requirements are met.
Enterprise databases often contain thousands of tables and terabytes of data. Using parallel processing the data is extracted and subsetted directly within the database, enabling you to subset millions of rows quickly.
Slice your database with custom start and additional filters to ensure the exact size of your database. Use column expression to modify data during subsetting. Add custom SQL and OSCALL scripts before, during and after the subset process.
Automate test data subsets
Use the power of DATPROF Runtime to deploy and automate subsetted test data
Integrate the deployment of masked test data as part of your CI/CD pipeline.
Schedule and automate the deployment of masking templates using the Runtime API.
Manage and monitor the execution of all masking processes from one TDM portal.
Data is directly masked within the database using the advanced bypass system.
Runtime can send you notifications about the status of your masking process.
Get insight in all previous masking projects for better auditability
“PeerSpot users give DATPROF an average rating of 8.6 out of 10.”
“DATPROF helped improve our organization because as more of our development teams adopt the tool, we become faster at creating test data. The test data quality is also improving, resulting in us creating better products.”