Hi *,
In our database resource there are two tables containing user accounts, and we want IDM to hold some attributes from each one, but it seems IDM could only map to one table while configuring Database Tables, how could i get around with this? hope i make the question clear. Any ideas are appreciated!
Thanks in advance!
R.
Thurm
Hi ^].
how about defining two resources, one for each table and link them to he same role. Not ideal (e.g. for reconciling) but as far as I know the ootb IDM database table adapter does not support two tables. An other solution is to build a custom adapter. I do not know how much work is involved in that but it will 'fit' better into IDM.
Regards, Theo
This is a definite limit with IDM.
You have a few different choices. therijn is right about one, you can simply have two resource adapters. I'm sure your tables map somehow internally. Another option is to build a custom adapter like he mentioned. Another option is to build a 'view' in the database (if it supports it). Database views can however be slow to update, so this might not be ideal if you are dealing with large amounts of data.
The other option, is If you are using IDM 7, take a look at the JDBC Scripted adapter. I haven't used it yet myself, but it is supposed handle multiple database tables.
Good Luck!
Jim
