Policy Server Guides › Policy Server Administration Guide › Configuring Policy Server Data Storage Options › Audit Data Import Tool for ODBC

Audit Data Import Tool for ODBC

The Policy Server can store audit data in an ODBC database or output audit data to a text file. The tool smauditimport reads a SiteMinder audit data text file and imports the data into an ODBC database that has been configured as an audit store using 5.x or 6.x schema.

The smauditimport tool imports authentication, authorization, and admin data into the corresponding tables in the ODBC database. The tool logs the number of rows successfully imported into the ODBC database. For each row in the text file that is successfully imported, the tool replaces the leading character "[" with the number sign "#". For each row that cannot be imported into the ODBC database, the tool logs the row number.

The smauditimport tool can be run multiple times on the same file. The tool only processes those rows that have not been successfully imported into the ODBC database or the rows that begin with the opening bracket "[". To restore a text file to its original format, replace the leading character of every row with the opening bracket "[".

Note: In some SiteMinder documentation, the terms "audit" and "logging" are used interchangeably.