Using the HCL OneTest™ API UI to import data from Tivoli® Composite Application Manager for Transactions

If you are using HCL OneTest™ API 8.6.0 or later, you can use the HCL OneTest™ API user interface (UI) to import service or transaction data from IBM® Tivoli® Composite Application Manager for Transactions.

Before you begin

You need to have access to IBM® Tivoli® Enterprise Portal 6.3.0.3 or later.
Note: If you do not have the required user name and password, contact your Tivoli® Enterprise Portal administrator.
Log into Tivoli® Enterprise Portal and determine which transaction data in Tivoli® Enterprise Portal you want to import into HCL OneTest™ API.
In HCL OneTest™ API, create a performance profile for the stub that you want to use.

About this task

Using the HCL OneTest™ API UI to import data from Tivoli® Composite Application Manager for Transactions involves creating a connection in HCL OneTest™ API to Tivoli® Enterprise Portal, connecting to the portal, and selecting and importing the data to be imported.

Procedure

To create a connection to Tivoli® Enterprise Portal, complete the following tasks:
1. In HCL OneTest™ API, click Project > Project Settings in the menu bar.
  The Project Settings window is displayed.
2. Click the APM preferences tab.
  The APM preferences tab is displayed.
3. Click Add.
  The Select Provider window is displayed.
  By default, IBM Tivoli APM Connection Provider is selected in the Available Providers list.
4. Click OK.
  The new connection is displayed under Connected APM Servers.
5. Under APM Connection Details, enter the following information:
  - In the Name field, enter a name for the new connection.
    Note: Assigning a name helps to identify the connection if there is more than one Tivoli® Enterprise Portal connection in your HCL OneTest™ API project.
  - In the Url field, enter the URL of the Tivoli® Enterprise Portal instance to which you want to connect.
    Note: The URL must include the relevant port number; for example, http://<server>:15210/.
  - In the Username field, enter the required Tivoli® Enterprise Portal user name.
  - In Password field, enter the required Tivoli® Enterprise Portal password.
6. Click Connect.
  HCL OneTest™ API attempts to connect to the specified Tivoli® Enterprise Portal instance.
  If HCL OneTest™ API connects to Tivoli® Enterprise Portal successfully, the lists under Connect are populated.
  If HCL OneTest™ API fails to connect to Tivoli® Enterprise Portal successfully, an error message is displayed and you must check the connection details.
7. In the Default Provider list, click the Tivoli® Composite Application Manager provider that you want to use.
8. In the Default Data Source list, click the Tivoli® Composite Application Manager data source that you want to use; for example, Transaction Reporter.
9. In the Default Data Set list, click the Tivoli® Composite Application Manager data set that you want to use; for example, Aggregates.
10. Click OK.
To import data from the specified Tivoli® Enterprise Portal instance, complete the following tasks:
1. Open the Test Factory perspective.
2. Open a performance profile.
  The Performance Profile pane is displayed.
  Note: If you have not already created a performance profile, right-click a stub and click New > Test Data > Performance Profile on the shortcut menu, enter a name for the profile, and click OK.
3. On the Settings tab, click Import phases ().
  The Import Data wizard is displayed.
4. Under Import data from, click APM Server.
5. Click Next.
  The second screen of the Import Data wizard is displayed.
6. Select the Tivoli® Enterprise Portal connection that you want to use.
  Note: If you want to create a new Tivoli® Enterprise Portal connection or to modify an existing Tivoli® Enterprise Portal connection, clicking Manage Connections opens the APM preferences tab on the Project Settings window.
7. Click Next.
  The Import from APM Server screen of the Import Data wizard is displayed. This screen enables you to configure the query that will be used to retrieve the service or transaction data that you want to import.
8. Click Select Agent.
  The Agent window is displayed.
9. Select the agent that you want to use.
10. Click OK.
11. In the Transaction Group list, click the required transaction group; for example, Transaction.
12. In the Operation list, click the required operation.
13. Optional: To retrieve history data, complete the following tasks:
  - Click Date/Time Range to specify a standard date range or TivoliTimePeriod to specify a Tivoli® time period.
    Note: Clicking Date/Time Range makes the Period field unavailable. Clicking TivoliTimePeriod makes the From Date and To Date fields unavailable.
  - If specifying a standard date range, clicking the calendar buttons next to the From Date and To Date fields displays a calendar pop-up window.
  - If specifying, a Tivoli® time period, enter the required period in the Period field; for example, PT10M (10 minutes), PT1H (one hour), or P7D (seven days).
14. Click Next.
  HCL OneTest™ API uses the query to retrieve the required data from the specified Tivoli® Enterprise Portal instance.
  If the query is successful, HCL OneTest™ API imports the data and the Applying data screen of the Import Data wizard is displayed.
  If the query is unsuccessful, you might have to modify the query you created or verify that the connection to the Tivoli® Enterprise Portal instance is working correctly.
15. Using the lists provided on the Applying data screen, make any required changes to the mapping between the columns in the performance profile and the imported data.
16. Under Options, click Replace existing data if you want to overwrite the existing data in the performance profile with the imported data or click Append to existing data if you want to add the imported data to the existing data in the performance profile.
17. Click Finish.

Results

The imported data is added to the performance profile.