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 | ✓
| ✓
|
| ✓
|
|
|
| H2 | ✓
| ✓
|
| ✓
|
|
|
| IBM DB2 | ✓
| ✓
|
| ✓
| ✓
|
|
MariaDB
| ✓
| ✓
|
| ✓
| ✓
|
|
| Microsoft Azure SQL | ✓
|
|
| ✓
|
|
|
| MySQL | ✓
| ✓
|
| ✓
| ✓
|
|
| Netezza | ✓
|
| ✓
| ✓
|
|
|
| Oracle | ✓
| ✓
|
| ✓
| ✓
|
|
| PostgreSQL | ✓
| ✓
|
| ✓
| ✓
|
|
| SAP HANA | ✓
| ✓
|
| ✓
|
|
|
| SAP Sybase ASE | ✓
| ✓
|
| ✓
| ✓
|
|
| SQLite | ✓
| ✓
|
| ✓
|
|
|
| SQL Server | ✓
| ✓
|
| ✓
| ✓
|
|
| Sybase | ✓
| ✓
|
| ✓
| ✓
|
|
| 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 | ✓
| ✓
|
| ✓
|
|
|
