Skip to Content
0

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

Jan 31, 2017 at 09:51 AM

159

avatar image
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

capture.png (17.5 kB)
10 |10000 characters needed characters left characters exceeded

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

0

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.

1

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

1
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Steffi Warnecke
Jan 31, 2017 at 03:17 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Deva Prakash B Feb 06, 2017 at 02:40 PM
1

Hi Tobias,

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

Regards,

DP

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 02, 2017 at 10:39 PM
0

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!


c1.png (28.5 kB)
c2.png (17.9 kB)
c3.png (18.9 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

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. ^^

2