Establishing a connection between HCL OneTest Data and Excel

When you want to generate a schema based on an Excel file, you must establish a connection between HCL® OneTest Data and Excel.

Before you begin

You must have imported an Excel file from your computer into your project. See Importing an Excel file.

Procedure

  1. Log in to HCL OneTest Server and open the team space that contains your project.
  2. Open your project.
    The Overview page is displayed.
  3. Click Author > Data Fabrication.
    The Data Fabrication page is displayed.
  4. Click Connections.
  5. Click New to create a new connection.

    The New Connection dialog box is displayed.

  6. Select Excel as a connection type, and then click Next.
  7. Provide a name for this connection.
  8. Click OK.

    You can see the name of the connection under the Connections tab.

Results

You have successfully established the connection between HCL® OneTest Data and Excel.

What to do next

You must generate a schema in HCL® OneTest Data based on the Excel file. See Generating a schema based on Excel file.