Use the Report Exporter

The Report Exporter allows you to share Data Integrity test reports with others without having to forward database files and the Report Viewer to them. It also lets you process results using your own reporting tools. You can generate these reports by defining the Report Path test step in the Complete Row by Row Comparison or Complete Tree Comparison modules.

Download the Report Exporter

You can download the Report Exporter from the Downloads list on the top menu of Tosca Cloud. This way, you will get the exporter as an executable file: Tricentis.DataIntegrity.Report.Exporter.exe.

Export a report

After you create a test report with the Complete Row by Row Comparison or Complete Tree Comparison module, you can export it as an HTML or CSV file. To do so, follow these steps:

  1. Enter the command line <file path>>Tricentis.DataIntegrity.Report.Viewer.exe <arguments> in your command prompt.

  2. Replace <file path> with the path to the folder that contains the Tricentis.DataIntegrity.Report.Exporter.exe file. For example: C:\Users\MyUser\Downloads>Tricentis.DataIntegrity.Report.Viewer.exe <arguments>.

  3. Replace <arguments> in your input with the arguments you want to use from the following table:

    Argument name

    Value

    --i, --input

    The absolute path to your Data Integrity test report.

    --o, --output

    Path to where you want to save the output:

    • If you export one table, you can enter the path to a directory or a file.

    • If you export multiple specific tables, enter the path to a directory. The Report Viewer saves the report files in the format <name of the report file>_<table>.

    • If you don't use the table argument because you want to export all tables, enter the path to a directory.

    Note: the export file of the Summary tab is always a JSON file. If you want to export the Summary tab and you specify the path to the file, the file name must have the extension .json.

    --f, --format

    Specify the output format. The default value is CSV. Use this argument and enter HTML, if you want to export an HTML file.

    --t, --table

    Name of the table for which you want to export. Enter one of the following values: Differences, Unmatched, Invalid, UnmatchedSource, UnmatchedTarget, InvalidSource, InvalidTarget, or Summary.

    The export of matched rows is not supported for HTML.

    You can export reports for multiple tables in one of the following ways:

    • Use the argument multiple times, one argument per table.

    • Don't use the argument at all. In this case, the Report Exporter exports reports on all tables.

    --d, --delimiter

    Specify the delimiter you use to separate the values, only if you want to export a CSV file.

    The default delimiter is a comma. If you want to separate values in a different way, enter the desired delimiter.

    --progress

    Show export progress.

    --h, --help

    Show help.

    --V, --version

    Show version information.

  4. Run the command.

You use the Report Exporter to take the information from the test report file example_report.db in the C:/ExampleFolder and export it as an HTML file. You want to create separate files for the tabs Summary and Differences and save them to C:\ExampleFolder.

To do so, you enter the command: Tricentis.DataIntegrity.Report.Exporter.exe --input C:\ExampleFolder\example_report.db  --output C:\ExampleFolder --t Summary --t Differences --format html in the exporter command line.

You use the Report Exporter to take the information from the test report file myreport.db, which is in the same folder as the file Tricentis.DataIntegrity.Report.Exporter.exe and export it as a CSV file. You want to export a report on the Summary tab, and save it to C:\ExampleFolder\summary_report.json.

To do so, you enter the command: Tricentis.DataIntegrity.Report.Exporter.exe --myreport.db  -output C:\ExampleFolder\summary_report.json  --table Summary in the exporter command line.

Data Integrity tests that you upload from Tosca on-prem (opens in new tab) can be set up to trigger report exports (opens in new tab) during their test runs. These test will keep exporting these reports in Tosca Cloud. However, you cannot manage or remove this functionality in Tosca Cloud.