Previous Topic: Audit Data Import Prerequisites for ODBC

Next Topic: Specify a Netscape Certificate Database File

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.
  2. Run the following command:

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


Copyright © 2010 CA. All rights reserved. Email CA about this topic