Skip to Content

SAP IDM - Can we execute stored procedure or insert, update, delete sql statement from java script?

Dear Idm Guru's

Kindly help me by providing solutions for the below mentioned queries.

Can the below methods be possible via Java SCript in IDM rather than using To Database Pass.If yes , can you please let me know how can this be acheived as i see no standard functions available

- Executing stored procedure

- Execute insert, update and delete sql staments on Custom Tables

Can this be tried by importing jdbc connection & sql realated java libraries and using the java functions?

System Details

Version - IDM 8.0 SP4

Database - DB2

Thanks in Advance.

Regards,

Deva

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 11, 2018 at 03:51 PM

    Hi Deva,

    The only officially supported methods are via the established passes.

    Unofficially, one could use a trigger or stored procedure to do some of this work (I have never done so) You might refer to this blog I wrote to give you some ideas of how you integrate this. Database / system performance can be affected as well.

    Note however that modifying the system outside of established practices can affect SAP's ability to support you, and this kind of customization can get wiped in your next upgrade.

    So I don't know that I'd really want to do this without talking to SAP first. If you need to do some sort of update, maybe the product can be enhanced to handle your use case.

    Cheers,

    Matt

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Matt,

      Thank you for your response.

      Can you let me know how to get the output result of the stored procedure.to be visible in job logs(when we use out parmeter). basically we would be using To Database pass and it would execute the stored procedure directly, but if there is any out paramater too, how will it be displayed in job logs

      Regards,

      Deva

  • Oct 17, 2018 at 06:30 PM

    Well I haven't done this before so I can really only give you a rough idea.

    I'd handle it in one of two ways, either have the SP update a table or SP return a value that you can then use to update an attribute or a context variable.

    I've always worked to not do this. I've only used existing SPs to achieve a desired result as mentioned in my blog.

    Add comment
    10|10000 characters needed characters exceeded