Below screenshot showing accounts that are owned by this identity. I have updated 1 of the records from Orange HRMS to inactive, we can see the status of the AD account is updated to “disabled” and colored in grey and it is expected to be. But Orange HRMS’s is remain “Enable” and colored in green even it is in inactive status.
Would like to know why this is not updated for source application and way to fix this.
Thanks for your clarification, that is very helpful idea. If the HRMS source is not using JDBC connector such as SAP, do the method for SAP same as well?
Also regarding option 2, technically how can we achieve this?
So I believe for OrangeHRM you can rely on the emp_status field - it contains ID reference to particular job status like active, inactive etc. If into the select statement instead of field name you put something like IF(emp_status = 2,true,false) as IIQDisabled it will just return true whenever employee will have emp_status equal 2. This syntax of course works only in MySQL as that’s where I was testing that.
You will get something like that
and since field is called IIQDisabled you can just use it directly in the schema.
Regarding second question - where you don’t have access to the aggregation query - the only solution you have is to use BuildMap rule for that.