EDI997 to JDBC SP

[Former Member]

Hi Experts,

I am working on EDI 997 to JDBC scenario.

Sender will place EDI 997 files in to source directory, PI will convert EDI to XML and insert those files in to data base for each ST.

I may get multiple ISA segments in EDI 997 file from source, each ISA contains more than one ST segment.

So now i have to insert each ST segment as one row respective to ISA segments...How do i split files for each ISA, if i use split997, there will be two sender communication channels one for getting EDI 997 and one for split997 and one JDBC receiver communication channel. How to configure this?

Appreciate your responce on this. PI version is 7.3 dual stack.

Thank you.

[Former Member]

I dont think you need 2 sender channels- 1 channel with Split997 adapter will works fine,

Refer - http://scn.sap.com/thread/755441

[Former Member]

If so, how can i get file from source directory. I am getting EDI 997 from source team.

[Former Member]

997 is the acknowledgement status from partners. you need to configure/set up the 997 in  the receiver channel

e.g if you send 856 transaction to partner - receiver EDI channel has to be set up to receive the 997. and use sender split adapter to receive the acknowledgements,

Refer

[Former Member]

I am using PI 7.3 dual stack as i mentioned.

Any other suggestions, because sender is sending 997 as text file.