Skip to Content

Issue in Data target in SAP IDM

Hi All

We are trying to configure Provisioning in IDM.We successfully configured till Source Template but when we are trying to do it for Target template we are getting the below error.

Please help us to resolve this issue.

Regards

Pradeep

idm.jpg (128.7 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2013 at 12:05 PM

    Hi Pradeep,

    If I get the idea, first you read the information for .txt file and the you try to create a users from this file into the IdM IS.

    1. First you have to read the information and store it into a new table(HR_TABLE)

    2. Then in your second pass, into the source tab you have to make a select that will read from this table(HR_TABLE)

    3. Finally into the destination tab(of your second pass) you have to get the values from the HR_TABLE

    BR,

    Simona

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 27, 2013 at 01:54 PM

    Pradeep,

    If you're getting this message one of two things are going on:

    1. Your connection to the database is not correct.

    2. There is no data in the table

    Matt

    Add a comment
    10|10000 characters needed characters exceeded

    • Matt Pollicove wrote:

      Pradeep,

      If you're getting this message one of two things are going on:

      1. Your connection to the database is not correct.

      2. There is no data in the table

      Matt

      Or the SQL statement in the source tab has an error. Not sure if it behaves the same on SQL Server but on Oracle it does.

      What happens when you just add one attribute mapping to the pass, save it and try to run the job?

  • author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2013 at 08:18 AM

    Hi Pradeep,

    From the screenshot, in the To- IDS store pass, in the source tab, the database sting you have given is the conneciton string of a different database. It should be %$ddm.identitycenter%. The reason is...

    In the first pass, you will read the entries from the ASCII file to IDM database(Identity Center) that means the database should be %$ddm.identitycenter% in the destination tab of the Read HR pass which will write to HR_Sample table.

    In the To Identity-Store pass, the source should be identity center database i.e %$ddm.identitycenter%

    as you will read data from the HR_Sample table populated in the previous pass and write to identity store.

    And to insert the source attributes in the To-Identity store pass,the Read HR pass should be run first as this is when the table will be created in the identity center database

    Hope this clarifies. Let me know for any more help.

    Regards,

    Krishna.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Matt Pollicove

      Hi Matt,

      Thats correct !! I guess Pradeep is trying with the tutorial of IDM where the basics are practices following the tutorials that comes in the installation folder, if you can refer to screen shot.

      So my guess is the wrong database connection is configured.

      Hi Pradeep,

      Did you try the suggestion, what was the issue ?

      Cheers,

      Krishna

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.