Downloading jobs
When you want to test any application by using the generated test data or to reuse the data of any specific schema definition for some other project, you can download the test data from the job into your local file system. You can also download the Structured Query Language (SQL) file from the job that includes the generated Data Definition Language (DDL) statements of multiple non-JDBC schemas.
Before you begin
You must have completed the following tasks:
- Created a project.
- Generated the test data. See Generating test data for selected schemas.
- Generated the DDL statements. See Generating DDL statements.
Procedure
- Log in to HCL OneTest™ Server and open the team space that contains your project.
-
Open your project.
The Overview page is displayed.
-
Click
. The Data Fabrication page is displayed.
-
Click Jobs.
The Jobs page is displayed. You can view the list of all the jobs that include the generated test data or DDL statements.Notes:
- If you want to view only the jobs related to referential integrity, then select Schema canvas jobs from the menu.
- If you want to view only the jobs related to DDL statements, then select DDL job from the menu.
-
Select a job for which you want to download the generated test data.
Notes:
- You can select multiple jobs at a time to download the test data.
- You can download the test data only for the jobs that are completed successfully.
- The download option is disabled for the jobs that are set to insert the generated test data into the database.
- The download option is disabled for multiple DDL jobs.
- Click the Download job(s) button or icon.
Results
- The generated test data in the compressed format in your local file system. When
you download multiple jobs, then the compressed file of the jobs is organized by
time.Note: You can also download the generated test data file from the following location of the HCL® OneTest™ Data pod:
/opt/hcl/hip-rest/output/<accountId>/<userID>/<projectId>/<schemaId>/<genMapPath>
- An SQL file that includes the generated DDL statements of all the selected
schemas.Note: You can also download the DDL statements from the following location of the HCL® OneTest™ Data pod:
/opt/data/hipfiles/<accountId>/<projectId>/yyyy:MM:dd-HH:mm:ss.sql