JDBC to File Sender: Create Multiple Files

[Former Member]

Hi All,

I have a requirement that I have to pick data form a SQL table and then based on the data in it I have to create multiple files using File receiver. Even the file name has to be derived from the data in the SQL table.

e.g. The SELECT statement is fetchin 30 record and I have to make 3 files out iof it. Please suggest.

regards,

Piyush

[Former Member]

If the result 3 files are different in nature of structure - it is possible by multi mapping.

If you need to destriburte the same data in 3 files then youneed to use BPM.

[Former Member]

I was able to do it using

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90dcc6f4-0829-2d10-b0b2-c892473f1...

But Dynamic config doesnt wrk in Multi mapping..

[Former Member]

Hi,

You can achieve without BPM, By using Enhance Interface Determination i,e Multimapping without BPM.

In additon you would required ASMA and dynamic configuration for this scenario.

Regards,

Abid

[rajasekhar_reddy14]

very simple use multi mapping without BPM,it can be achieved very easily.

CHECK OUT THIS BLOG

/people/jin.shin/blog/2006/02/07/multi-mapping-without-bpm--yes-it146s-possible

Regards,

Raj

[Shabarish_Nair]

use multi mapping

avoid BPM - /people/jin.shin/blog/2006/02/07/multi-mapping-without-bpm--yes-it146s-possible