Policy Server Guides › Policy Server Administration Guide › Configuring Policy Server Data Storage Options › Configure LDAP Storage Options › 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 the SiteMinder schema, see the Policy Server Installation Guide.

Important! Before running a SiteMinder utility or executable on Windows Server 2008, open the command line window with administrator permissions. Open the command line window this way, even if your account has administrator privileges.

Follow these steps:

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

   Note: If using the smauditimport tool to import audit data into an Oracle database using the -b option, do not set the Enable bulk load option in the ODBC Oracle Wire Protocol Driver Setup dialog. If the ODBC Oracle Wire Protocol Driver Setup Enable bulk load option is set, unexpected behavior occurs during the bulk load.

   -s5 | -s6

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

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