4 Replies Latest reply on May 21, 2005 1:27 AM by 209104

    FTP adapter and multiple messages from the same file?

    440714

      Hi,

      Looking to use the FTP adapter to receive a flat file, and to initiate messages for each line in the file, which end up being passed to a DB adapter to create various objects in the DB.

      Couple of questions:

      1. using D3L, is the file treated as a single entity? ie. an array of messages, which must be dealt with in the hub, and in the db adapter, as an array?

      2. also using D3L, can a single file result in mutiple differing messages, where the type is based upon some token on each line?

      Anyone done similar?

      Thanks.
        • 1. Re: FTP adapter and multiple messages from the same file?
          416900
          Is what you are really asking "Can the IC, using just an FTP Adapter and a DB Adapter, chop up one message into lots of messages?" - then I think the straight forward answer is no.

          A message is one message. The only time (out-of-the-box) the single message can become more than one resulting message is to use Content Based Routing. For this you will need multiple target DB adapters.

          An alternative is to pass the message to workflow, and perform the intelligent further message(s) generation from there.

          HTH,
          Yan
          • 2. Re: FTP adapter and multiple messages from the same file?
            209104
            Hi,

            I am no expert but I can concur with previous response and confirm from experience of managing an integration project that the standard out-of-the-box FTP/File adapter only supports the idea of "one file - one message". To extract and process multiple records/messages from a single file it was necessary for us to develop a custom bridge to perform the necessary pre-processing.
            • 3. Re: FTP adapter and multiple messages from the same file?
              375819
              To extract and process multiple
              records/messages from a single file it was necessary
              for us to develop a custom bridge to perform the
              necessary pre-processing.
              Don't suppose you can provide some additional details/code for this "custom bridge"? Was it an external process or hosted inside Oracle?
              • 4. Re: FTP adapter and multiple messages from the same file?
                209104
                It was a combination of XML configuration files defining the structure of the file and messages within the file and internal java code extensions to the Reader within the Bridge to pick up the file and process/publish each message/line in turn. Sorry - not in position to provide code or further technical detail.