Data Subsetting

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.

Features

Technical & functional consistent subsets

High performance on large databases

Consistent over multiple apps and databases

Fast to implement & easy to maintain

Benefits of data subsetting

Fast

Working with data subsets is fast! Refresh more often and enable each team with their own test data

Reduce costs

Save costs on hardware and infrastructure by using small subsets of production data for test and development

Less dependencies

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.

Patented algorithm

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.

Preserve consistency

Extract and copy specific data selections that are referentially intact and functional consistent to ensure that all constraints are preserved and requirements are met.

High-performance

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.

Customizable

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.