search cancel

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

book

Article ID: 199861

calendar_today

Updated On:

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. 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.