Custom data generation in SQL Data Generator

Using Python scripts to generate custom data in SQL Data Generator

SQL Data Generator includes Python Generator, a generic-type generator that executes an arbitrary Python script to generate custom data for your test database.

• Generate custom test data to match the real-world data of your database environment
• Add realism and robustness to your testing process
• Template example scripts are easily modified to generate your test data
• Build your own scripts to generate specialized data tailored to your environment

Use Python scripts to generate your own custom data

For a comprehensive introduction to the world of Python coding, full documentation and tutorials are available here.

Python script examples

SQL Data Generator has a built-in set of simple template Python scripts that are easily modified to generate custom data for your database.

Some additional examples below demonstrate the versatility of Python scripts for populating your database with specialized custom data specific to your environment.

• Request data from a web service
• Connect to a database, execute SQL commands and read through the results
• Random numbers in a Poisson distribution
• Randomized strings in a specific ratio
• Invalid credit card numbers
• Sequentially numbered strings