About DATPROF

Test Data Management solutions like data masking, synthetic data generation, data subsetting, data discovery, data automation are our core business.

We see and understand the struggle and challenge of software development teams with test data. Personally Identifiable Information? Too large environments? Long waiting times for a test data refresh? We envision to solve these issues:

– Obfuscating, generating or masking databases and flat files;
– Extracting or filtering specific data content with our patented subset algorithm;
– Discovering, profiling and analysing solutions for understanding your test data,
– Automating, integrating and orchestrating test data provisioning into your CI/CD pipelines and
– Delivering a portal where test data can be refreshed within a few mouse clicks.

2 Table of contents TABLE OF CONTENTS GENERAL Introduction Concepts Generic steps INSTALLATION DATPROF Subset Licence DB2 for Linux, Unix and Windows AN INTRODUCTION TO DATPROF SUBSET Open new or existing project Screen: Project settings Screen: Development Screen: Deployment Menu bar WORKING WITH DATPROF SUBSET – PROJECT SETTINGS Source database and Target database Oracle Microsoft SQL Server DB2 for Linux, Unix, Windows (LUW) DB2 for iseries Validate Project settings Importing Metadata Selecting tables for importing Selecting Foreign Keys Importing Metadata Importing Metadata using a DME file Synchronize Metadata Schema mapping WORKING WITH DATPROF SUBSET DEVELOPMENT Start table Define a Filter Start table properties Tab: Columns Tab: Foreign Keys Tab: Comment Classification Page 2

3 5.2.1 Classification: Subset Classification: Full Classification: Empty Classification: Unused Suggest Table details Tab: Columns Tab: Foreign keys Tab: Comments Tab: Dependencies Tab: Additional Filter Tools Filtering Labels Count rows Visualizing the data model Process model visualization Script Manager WORKING WITH DATPROF SUBSET: DEPLOYMENT Deployment options Tab: Settings Tab: Advanced Tab: Logging Tab: Comments Start Subset Options during Deployment Errors during Deployment CONSOLE VERSION General Licence APPENDIX: FAQ Page 3