05/09/2023 02:54 AM
Hello,
Saviynt database columns' naming convention is not consistent. Some columns are in camel case, some are in lowercase, and some have underscores. Plus, some tables have description in the column name like "endpoint.endpointname" while others have simply name like "accounts.name".
Do you have plans to standardize the DB columns' names? It would make life a lot easier for everyone.
There are several examples:
Thanks in advance!
05/09/2023 04:16 AM
HI @Olesia
There are no columns with accounts.name or endpoint.endpointname. ( these may be binding variables you are using it)
Also right now there is no plan to normalise for now, but this can be taken a look into it, I would suggest this to raise in ideas portal on this and take it forward.
Thanks
Darshan
05/09/2023 04:52 AM
@Darshanjain I didn't state that the column name is accounts.name or endpoint.endpointname. There was just an example that in a table endpoints there is a column "endpointname" but in a table accounts there is a column "name", not "accountname" as might be expected.
@RakeshMGThanks for the information!
05/10/2023 01:57 PM
Hi @Olesia ,
Please add your vote to this Enhancement Request here: https://ideas.saviynt.com/ideas/EIC-I-3417
This helps us gauge customer interest in certain new functions to implement.
Thanks!
Tim
05/09/2023 04:19 AM
Thank you for your inputs, we have already have an enhancement for same: https://ideas.saviynt.com/ideas/EIC-I-3417