Identity Broker Adapter transformation, IsOperative for Empower Organisation doesn't work due to EndColumn value is blank
In section 8.1.3 of the Technical Guide for Empower Organisation Adapter, the Identity Broker Adapter transformation, IsOperative for Empower Organisation doesn't work due to EndColumn value is blank.
All the organisation "Active" status are all "F" (false) when all should be "T" (true). This is because the attribute hr_upto_date specified as the EndColumn of the IsOperative transform is a whitespace/blank. Thus the time end time is invalid.
Peter, could you please advice on how to address this.
Customer support service by UserEcho
As I understand it, there's a 'default' option for that transformation which should be applied if the value is blank. Lets make it true and see if that fixes the problem.
Now that you mentioned it I do recall something like that. It is not documented as part of IDB305:Is operative transformation or IDB304:Is operative transformation
I will look at the old doco that I have.
I could not find any referrence to the default value information for the IsOperative tranformation in Identity Broker v3.0.0 Transformation Configuration Guide.pdf.
Do you know what is the configuration parameter is?
Pass to Peter for information. If not will request information from Product team.
Both fields must be present to achieve this requirement.
I have released v18.104.22.168 of Identity Broker Extended Transformations (Available at SUBIDBXT:Downloads).
Please refer to IDBXT306:Is operative transformation.
IDBXT306:Is operative transformation resolves the requirement.
After reading the IDBXT306:Is operative transformation I am not certain how the attribute AdjustForLocal would help to resolve this issue.
The issue that I am experiencing is that the hr_from_date contains validate date format being specified as the StartColumn, while the hr_upto_date contain a whitespace (not a valid date data) being specified as the EndColumn of the IsOperative transformation.
The Adapter configuration is
I believe what I need is something that allow me to first convert (or replace) the whitespace value of the hr_upto_date to the current datetime.
Perhaps I misunderstood something here.
Lacking that logic of this transformation need to be done in the Codeless Framework configuration. However, I believe the Codeless Framework currently does not have filter for comparing datetime.
The transformation in IDBXT306:Is operative transformation does exactly what you want.
Remember we changed the Empower connector to treat black/space fields in the date columns as null?
I install the UNIFY Identity Broker for Transformations v3.0.6 x86.msi and change the configuration to use the IsOperative.inclusive instead.
Using the UNIFY Identity Broker for Transformations v3.0.6 x86.msi with the following Adapter transformation configuration resolved the issue.
The Active attribute now has the value of "T" (true) rather "F" (false) which was incorrect.
This issue is resolved.