I have a long..long list of DNs that I can put into a DN Lookup Node but this takes time and means a single change requires a resonable amount of re-work. I'd like to be able to put my DNs into a Table along with a DEPARTMENT code.
And so use something like the DB Lookup or IF step to use Call.DialedNumber as the lookup value and return DEPT?
Is this possible with the builtin ICM DB Tools?
I wouldn't add any additional tables to the SideA database. It would not affect syncronization, but during an upgrade, the table could be lost. Best case, I would point to a database external to the ICM system. Second best, I would create a new database on the logger or HDS and put that new table in the new database.
You would need to have the client create a new user with rights to the database & table. It would be best if the user had a non-expiring password. I haven't found any other way for this to work.