ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Identity Manager r12 - How to specify the view/table through Connector Xpress - Identifying Attribute Must be Mapped?

book

Article ID: 53318

calendar_today

Updated On:

Products

DIRECTORY CA Identity Manager CA Identity Governance CA Identity Portal CA Risk Analytics CA Secure Cloud SaaS - Arcot A-OK (WebFort) CLOUDMINDER ADVANCED AUTHENTICATION CA Secure Cloud SaaS - Advanced Authentication CA Secure Cloud SaaS - Identity Management CA Secure Cloud SaaS - Single Sign On SINGLE SIGN ON - LEGACY CA Data Protection (DataMinder) CA User Activity Reporting

Issue/Introduction

Description:

When attempting to configure specific SQL attributes through Connector Xpress, you see the following error: Identifying Attribute Must be Mapped: eTDYNAccountName

Solution:

How to specify the view/table through Connector Xpress?

Issue Example #1:

When connecting to the SQL Database you see the attributes in a system table, however, not the one(s) needed.
How do you point to the view/table that you need so you can use this table to create global users within IDM?

Answer:

The Identity Manager SQL connector only manages SQL Logins, not data in tables. So if you are looking to use data in tables as userIDs, you will need to use the Connector Express and JDBC connection to define a custom connector.

Connector Express is located on the Identity Manager Provisioning Components CD image.

Issue Example #2:

When connecting to the SQL view (through Connector express) you are not seeing the IDM Global user attributes within the attributes column (see image below).

<Please see attached file for image>

Figure 1

Answer:

You will not see a larger number of attributes in the "Attribute" drop down list within the Connector Xpress Step "Map Account Table", even if you have an attribute set for the Global User in IDM. This is because they are defined as "Null" in the SQL Db Table.

You will see the following error after adding a key to the SQL table and clicking the Next button.

<Please see attached file for image>

Figure 2

Resolution:

This issue is the result of creating a Database Table where ALL fields allow NULLs.
Connector Xpress is unable to determine which field is the primary field because none are REQUIRED.
If you make the appropriate field REQUIRED on the Database Table then you will be able to map the eTDynAccount field.

Environment

Release:
Component: IDMGR

Attachments

1558711325879000053318_sktwi1f5rjvs16s7s.gif get_app
1558711323725000053318_sktwi1f5rjvs16s7r.gif get_app