JDBC to File Scenario

[raviteja_satuluri]

Dear Experts,

Scenario : JDBC to File

Requirement : PI fetches the data from Database and will send to multiple systems.

Problem : There are more than 60K Records in Database which size is around 100MB. When PI Pulls every thing at a time it will cause Memory Issue. On Receiver end Multiple systems will accept Only one file at a time, They Can not accept multiple files at a time.

Here the Problem is, How to append in to One Single file with Header details and send to Multiple Systems.

Kindly provide the Best Approach.

Thanks in Advance

[former_member190293]

Hi, R S!

You could use database syntax to fetch first n records when polling data. And create ccBPM process with message collect pattern.

Regards, Evgeniy.

[Pranil1]

you can try to add condition to fetch the data separatelyfor each system