2 Replies Latest reply on Jul 17, 2008 5:14 PM by 650658

    File Adapter: Multiple Records, Multiple Types to Multiple DB Tables

      Hi there,

      I have a proof-of-concept scenario which I am trying to model in ESB:

      I have a single flat file with one invoice header record and multiple invoice lines.
      I want to read this file via the File Adapter, and insert the different records into different database tables: the invoice header in an invoice table, and the invoice lines into a line item table.

      If I tackle the lines in isolation no problem (i.e. single file with only invoice lines in to the invoice lines table). Things break down when I add the invoice header into the mix.

      Does anyone have an example of this or something similar?
      Would I need to use seperate database adapters for the two tables, or is this achievable with a single database adapter?

      Thanks in advance!