JDBC Sender Adapter question

[edgardo_colombatto]

Hi everybody,

I´m trying to send an invoice document (header and details) from  legacy system to SAP.

JDBC adapter have  to read   xml  stored in a table field , so for each row in the table we send a document.

We realize that the jdbc adapter read this field as string.

Are there any way of read this data directly as xml , and make easier the mapping process?

Regards

[Harish · Accepted solution]

Hi Edgardo,

you scenario is XML file to SAP (Proxy/IDOC/RFC etc).

why you want to store the data into table?

if you only want to split the input xml, you can do in PI. and if you have to store the data into database then you need two interface. One to pick the file and store the data to database, and other interface to extract data from database and sent to SAP.

regards,

Harish

[edgardo_colombatto · Accepted solution]

We talking about AS400 as legacy system. It isn't so "natural" generate xml files.....!!

We could create xml files calling a java program from a rpg progam.

Our first aproach is avoid any extra layer in the process.

We do it saving the xml in a table in order to be process by PI.

Regards

[Former Member · Accepted solution]

Hi

Read the field as string and then write a java mapping to generate the output.

Please provide the input sample data , if you need any help on java mapping.

[edgardo_colombatto]

Indrajit,

We made a java mapping . It does work.

Thanks,

Regards.

[former_member184720]

Hi -

Are there any way of read this data directly as xml

>>I don't think it's possible with standard features of JDBC adapter.

Either define a job/process to export the data into files and build a file based interface or you might have to go for  Java mapping