Generating a schema based on an Excel file
After you establish the connection between HCL® OneTest™ Data and Excel, you can generate a schema that is based on an Excel file in HCL® OneTest™ Data.
Procedure
- Select your project in Rational® Test Automation Server and navigate to the Data Fabrication page.
- Click the Connections tab and select the connection that you created.
- Click the menu, and then select New Action.
- Select Target as the Action Type in the New Action dialog box, and then click Next.
-
Enter the following properties of the schema that you want to generate, and
then click Next:
- Select the Excel file that you imported into your project from the Excel File drop-down list.
- Click Fetch to upload all the worksheets of the Excel file in the Worksheet drop-down list.
- Select the worksheet from the Worksheet drop-down list.
Note:You can retain the default property settings for all other fields.
-
Select New, and then click
Generate.
The schema is generated in HCL® OneTest™ Data. HCL® OneTest™ Data generates the schema name as schema_<number>.Note: You must select this schema name as the schema for HCL® OneTest™ Data to generate the test data.
- Select the schema type as Sheet.
-
Click Next to provide the identification details of the
new action, and then click OK.
The new action is created and listed under the connection that is established between HCL® OneTest™ Data and Excel.
Results
You have successfully generated the schema in HCL® OneTest™ Data.
Note:
You can modify the schema name schema_<number> from the Schemas tab.
Tip: If you want to generate schemas for other Excel files, then you must click
New Action on the existing Excel connection. You need not
create a new connection.
What to do next
You can view the generated schema listed under the Schemas tab. You can generate the test data for the generated schema in HCL® OneTest™ Data. See Generating test data by using the generated schema.