Issue in Data target in SAP IDM

[Former Member]

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

[Former Member]

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.

[former_member2987]

Krishna,

This does not necessarily need to be the case. As I recall, IDM translates the stares parameter so veg if DDM.identitycenter was used it would still show the connection string.

However, that doesn't mean that double checking the connection string is a bad idea. 🙂

Matt

[Former Member]

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

[former_member2987]

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

[bxiv]

I believe I had issues with MS SQL (2008 R2) and its use of dynamic ports to setup the database instance, my DBA had to set a static port on the instance for things to work correctly for me.

[terovirta]

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?

[Former Member]

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