Import an SAP Audit Format file

You can create an Analytics table by defining and importing an SAP Audit Format file (formerly known as the SAP Private File Format). SAP Audit Format files have a .dat file extension.

You can define and import Audit Format files located on your local computer or on a network drive.

Note

Diligent offers two utilities for directly accessing an SAP system and importing data to Analytics:

  • SAP connector one of the Analytics connectors, available with an additional subscription
  • Direct Link an optional add-on that can be purchased from Diligent

SAP AIS and SAP DART

An SAP Audit Format file is produced by an SAP data extract. SAP AIS (Audit Information System) and SAP DART (Data Retention Tool) are both SAP utilities that can produce data extracts.

When creating extracts using these SAP utilities, the SAP user can specify the file output format. Some Analytics-friendly output formats are spreadsheet, text, dbf, and the SAP Audit Format. These extracts can then be imported into Analytics using the Data Definition Wizard. The ideal format to use is the SAP Audit Format because it requires the least amount of effort to import into Analytics.

Steps

  1. Select File > New >Table .

    The first page displayed in the Data Definition Wizard depends on your configuration. If integration with Analytics Server is enabled the Select Platform for Data Source page is displayed, otherwise the Select Local Data Source page is displayed.

  2. Complete one of the following steps to select the location of the file:

    If the Select Platform for Data Source page is displayed and you want to use Analytics to define the file, select Local and click Next. In the Select Local Data Source page select File and click Next.

    If the Select Platform for Data Source page is displayed and you want to use an Analytics Server to define the file, select ACL Server and select the server profile from the drop-down list, and then click Next. In the Select ACL Server Data Source page select Flat Files and click Next.

    If the Select Local Data Source page is displayed select File and click Next.

  3. In Select File to Define, locate and select the file you want to create the Analytics table from and click Open.
  4. In the Character Set page, verify that the correct character set option has been selected and click Next.
  5. In the File Format page, verify that the SAP private file format / DART option has been selected and click Next.
  6. In the SAP Private File Format page, select the appropriate option for field naming:
    • Use local language field descriptions as ACL field names Select this option to use the localized field descriptions configured for the SAP system, instead of the standard German language field names. This option is recommended if the Analytics table will be used in only one language.
    • Use standard-delivered SAP German abbreviations as ACL field names Select this option if you prefer to use the German field names, or if the Analytics table will be used in multiple languages.
  7. Click Next.
  8. In the Save Converted SAP File As dialog box, enter the file name and modify the folder location for the Analytics data file, as necessary, and click Save.
  9. In the Final page, verify the settings for the new Analytics table and click Finish.
  10. Enter a name for the Analytics table you are adding to your project and click OK.