Identity Broker Adapter transformation, IsOperative for Empower Organisation doesn't work due to EndColumn value is blank

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.

Hi Peter,

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.

Hi Peter,

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 v3.0.6.1 of Identity Broker Extended Transformations (Available at SUBIDBXT:Downloads).

Please refer to IDBXT306:Is operative transformation.

IDBXT306:Is operative transformation resolves the requirement.

Hi Shane,

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

				<!-- Calculating Active attribute for the Organisation connector -->
				<adapter name="IsOperative" 
					 StartColumn="hr_from_date"
					 EndColumn="hr_upto_date"
					 DestinationColumn="Active"
					 IsOperativeValue="T" 
					 IsNotOperativeValue="F" >
				</adapter>	

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.

Thank you.

Ignore AdjustForLocal.

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?

Thanks Shane.

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.

				<!-- Calculating Active attribute for the Organisation connector -->
				<adapter name="IsOperative.Inclusive" 
					 StartColumn="hr_from_date"
					 EndColumn="hr_upto_date"
					 DestinationColumn="Active"
					 IsOperativeValue="T" 
					 IsNotOperativeValue="F" >
				</adapter>	

The Active attribute now has the value of "T" (true) rather "F" (false) which was incorrect.

This issue is resolved.

Closed.