Need audit data for 10 years and would like to archive tasks to different DB

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

We have a requirement of storing IDM audit data for 10 years.
Is there any way we can archive the tasks to different DB rather than keeping them in same DB.

Environment

Release : 14.3

Component : IdentityMinder(Identity Manager)

Resolution

The below is provided as is and out of scope of L1 support.  This is for standalone IM only.  vApp does not allow modification of the needed files.

You may want to contact your Broadcom Account team and engage services if you need a custom solution created for you.

Review the steps below:

Create a full backup of your system

1. Create a new empty DB
2. Point the Jboss datasource to the empty DB. /opt/CA/wildfly-idm/standalone/configuration/.
Edit the CA-standalone-full.xml you are using.
For archive you modify the connection-url to the new empty DB. 


Restart IM which would allow IM to create the new tables in the new Archive DB. This allows all new archived items to be written to the new DB location for archive. This would not move any of your existing items.

To move your existing items you will need to create a migration script. Please review \CA\Identity Manager\IAM Suite\Identity Manager\tools\db\SqlServer. You may be able to use the im_mssql_audit.sql as an example to build your own script.