Scenarios › Export the Archived Databases into an RDBMS › Export Archived Databases into an RDBMS › Create a Database to Import the Archived Databases

Create a Database to Import the Archived Databases

Create a database (target database) in your RDBMS to store the archived databases that the utility exports. Execute the script that CA User Activity Reporting Module provides to create the following items:

• The target database with privileges to import the archived databases.

  Default Name: Uarmdb

• The user account with privileges to manage the target database.

  Default Username: UarmUser

  Default Password: UarmPwd

• The following tables in the target database:
  • sim_event to store the events of the archived databases.
  • sim_event_temp to store sample events from the bulk insert test.
• The indexes to fasten database queries.

Follow these steps:

1. Navigate to the following location on the console:

   /opt/CA/LogManager/DBExportService/dbscripts
   

2. Select one of the following scripts depending on your RDBMS:
   • MSSqlServer.sql
   • Oracle.sql
   • PostgresSqlServer.sql
3. Copy the script into your RDBMS.
4. Read the instructions in the script and make necessary changes to the script such as modifying the target database name, creating the user account, and so on.

   Important! Do not modify the table names.

   Note: You can create a user account manually or uncomment the user account section in the script to let the script create the user account.

5. Save the changes and execute the script.