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

Import Audit Data into an ODBC Database

The tool smauditimport reads a SiteMinder audit data text file and imports it into an ODBC database. The tool is located in the \bin directory under the Policy Server installation directory.

Important! Before you import audit data into an ODBC database, configure the database as an audit store with SiteMinder 5.x or 6.x schema. For more information about how to configure an ODBC database with SiteMinder schema, see the Policy Server Installation Guide.

Important! If you are running a SiteMinder utility or executable on Windows Server 2008, be sure to open the command–line window with Administrator permissions, even if you are logged into the system as an Administrator. For more information, see the release notes for your SiteMinder component.

To import audit data into an ODBC database

1. On the computer where the Policy Server is installed, navigate to siteminder_installation\bin.
   • siteminder_installation

     Specifies the Policy Server installation path.

2. Run the following command:

   smauditimport audit_file dsn user_name user_password -f -v -bbulk_load_size -s5 | -s6

   • audit_file

     Specifies the path and name of the text file containing the audit data.

     Note: The smauditimport tool requires the full path name of the audit data text file.

   • dsn

     Specifies the Data Source Name (DSN) of the ODBC database.

   • user_name

     Specifies the name of the ODBC database administrator.

   • user_password

     Specifies the password of the ODBC database administrator.

   • -f

     (Optional) When an error occurs while importing audit data, smauditimport logs the row number and continues processing.

     Default: Without the -f option, smauditimport logs the row number, but stops processing when an error occurs.

   • -v

     (Optional) Validates the number of fields in the text file, validates that the values in numeric fields fall within specified ranges, validates the connection to the database, and outputs errors.

     Note: When the smauditimport tool is run in the validation mode, no data is imported into the database.

   • -b bulk_load_size

     (Optional) Specifies the number of rows to read and import into the ODBC database.

     Default: 100

   • -s5 | -s6

     (Optional) Supports an ODBC database configured as an audit store with either 5.x schema or 6.x schema.

     Default: Supports an ODBC database configured as an audit store with 6.x schema.