- Does tool support connectivity with MainFrame system? Mainframe files are in EBSDIC format. - Yes, GenRocket can generate data and output data to mainframes in the required format via GenRocket's fourth component a GenRocket Receiver. A GenRocket Receiver morphs generated data into a specific output format. A GenRocket Receiver doesn't know that it's delivering its formatted data to a mainframe or a PC; it only knows that it's supposed to deliver the data in its specific format to a given destination; that destination can be anything that can receive and use the formatted data. Here are two basic examples:Mainframes that use VSAM (Virtual Storage Access Method) method for storing and retrieving files, the GenRocket FixedFileReceiver would most likely be used to output the generated data.Any mainframe that contains a database that can be accessed via JDBC (Java Database Connectivity) can receive generated data, in real-time, via our GenRocket GenericSQLInsertReceiver, which can connect directly to a database via JDBC even if it is on a mainframe.We currently have 41 Receivers that can morph data to many different formats; however, If you have a customer the requires data in a format that we do not currently support, then after gathering the specifications for the required output format, we can normally turn out a new GenRocket Receiver in one to two weeks. We normally create new Receivers at no cost to the customer because we can add it to our growing list of Receivers for all GenRocket customers to use.
- Does tool provide referential integrity feature while subset data pulled from production to QA for multiple tables? - If you are migrating data from Source Database to Destination database and you write a query to just pick only subset of data for a table (e.g. id > 10), then for your child tables, you need to mention what subset of data you want to pick from Child table as well (parent_id > 10).
- GenRocket is a test data generator tool and not a data extractor tool? Can it extract production data from mainframes? - Yes, we can extract data from a mainframe even if it's in EBCDIC. GenRocket has a component of its system called, GMigration. GMigration is GenRocket's migration tool that allows data to be extracted from one or more source database tables and migrated into one or more destination tables (or to files) via JDBC. If the mainframe database (e.g. DB2, Oracle) speaks over JDBC, then GenRocket's GMigration tool can extract data for the purposes of data migration.
- Confirm whether if the Mainframes files are in EBCDIC will it support? - GenRocket's fourth key component is called a Receiver. GenRocket Receivers morph generated data into some usable format. We can easily implement a Receiver that converts ASCII generated data into EBCDIC output data and in the required format (e.g. IBM 360/370 Card80).
If there are other areas of GenRocket where we may need to address EBCDIC conversions (e.g. GMigration), adding a component to our environment to handle ASCII to EBCDIC conversion and vice-versa, is easily doable.
GenRocket is a component-based platform designed to quickly adjust and adapt to meet the needs of customer test data challenges. At GenRocket, we quickly implement new Generators, Receivers add new features to our platform, all the time, for licensed customers actively using the GenRocket platform.