This content has been marked as final. Show 4 replies
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.
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.
To extract and process multipleDon't suppose you can provide some additional details/code for this "custom bridge"? Was it an external process or hosted inside Oracle?
records/messages from a single file it was necessary
for us to develop a custom bridge to perform the
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.