Skip to Content
0

questions on to database Pass in SAP IDM 7.2/8.0

Dec 27, 2017 at 01:08 PM

69

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Dominik Trui Dec 29, 2017 at 09:29 AM
0

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...

Share
10 |10000 characters needed characters left characters exceeded
Matt Pollicove
Dec 28, 2017 at 05:38 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 02 at 12:22 PM
0

Hello guys,

i strongly agree to your commands, thanks for the answers. So its like a Man with one and only option.

regards

Manoj

Share
10 |10000 characters needed characters left characters exceeded