Benerator is a model-based test data generation tool by rapiddweller with open-source and premium editions. It provides extensive data generation features, allowing users to create complex and realistic test data. Benerator supports various data formats, including XML, CSV, and SQL, and can generate data based on database schema or custom data models to JDBC Databases, NoSQL Databases and into Message Queue Systems such as JMS or Kafka. It offers an expression language for powerful data generation, as well as built-in functions for data masking and validation.
8.4Expert Score
Model-based test data framework
Creates complex and realistic test data sets
Flexible and extensible
General Features
9.2
Flexibility
8.3
System Coverage
6.8
Data Coverage
7.5
Cost
10
PROS
Model-based test data toolkit with powerful UI
Highly customizable and extenable
Open-source and Premium Editions available
CONS
May require Test Data Engineers and consultancy for large scaled projects
Open-source community edition is difficult to use
Too complex for simple generation of JUnit data sets
Specification: Benerator
Generic Features
Synthetic Test Data Creation
✅
Single-Click Test Data Generation
✅
Data Masking
✅
Auto-Detection of DB Constraints
✅
Identically Repeatable Data Generation
✅
On Demand Data Refresh (Watermark)
✅
Database Subsetting
✅
Multi-Database Subsetting
✅
Job Scheduling
✅
Continuous Integration Support
✅
Advanced Features
Consistency
✅
Custom SELECTS
✅
Data File Import
CSV, Flat, JSON, XML
Deterministic Data Masking
❌
Inter-column dependency support
✅
Localization
✅
Micro or Macrocosm Subsets
✅
Multi-Table Seed Data
✅
Primary And Foreign Key Synthesis
✅
Primary & Foreign Keys Preserved
✅
Privacy Verification
✅
Schema change alerts
❌
Table Truncation
✅
Extendibility & Customization
Custom Data Weighting
✅
Custom Generator Support
Java
Script Languages for data processing
Benerator Script, JavaScript, Python
User-Defined Generators
✅
User-Defined Distribution Functions
✅
User-Defined Number Series
✅
Extension to custom software system types
✅
Pluggability of individual script languages
✅
User-Defined Data Converters
✅
User-Defined Data Validators
✅
Extension to individual file types
✅
Generation Types
Built-In Data Generators
100
Salesforce
❌
Security, Accessibility, and Usability
API
✅
Audit Trails
❌
Collaboration
✅
Command-line interface
✅
GUI
✅
On-Premise Deployment
✅
Role-Based Access Control
✅
Single Sign-On
❌
User Interface
WebApplication
Supported Systems
Advantage Database
❌
Amazon Aurora
❌
Amazon Redshift
❌
Apache Spark
❌
AWS S3
✅
BaaN
❌
Cassandra CQL
❌
Databricks
❌
DataWarehouse
❌
dBase
❌
EnterpriseDB (Postgres)
✅
Firebase
❌
Firebird
✅
GCP (Google Cloud Storage)
✅
Google BigQuery
❌
IBM DB2
✅
InfluxDB
❌
Informix
❌
Interbase
❌
JD Edwards
❌
JMS
✅
Kafka
✅
Microsoft Access
❌
Microsoft SQL Server
✅
MongoDB
✅
MS Azure SQL
❌
MySQL
✅
NexusDB
❌
Oracle
✅
Oracle E-Business Suite
❌
Oracle Transportation Management
❌
Peoplesoft
❌
PeopleSoft HCM
❌
PostgreSQL
✅
Siebel
❌
Snowflake
❌
SQL Anywhere
❌
SQLite
✅
Sybase
❌
Terradata
❌
Yellowbrick
✅
Supported Formats
CSV
✅
Fixed Column Width Files
✅
Excel
✅
XML
✅
SQL
✅
JSON
✅
AVRO
✅
EDIFACT
✅
YAML
❌
DbUnit XML
✅
HTML
❌
Licensing & Usage Tiers
Trial
on request
Free Plan
✅
Available Editions
Community, Enterprise, Light, Professional
Max Users
unlimited
Maximum number of databases
unlimited
Source Database Limit
unlimited
Email-Support
✅
Live Chat Support
❌
SLA
✅
Support Languages
English, German, Vietnamese
Dedicated Contact
✅
Pricing
199, 899, Individual
Specification
Multiprocessing
✅
AI features
❌
Complex JSON
❌
Model-Based Data Generation
May require Test Data Engineers and consultancy for large scaled projects
