Data Cleanser utility
The Data Cleanser utility reformats one or more raw performance history data files downloaded from SAP using the ST03N transaction, and consolidates them into a single file that you can use as follows:
-
To provide usage data for the SAP HANA Migration Assessment app.
-
To create a Performance History Data External Data Source.
You should download performance history data from the SAP ST03N transaction as text files in Unconverted format. The Data Cleanser utility supports input files with the following formats:
-
ASCII
-
UTF-8
-
UTF-16BE
-
UTF-16LE
The resulting ASCII file is in CSV format with a .txt extension, and has the following columns:
-
Program or Transaction Name
-
Name of Background Job
-
Description
-
Usage Count
The Data Cleanser aggregates usage counts for each executable so that each executable appears once only in the resulting file.
To cleanse one or more performance history data files, follow these steps:
-
Obtain the performance history data as text files using the SAP ST03N transaction, and save them to a local directory on your machine.
-
Select the
icon in the consumer interface’s navigation panel. -
In the Data Cleanser screen, click Add Files.
-
Select one or more files containing performance history data downloaded from SAP and select Open. Alternatively, you can drag and drop one or more files into the Data Cleanser control.
-
Select Remove next to a file to remove it from the control.
-
Select Clear Queue to remove all the files from the control.
-
Select Start Upload to upload and cleanse the files in the listed in control. The Data Cleanser displays an error message for any files that don’t contain valid performance history data.
-
In the Results screen, select the Download link to download a single file named DataCleanser.txt containing the cleansed performance history data.
-
To use the file in the SAP HANA Migration Assessment app, copy it to a directory that’s accessible to your As-Is SAP system.
-
To use the file to create a Performance History Data External Data Source copy it to a local directory on your machine.