1 Reply Latest reply: Jan 26, 2013 12:19 PM by Kevin Pinsky RSS

    challenge question and password migration from oimm 10g to 11g r2

    975120
      hi all,
      can you please tell me how do i do the migration of oim 10g user's password and challenge questions to oim 11g r2. Do we have any api to do it. these values are in encrypted format in oim db.
      thanks
        • 1. Re: challenge question and password migration from oimm 10g to 11g r2
          Kevin Pinsky
          Run your sql query to output the encrypted fields to a flatfile or csv, and include the usr_login field so you know which user to assign the values to.

          Copy your config folder from your oim server and create a patch like c:\xellerate\config. In your code, when you connect to OIM, use this:

          System.setProperty("XL.HomeDir", "c:/xellerate");
          System.setProperty("java.security.auth.login.config", "c:/xellerate/config/authwl.conf");

          Now, when you read the file and have the encrypted field, use this code:

          String decryptValue= tcCryptoUtil.decrypt(encryptValue, "DBSecretKey");

          Now that you have the unencrypted value from your 9x instance, you can use the APIs to set challenge questions, and set user passwords with the 11g APIs.

          -Kevin