Scenarios › Export the Archived Databases into an RDBMS › Export Archived Databases into an RDBMS

Export Archived Databases into an RDBMS

CA User Activity Reporting Module (CA User Activity Reporting Module) lets you retrieve information on archived database events from your database server directly instead of the CA User Activity Reporting Module server. CA User Activity Reporting Module provides the DBExport Service (utility) to export the archived databases from its server into an RDBMS such as Microsoft SQL, Oracle, or PostgreSQL in your environment.

The following flowchart describes how to export the archived databases into an RDBMS:

Follow these steps:

1. Review the considerations to run the utility.
2. Create a database in your RDBMS to import the archived databases.
3. Encrypt the user password of the target database.
4. Configure the configuration file of the target database.
5. Test the database connection.
6. Test the bulk insert into the target database.
7. Enable the utility.
8. (Optional) Export the old archived databases.
9. Monitor the export of the archived databases.
10. Validate the count of the exported events.