Skip to Content
avatar image
Former Member

Hana Cloud integration - Split file by no of rows

Hi,

we have an integration requirement to push data from System A(XML) to System B (pipe de-limited file), we planned to use HCI to transform System A content as required by system B. few requirement from System B as below,

  • 1.system B can accept the file with only 1000 rows, System A pushes huge data but needs to be split in to 1000 rows per file (pipe de-limited file).
  • 2.For example, if System A send 10 orders. While splitting order data in to pipe de-limited file with constrain of 1000 rows, then file writing process should check whether the 1000 th row is reached if so then it should check also if records for a particular order are only partially processed if so then skip the file and move on to next file and write the complete order data.

Can we use reiterate splitter and ftp adapter to complete this logic or need any hand coding using groovy or java script?

Regards,

Ganesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 14, 2017 at 07:13 AM

    Hello Ganesh,

    You can use the Splitter to generate 1000 rows per file ,by unchecking Parallel Multicast you can guarantee splitted messages are sent one by one in the order it was split.

    Since File or SFTP channel at receiver side is asynchronous in nature,you will not be able to decide whether all the orders sent in a batch is successfully processed or not.From my understanding perspective #1 can be achieved but #2 is not possible with SFTP adapter.

    Regards,

    Sriprasad Shivaram Bhat

    Add comment
    10|10000 characters needed characters exceeded