Administration Guide › CA User Activity Reporting › CA UAR Functionality › How to Integrate CA UAR with CA IdentityMinder › Create a New Connector

Create a New Connector

Follow this procedure to create a connector.

Follow these steps:

1. Log in to the CA UAR Server at the following URL:

   https://host:5250/spin/calm/CALMSpindle.csp
   

2. Navigate to Administration, Log Collection, Agent Explorer, Default Agent Group.
3. Select the agent machine.
4. Switch to Connectors view.
5. Click the Create a new Connector button and enter the following information:

   Connector Details

   Select Integration type CAIdentityManager and change the connector name if desired.

   Connector Configuration

   Connection String

   • Driver={SQL Server} ; Server=<Auditing DB Server> ; Database=<Auditing DB>
   • Driver={Microsoft ODBC for Oracle} ; Dbq=<Auditing DB TNSname>

   Username: Auditing DB User

   Password: Auditing DB User Password

6. Apply the following connection configuration changes to the CA IdentityMinder Connector for use with 12.6.2.
   • 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;
     

7. Save and Close.

To verify that the connector is working

1. Navigate to Administration, Log Collection, Agent Explorer, Default Agent Group.
2. Select the agent machine
3. Switch to Connectors View and click the Launch Status and Command View button.

   The status should be running.