Release Notes › Known Issues › General › CA Identity Manager Connector Requires Connector Configuration Changes

CA Identity Manager Connector Requires Connector Configuration Changes

The CA Identity Manager connector that is shipped by default is the r12 connector and is not compatible with r12.5 SP1. As a result, the following connector configuration changes are required:

• SourceName: the name of Data Source on the agent machine - imsauditevent12
• AnchorSQL: select max(id) from imsauditevent12
• AnchorField: IMS_EVENTID
• EventSQL:  select imsauditevent12.id as IMS_EVENTID ,imsauditevent12.audit_time as IMS_AUDITTIME ,imsauditevent12.envname as ENVNAME ,imsauditevent12.admin_name as ADMINUNIQUENAME ,imsauditevent12.admin_dn as ADMINID ,imsauditevent12.tasksession_oid as TRANSACTIONID ,imsauditevent12.event_description as EVENTINFO ,imsauditevent12.event_state as EVENTSTATE ,imsauditevent12.tasksession_oid as TASKOID ,imsaudittasksession12.task_name as TASKNAME ,imsauditeventobject12.object_type as OBJECTTYPE , imsauditeventobject12.object_name as OBJECTUNIQUENAME ,imsauditobjectattributes12.attribute_name as ATTRNAME ,imsauditobjectattributes12.attribute_oldvalue as ATTROLDVALUE ,imsauditobjectattributes12.attribute_newvalue as ATTRNEWVALUE ,imsauditobjectattributes12.attribute_newvalue as ATTRVALUE from imsaudittasksession12, imsauditevent12, imsauditeventobject12, imsauditobjectattributes12 where imsauditevent12.id >? and imsauditevent12.tasksession_id = imsaudittasksession12.id and imsauditevent12.tasksession_oid = imsaudittasksession12.tasksession_oid and imsauditeventobject12.parent_event_id = imsauditevent12.id and imsauditobjectattributes12.parent_object_id = imsauditeventobject12.id ORDER BY imsauditevent12.id ASC;

Note: The CA Enterprise Log Manager Identity Manager Connector runs on Windows systems only.