Sorry, we didn't find any relevant articles for you.

Send us your queries using the form below and we will get back to you with a solution.

GenRocket Supported Databases

This article covers the most common SQL, NoSQL, and Fixed File/Flat File Databases that GenRocket can connect to for data queries and populating database tables during test data generation. Please note that most databases that support a JDBC driver and connection are supported by GenRocket.

Note: GenRocket supports a variety of output file formats beyond database-specific. For a complete list of supported output formats, click here.

Chart Description Meaning

  • Supported - A checkmark means that the database is supported by GenRocket.
  • Validated - A checkmark means that the database has been validated by the GenRocket Team.
  • In Use, Not Validated - A checkmark means that the database is in use by one or more customers, but has not been validated by the GenRocket Team.
  • Bulk Load Receiver Available - A checkmark means that a Bulk Load Receiver is currently available for the database. For more information about Bulk Load Receivers, please click here.
  • Support Available with a New Receiver - A checkmark means that the database is supported by GenRocket, but will require a new Receiver.
  • JDBC- This column shows if a JDBC Driver is available for the database. A checkmark means that a JDBC Driver is available either through the database provider or a 3rd party provider. If a JDBC Driver is available, it should be supported by GenRocket through a JDBC connection.

SQL Databases

Database Supported Validated In Use, Not Validated JDBC Driver Bulk Load Receiver Available Available with a New Receiver
Snowflake ✓ ✓   ✓    
Google Spanner ✓ ✓   ✓    
H2 ✓ ✓   ✓    
IBM DB2 ✓ ✓   ✓ ✓  
MariaDB ✓ ✓   ✓ ✓  
MySQL ✓ ✓   ✓ ✓  
Netezza ✓   ✓ ✓    
Oracle ✓ ✓   ✓ ✓  
PostgreSQL ✓ ✓   ✓ ✓  
SAP HANA ✓ ✓   ✓    
SAP Sybase ASE ✓ ✓   ✓ ✓  
SQLite ✓ ✓   ✓    
SQL Server ✓ ✓   ✓ ✓  
Sybase ✓ ✓   ✓ ✓  
SingleStore 
(formerly memsql)
✓ ✓   ✓    
Teradata ✓ ✓   ✓    
Other Databases           ✓

NoSQL Databases

Note: Project setup for a NoSQL database requires different steps than a SQL database. See Test Data Projects Overview for more information and guidance on setting up Projects. 

Database Supported Validated In Use, Not Validated JDBC Driver Bulk Load Receiver Available Available with a New Receiver
Aerospike       ✓    
Apache Cassandra ✓   ✓ ✓    
Apache Couchdb       ✓    
Apache Hbase       ✓    
Amazon DynamoDB ✓ ✓    ✓    
Amazon SimpleDB       ✓    
ArangoDB       ✓    
Azure Cosmos DB       ✓    
Cloud Redshift       ✓    
Couchbase Server ✓   ✓ ✓    
FileMaker       ✓    
MarkLogic       ✓    
MongoDB ✓ ✓   ✓    
Neo4j       ✓    
OrientDB       ✓    
Oracle NoSQL       ✓    
Redis       ✓    
Riak       ✓    
SAP HANA ✓ ✓   ✓    
Other Databases           ✓

 

Fixed or Flat File

Database Supported Validated In Use, Not Validated JDBC Driver Bulk Load Receiver Available Available with a New Receiver
Microsoft Access ✓     ✓    
Microsoft Excel ✓ ✓   NA    
VSAM ✓ ✓   ✓    
Other Fixed File Formats           ✓

 

Data / Lakehouse Platforms

Platform Name Supported Validated In Use, Not Validated JDBC Driver Bulk Load Receiver Available Available with a New Receiver
Databricks ✓ ✓   ✓ ✓   

 

Other Supported Databases

Database Supported Validated In Use, Not Validated JDBC Driver Bulk Load Receiver Available Available with a New Receiver
IBM IMS ✓ ✓   ✓