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

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


Article ID: 199861


Updated On:


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


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.


Release : 14.3

Component : IdentityMinder(Identity Manager)


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. The below is for Oracle. You would enter the url to SQL.

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.