EDI997 to JDBC SP
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.