Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with "user data detail"

S_SrisaksakulSep 16 2013 — edited Sep 16 2013

Hi  I am using EDQ 9.0.6 in Window 7 platform.

I need some support from the community on how to make "user data detail" tool work.

As show in the picture in the link,

http://img843.imageshack.us/img843/5985/vend.jpg in The datapane, there is no user data detail show.

also as the result i am also unabe to make user notification by email work.

I will be very much appliciate for all the help i can get.

Thanks in advance

Supanut

Comments

Nick Gorman-Oracle

Supanut,

See the processor help here:

http://www.oracle.com/webfolder/technetwork/data-quality/edqhelp/index.htm

The details are only added when used in a real time [i.e. web services] call or run as part of a job.

regards,

Nick

S_Srisaksakul

Thank you for your helpful reply.

I make a test and it is really as you and the help file stated.

It is working on realtime data input.

If you would be kind to help me more,

My destination data table has a field named "UPDATE_USER" to record  name of who put  or update the data.

Are there anyway to link EDQ username to be put in the output data so that non EDQ user know which of the edq user put the data in?

Nick Gorman-Oracle

Hi,

If you're talking about writing the EDQ data back to a database table then you need to read the help topic on Exports.

regards,

Nick

S_Srisaksakul

thanks again

I forgot to mention that  the input data is non-real time and  the problem that I currently have is to aqquire the username from EDQ user since from what i understand  "User data detail" only work  on  real time data. I have no problem writting data back to the database.

regards,

T

Nick Gorman-Oracle

Yes, this processor is specifically designed for real-time mode. The username that invoked a batch job is stored in the event log [which can be snapshotted - see System Information - Event log data store] but it's not easy to add this to batch data [as this would require some post-processing to do the lookup].

Mike-Matthews-Oracle

Batch jobs that write data to external targets are normally run from a schedule by a system user (with rights to execute batch jobs) in any case, rather than by a specific 'user' who is logged into EDQ. Depending on your use case, it might therefore be that you need to identify the update as from EDQ rather than from anyone specific?

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 14 2013
Added on Sep 16 2013
6 comments
477 views