How to make custom queries to a jdbc repository via IDM?

This topic has 2 replies, 2 voices, and was last updated 4 years, 6 months ago by pryton.

  • Author
    Posts
  • #20592
     pryton
    Participant

    Hello,

    a requirement is to safe data to a explicit table in the external jdbc repository of our IDM.
    I know there are some predefined query in the repo.jdbc.json, but there are no “insert” examples to insert an entry in a custom Table.

    Is there a way to make it with IDM or do i have to use a custom Database connection und a query?

    #20593
     andi
    Participant

    If the table is appropriately mapped as an explicit mapping, you can just call create on that resource (i.e. the appropriate PUT or POST if done via http). Make sure the user is authorized for that operation on that resource.

    If that doesn’t fit your needs for some reason, you can define predefined, parameterized commands, see the section on “Running Queries and Commands on the Repository” in the integrator’s guide

    #20595
     pryton
    Participant

    Is there a exapmle for the openidm.create() method? in groovy?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

©2022 ForgeRock - we provide an identity and access platform to secure every online relationship for the enterprise market, educational sector and even entire countries. Click to view our privacy policy and terms of use.

Log in with your credentials

Forgot your details?