Description
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 | ✓ | ✓ | ✓ | ✓ | ||
| Microsoft Azure SQL | ✓ | ✓ | ||||
| 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 | ✓ |
Other Supported Databases
| Database | Supported | Validated | In Use, Not Validated | JDBC Driver | Bulk Load Receiver Available | Available with a New Receiver |
| IBM IMS | ✓ | ✓ | ✓ |