Identity Management 8.0: Temporary data location of a From-Pass

[Former Member]

Hello experts,

I'm new to IDM 8 and have a, probably simple, question that I could not find any answer to.

I built a job, that reads sample data from a LDAP directory and writes it into the table "import table". It works just fine up to this point.

My question is: Is there a possibility to view/debug all contents of the data returned by this From-Pass WITHOUT making a To-Pass and write it into some file or likewise? I also tried to script and put out the values with uInfo, which works but is very inconvenient. I would like to query my database directly in Oracle SQL developer and view all data that has been stored into "import_table". This will help adjusting the from and to-pass implementation.

I appreciate your help,

Tobias

[former_member2987]

Hi Tobias,

You can also add an extra ToASCIi pass which would source from the "import_table".

Then you can produce a file.

@Steffi, I can think of a few reasons for putting it in a file, mostly for easy sharing of information with fellow developers.

Cheers,

Matt

[Steffi_Warnecke]

For sure. But I was replying to this part:

"I would like to query my database directly in Oracle SQL developer and view all data that has been stored into "import_table"."

and am wondering, what stops him from doing this. 😉

Regards,

Steffi.

[Ckumar]

Hello Tobias,

As suggested by Matt, you can write a "To ASCII" pass after your "From LDAP" pass, which will write your LDAP imported data to a txt/csv file. You can easily verify your imported data by checking this file.

Alternatively, you can use SQL Developer and write a simple SQL statement like (Select * from import_table) to retrieve all the data from your temp table import_table.

Regards,

C Kumar

[devaprakash_b]

Hi Tobias,

As suggested by Steffi, Please use mxmc_rt user for tables created during the run time.

Regards,

DP

[Steffi_Warnecke]

Hello Tobias,

if you have the Oracle SQL Developer at hand, what stops you from creating a query for "import_table" in it and view the content?

.

Regards,

Steffi.

[Former Member]

Hey!

Thanks for your replies. I should've stated, that I already tried the obvious and query the table in sql developer. But it cannot be found. I must be doing something wrong.

I'm trying to query in Oracle SQL developer with mxmc_oper. Is it an authorization issue maybe?

Screenshots:

Job loads 66 entries:

Query an IDM table: works.

Query "import_table": Table or view not found 😞

What is it that I am missing?

Thanks!

[Steffi_Warnecke]

Try with the runtime user instead (mxmc_rt), because that's the one your job uses anyway.

If you test new queries in the SQL developer you want to use in jobs or tasks or scripts etc, always use the rt-user.

.

Regards,

Steffi.

PS: And yes, those details are kind of important to explain in the question. ^^