Skip to Content
avatar image
Former Member

questions on to database Pass in SAP IDM 7.2/8.0

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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
    10|10000 characters needed characters exceeded

  • 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
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 02 at 12:22 PM

    Hello guys,

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

    regards

    Manoj

    Add comment
    10|10000 characters needed characters exceeded