Hello Experts,
We have a requirement to create unique (sequential) ID for a particular source. what would be the best way to generate this.
For more context - We want something like this person 1’s ID - 001 person 2’s ID - 002 and so on…
I’d suggest a cloud rule, but keep in mind this will be multi-threaded so if you’re expecting multiple accounts at a single time then you’ll likely get duplicated values or failed account creation based on the duplicate.
The alternative is using an additional JDBC source with a backend database that provides table level locking which can then generate a guaranteed unique value which can then be used in another source.
This is also multi-threaded and will produce duplicate values.
Hi Ed,
Are you sure? This is what doxumentation says
For me that suggests, there’s uniqueness check.
There is a uniqueness check, but not guaranteed to be unique unfortunately based on the multi-threading. Depending on what triggers the account creation, this would work in one-off scenarios, but WILL NOT work in multiple simultaneous account creations (been there done that and have been told by SailPoint that this is a side-effect)
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.