Show TOC

Function documentationCSV Data Sources

 

You can extract data from one or more CSV files that are stored on the SAP Solution Manager application server. Extracting data from CSV files allows you, for example, to compare data in a “hybrid” scenario where some of your data is stored in the cloud and other data is stored on-premise, provided that you have first extracted your data in the cloud to a CSV file.

When you run the comparison, the data from the specified CSV files is read directly. In this case, no function module or query is generated.

Prerequisites

You have stored the CSV files that are to be compared on an SAP Solution Manager application server.

Activities

The following data is required:

  • Host Name: The application server that hosts the data

  • Path Name: Path to the directory in which the CSV file is stored.

  • File Name: Name of the CSV file.

You have the following options when using CSV files:

  • You can select several CSV files for processing by specifying a path but no file name. The system processes all files in this path.

  • You can enter the following parameters in the File Name field:

    • $TODAY: The system selects all files that have today's date in the format YYYYMMDD in the file name. For example, if the date is September 21, 2015 and you enter data$TODAY.csv, the system might return a file named data20150921.csv.

    • $YESTERDAY: The system selects all files that have yesterday's date in the format YYYYMMDD in the file name. For example, if the date is September 22, 2015 and you enter data$YESTERDAY.csv, the system might return a file named data20150921.csv.

    • Wildcard: You can use an asterisk (*) to stand in for any characters in the file name, and you can combine this with the parameters mentioned above.

  • Use the following parameters in the Created From and Created To fields to enter a start and end time for the creation date of CSV files.

    • $TIMES: timestamp now (offset in seconds). Example: $TIMES-10

    • $TIMEM: timestamp now (offset in minutes). Example: $TIMEM-30

    • $TIMEH: timestamp now (offset in hours). Example: $TIMEH-12

    • $TIMED: timestamp now (offset in days). Example: $TIMED-1

  • You can specify whether the CSV files that are to be compared contain a header row. If you set this value to X, the first row in the CSV file is ignored.

  • If your CSV files are separated by a character other than a comma (for example, a semicolon), you can enter the delimiter used in your files here.