Hello Experts!!!,
I'm just having some questions regarding TO DATABASE PASS in sap IDM 7.2/8.0
actually we want to delete a record from a table which is not in IDM database. literally from other DB where we just make connection to it and perform our Insertion but we cannot do removal/update unless we use Sql updating.
Is there anyway that we can use sql delete/insert/select option on external DB.or if any docs related to it also most welcome.
Could you please guys help me out here?
Regards
Manojkumar
3 Answers
-
Dec 29, 2017 at 09:29 AM
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...
Add comment
-
Dec 28, 2017 at 05:38 PM
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
Add comment