Add custom schema attribute in Oracle application

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Which IIQ version are you inquiring about?

8.3 P3

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

Can we adding new schema attribute allowed for Oracle DB application? I am trying to add one custom attribute but this attribute not actually exists in DB schema instead we are going to add this attribute value in Customization rule.

When I added the new schema attribute, it is giving me the error “The column does not exist”.

Please suggest how can we add if anyone already configured this.

Thanks in advance.

2

Hi @kavithak

Yes, you can add custom schema and put the value using customization rule. It should work. However, make sure that custom attribute shouldn’t be identity/display attribute. Also can you let me know the connectorType?

3

Hi Arpitha,

Thanks for looking into this.

I have added new schema attribute and using Customization rule to update the value. But still it is giving me the column doesnot exist error.

I am using the sailpoint.connector.OracleDBConnector connector.
I even tried adding the buildMap rule key in application xml since Oracle DB connector doesn’t have BuildMap rule key. (followed this link https://community.sailpoint.com/t5/IdentityIQ-Forum/I-could-not-aggregate-Oracle-E-Business-custom-attribute-to/td-p/104729/page/2).

4

Hi Kavitha,

Yes, I was able to replicate the issue. Both the Customization rule and the JDBC BuildMap rule do not seem to work with the custom schema attribute. It would be best to reach out to the SailPoint Support team for assistance. Please keep us updated if they provide any alternative solutions.

5

Hi @kavithak ,

You can achieve this by using the JDBCConnector, as the BuildMap rule is available for the JDBCConnector(sailpoint.connector.JDBCConnector). This rule allows you to add new schema attributes, which is not supported by the OracleDBConnector.