I have to design a SAP PI integration workflow SFTP to JDBC.
I receive a transaction with a header record and detail record (e.g. invoice). This transaction must be inserted into a database with a header and a detail table where the detail records refer to a technical header keyId.
I think this is a typical use case so that i can image that there is a simple solution for my probem.
Can somebody help me ?