Export run results to InfluxDB or JSON

Using the Raw Results Exporter tool, you can export scenario results to an InfluxDB database, or to files in JSON format.

Exporting raw data to other formats is useful when, for example, the run results are too large for Analysis to handle, or when you want to use test data in applications developed for your specific needs.

Security Note:

OpenText encourages you to ensure secure configuration, purging, monitoring, and hardening of the InfluxDB—this is not provided by OpenText.

If you do not implement secure configuration, purging, monitoring, and proper hardening, you may expose the system to increased security risks. You understand and agree to assume all associated risks and hold OpenText blameless for the same. It remains at all times solely the responsibility of the customer to assess their own regulatory and business requirements. OpenText does not represent or warrant that its products comply with any specific legal or regulatory standards applicable to the customer while conducting the customer's business.

In this topic:

About exporting data to InfluxDB

Exporting raw results to an InfluxDB database enables you to use the data in applications other than Analysis.

The data exported to InfluxDB is output to a running InfluxDB server. InfluxDB versions 1.8 and 2.x are supported.

To reduce the time spent collating and exporting data at the end of a scenario run, you can export data to an InfluxDB database during runtime. Use the option Automatically export results to InfluxDB in the Collate Settings dialog box. Refer to Collate scenario run results.

Controller supports two methods for exporting data to InfluxDB:

• From the user interface—for details, see Export data to InfluxDB from the UI.
• From the command line—for details, see Export data to InfluxDB from the command line.

The data exported to InfluxDB is stored in the database in the following tables:

Back to top

Export data to InfluxDB from the UI

You can execute the export of results data to InfluxDB from Controller.

To export run results to InfluxDB:

1. In Controller, select Results > Influx Settings.

   The InfluxDB Settings dialog box opens.

2. In the dialog box, configure the export:

   1. Select the relevant InfluxDB version.

   2. Define the Server URL. This is an external, customer server, and not part of the LoadRunner Professional system. Define the URL of the database server, and include the port number.

      For example: http://my-influx-url:8086

      HTTPS URLs are supported, as long as the appropriate certificates have been installed.

   3. Configure the rest of the information as relevant:

   InfluxDB 1.8		InfluxDB 2.x
   Database name	Enter a name for the exported database.	Organization ID	The ID used in InfluxDB for your organization.
   Username and Password	These settings must be completed if the InfluxDB server requires authentication; otherwise, they can remain blank.	API Token	The InfluxDB token that provides authentication to write to your bucket.
   Proxy fields	Enter proxy server details, if relevant.	Bucket name	The name of the InfluxDB bucket where the data is stored.

3. Save these settings. The settings remain in effect until changed.

4. In the Controller menu, select Results > Export to InfluxDB.

   A notification pane opens. During the export, status and messages are displayed in this pane.

5. When the export is complete, click Close.

Back to top

Export data to InfluxDB from the command line

You can export raw results data to InfluxDB from the command line.

Enter the following on the command line:

 LrRawResultsExporter -source_dir <folder_path>
     [-to_influx -influx_url <server url> -database <database name>] [-user <username> -password <password>]
     [-proxy_server <server url> -proxy_user <username> -proxy_password <password>]
     [-target_dir <folder_path> -to_json] 

Parameters:

Back to top

Export data to JSON

Exporting test results to files in JSON format enables you to use the data in applications other than Analysis.

The data exported to JSON is output to a folder, and contained in a set of files:

To export raw data in JSON format, enter the following on the command line:

Parameters:

Back to top

Excluding time zone information from exported data

By default, the result time zone information is included in the exported raw results data.

When exporting to InfluxDB or JSON, you can configure the export to exclude the time zone information.

To exclude the timezone:

1. Open the <LoadRunner Professional root folder>\Analysis\LrRawResultsExporter.ini file. If the file does not exist, create a file by the name LrRawResultsExporter.ini in that location.

2. Add the following line: IncludeResultTimeZone=0.

This setting is effective for:

• Controller. If you set this configuration and then select Export to InfluxDB from the Controller user interface, the exported data will not contain the time zone difference. For details, see Export data to InfluxDB from the UI.

• Raw Results Exporter. If you use the command line Raw Results Exporter tool to export raw data to Influx or JSON, the exported data will not contain the time zone difference. For details, see Export data to InfluxDB from the command line.

• LoadRunner Enterprise. For LoadRunner Enterprise tests with InfluxDB enabled, if the change is made on the host machine used for exporting the result, the time zone difference is excluded. For details, see the LoadRunner Enterprise Help Center.

Back to top

See also:

• Scenario run results