none
MIM 2016: Oracle agent insert/update multiple tables RRS feed

  • Question

  • Hello,

    One of the systems that I am integrating with is a website that uses Form Authentication. The userId, <g class="gr_ gr_29 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear Punctuation only-ins replaceWithoutSep" data-gr-id="29" id="29">username</g> and hashed password are stored in one table and the role is stored in another table. FK relationship on the userId column. I may not be able to modify the Oracle schema.

    On creating a user in the MIM portal, the user needs to be created in the User table and assigned a role in the User_Role table. I created an Export profile and I was able to get it to sync to one table. 

    Is it possible to update multiple tables using the OOB Oracle agent? If the answer is no, does the agent support calling a stored procedure? 

    I would like to use the OOB Oracle MA because it supports password management which I want to leverage to update the password in one of the Oracle tables on password changed.


    Thanks

    Friday, August 18, 2017 1:41 AM

Answers

All replies