on Jan 27, 2017Hi,
A customer has an external identity source file wich contains about 70 attributes. We are already using about 40 string attributes and 10 date attributes for users and I have to make a suggestion if Aveksa is able to collect all the external attributes or we have to sort them.
In general what are the limits of attribute numbers for each object type?
Zoltan
Hi Zoltan,
These might change from version to version, and I do not recall seeing them well documented.
My advice is to check under Admin > Attributes each of the objects to see what data types they allow you to use and how many.
As far as I know, for the User object there was no limit, but then again an Engineer might confirm how their code is designed.
When you extend the User object schema, a new column is added to the MEU table. Depending on the Oracle version you have a limit of columns per table: Logical Database Limits
For the other objects, you have limits as the tables' columns are pre-allocated in the db.
Razvan
Hi Zoltan,
These might change from version to version, and I do not recall seeing them well documented.
My advice is to check under Admin > Attributes each of the objects to see what data types they allow you to use and how many.
As far as I know, for the User object there was no limit, but then again an Engineer might confirm how their code is designed.
When you extend the User object schema, a new column is added to the MEU table. Depending on the Oracle version you have a limit of columns per table: Logical Database Limits
For the other objects, you have limits as the tables' columns are pre-allocated in the db.
Razvan