Yes, the "SQL Update" option on the Destination tab is the correct way to do it. There you can specify any insert / update / delete statement on tables you want.
I'm doing this for years for a couple of target systems and it has its advantages as you directly get feedback to the joblog when something fails (on SQL niveau, not the content itself).
Usually I add a repository so I know about that target system and don't forget about it. Exceptions are just confirming that rule. I set the REPOSITORY_TYPE constant to the system name or I just delete it.
Coming to think of, latter might be not so good when we do the IdM 8 migration...
Hi Manojkumar,
Unfortunately, SQL Update would be the only way to do this either through the use of the appropriate SQL commands or by using some other SQL object that would do the same things. Maybe you could also trigger a piece of PowerShell / .NET / etc. But there's no direct way from IDM.
Matt
Add comment