This question has been asked so far
Due to some access rights issues with AD, we are not able to synchronise with AD to pull details into ARA. Can we know what tables should be updated to have the email address, as well as other details, in ARA? Attached are
1. A user profile which contains all AD details
2. A user profile which does not contain the AD details

=> if you want to verify the user information from user in ARA you can access to the table name "Member"

However modify the email address directly from ARA's Database , even you export and import user with the email address (using ARA's utility) will not make the changes in User (when you visit AWI),
It's only work if you update the email address manually so the email address will update in both AE and ARA's DB
Due to some access rights issues with AD, we are not able to synchronise with AD to pull details into ARA. Can we know what tables should be updated to have the email address, as well as other details, in ARA? Attached are
1. A user profile which contains all AD details
2. A user profile which does not contain the AD details

=> if you want to verify the user information from user in ARA you can access to the table name "Member"
select * from Member

However modify the email address directly from ARA's Database , even you export and import user with the email address (using ARA's utility) will not make the changes in User (when you visit AWI),
It's only work if you update the email address manually so the email address will update in both AE and ARA's DB
Thank you for the update.
However, this does not solve the issue at hand: how to update the email address? We need the email address to send automated mail to the user. On investigating AE dB schema, the table USR contains both email addresses, as well as other fields gathered from AD. But there is no apparent link between the two tables. How to determine which entry in AE corresponds to the entry in ARA dB?
Cheers,
Ajay