How to map different data types between LDAP and One Identity Manager (1IM) like string and date? (4320895)

Mapping different data types between LDAP and One Identity Manager (D1IM), like string and date, my be a problem while using virtual properties are used. An error messages like this can be displayed:

String was not recognized as a valid DateTime

Virtual properties don’t work if there is something else on the string attribute, which does not comply with the format configured. (i.e: data mess, dummy data, fill data "---" or "NA" or "?" or special characters (newline, tabs, ...))

SOLUTION

Please follow these steps:

1) New virtual property on the right LDAP side;
2) Type: data conversion;
3) Enter name;
4) Base property: my LDAP attribute of type string;
5) New data type: date and time;
6) Important: on a pure string column, I’m offered a "Special date format";
7) "Special date format" : yyyyMMddHHmmssZ.

Things to observe:

In LDAP many attributes are defined as multi-valued. So you should define in the mapping rule(date <-> date): Handle first property value as single value

This will only work if on the string attribute the date is provided in the format configured or it is empty. If there is something else on the string attribute, which does not comply with the format configured. (data mess, dummy data, fill data "---" or "NA" or "?" or special characters (newline, tabs, ...)), this will fail. In this case data has to be cleaned in the target system or script property has to be used.