Database and solution architects depend on realistic test data to:
help create new databases, prototype ETL jobs or applications
benchmark performance in new or existing platforms
protect confidential information in existing systems if database work is outsourced or used for demonstrations.
Production data runs the risk of exposing personally identifiable information (PII), proprietary information, or may not reflect the types or volume of real data that can be encountered in the future.
A test data generator is an important part of the setup process when database architects are creating database and data warehouse operations, prototyping applications, benchmarking different platforms, and outsourcing work formats.