How to read the source file and copy the entire content to the target Database field

[former_member350687]

Hi All,

PI system extracts the actual business content from the incoming attachment file and copy the entire format to the target Database field which is a blob data type field.

Sender Adapter: SOAP

Receiver Adapter: JDBC

JDBC Structure

Can we achived the above requirement by using UDF with out Java Mapping?

Thanks,

Mahi.

[former_member350687]

Hi Christian,

We need to read the content from the file and then we need to populate it to the target field.

Thanks & Regards,

Mahi.

[Former Member]

Ok, in this case yo can use the conten converion of the file adapter. Therefore you first need to create a Datatype in ESR with the required structure

Then in your file adapter you need to use this datatype and its required fields:

The Datatype then can be used as usual within you mapping.

regards

Christian

[former_member350687]

Hi Christian,

I am not using the file adapter.

I am using SAOP with XI Sender and Receiver as JDBC

[Former Member]

So you have the payload from sender in mapping accessable? In this case you can go fo simple graphical mapping and map the required fields to your target structure

[Former Member]

Hi Mahi,

if I understand you correct you allready have the needed payload available and you only want to post the whole payload to the database. Why don't you go for a graphical mapping and use the "Return as XML" function?

regards

Christian