Source data types

Identity Security Cloud (ISC) ISC Discussion and Questions
1

I have a source with an integral data type that is left padded with zeros. I assumed changing the attribute data type to int would have attempted to cast the string type and hence, remove the leading zeros.

However, it did not have any effect. I don’t see a solution with a transform, is the only option here a cloud rule?

2

Are there always the same number of zeros? If so you could use a substring transform:

Substring | SailPoint Developer Community

3

Hi Joseph, what connector type is? Is the 0 padding giving you some error when provisioning? Being int type on IDN and system should ignore left pading 0s, if not perhaps you should change IDN attribute type to string.

4

Strange, I have tried with AD connector, bringing userAccountControl as int, and it only shows the number, without 0s. When you can please tell what connector type is, so I can dig in a bit more.

5

Hi Julian,
The AD connector userAccountControl attribute you refer to doesn’t get zero padded because the value is natively an enumeration which is an integral data type.

I am using the UKG connector, the attribute type is employeeNumber.

It is natively a string type, however the configured pattern is 6 digits, left zero padded. This could probably be some other format I am sure, but our local convention is numerical, so an unsafe cast would always work.

6

I think I understand better now. What I guess is that IDN attribute types in schema are only informative, as they bring what is read from source. I think any type you use will appear with the 0s in front, as they are that way in the source. If it is an authoritative source, I am not seeing other way as using a transform as you established first. But it only will throw the leading 0s on identity, I think the value will remain with 0s when you enter into the identity-s account.

7

Hi Julian,
It’s good to know those data types are only informative.

Another user in my original thread where I was redirected here has actually offered a good solution.

Thank you for all the effort!

8

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.