IIQ JDBC Customization

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

8.5

Share all details about your problem, including any error messages you may have received.

Recently, I got a usecase to modify the resourceObject for a Database Application. I want to understand what should be the better approach while using the rules.
Like which rules can be used and which type of rule will be better.

2

You can use Customization Rule or BUildMap rule if the connector Type is JDBC.
But in case of this JDBC Connector, Build Map rule will be better because Customization Rule is more expensive to run during aggregation.

The Reason why it is expensive is below:

The BuildMap Rule executes once per record at the raw data level — it just manipulates a simple Map before IIQ object creation, which is lightweight.

The Customization Rule runs after the object is built (Account or Identity), meaning IIQ has already created and loaded full objects into memory, making it heavier on processing and memory usage.

Therefore, BuildMap is faster and more efficient for transformations during aggregation.

3

For JDBC Connector, I would recommend using BuildMap rule.

4

@Jadhikary if the new attribute is based on other columns, you can also consider modify your query or stored procedure to return the additional column as a query result, then you don’t need any buildmap or customization rule. In case, this is something not achievable via query, go with build map rule as explained above.

Note: Found a fix?Help the community by marking the comment as solution. Feel free to react(:heart:,:+1:, etc.)with an emoji to show your appreciation or message me directly if your problem requires a deeper dive.

5

Hi @Jadhikary ,

For JDBC connector, there are many types of Rules available like BuildMap, MergeMap, Customization Rule. every Rule has different purpose.

Please refer attached document for more details.

Rules in IdentityIQ 7.2.pdf (2.0 MB)

Please keep in mind that these rules can impact execution time of aggregation task.

I would suggest try to check if these rules can be avoided by modifying SQL query.

If it is not possible, you can configure rules based on your requirement (rule should be written in optimized way)

6

what is the requirement, can you please more specific to give the correct solution.

7

Hi @Jadhikary,

I’m not fully clear on the requirement you mentioned about modifying the ResourceObject for the database application.

Could you please clarify a few points.

  1. What exactly needs to be modified in the ResourceObject?
  2. At what stage should this modification happen?
  3. Is the change related to account objects, group objects, or both?
  4. What is the expected outcome after the modification?