Splitting of tabel Records into multiple files in CPI DS

[former_member620704]

There is an requirement in CPI DS.

CPI DS will extract data from HANA DB.let us say 10k records (for ex.). It should generate multiple files and each file should have max 1k records.

Receiver is SFTP Server.

Could you please let me know how can we achieve this in CPI DS.

[pkolepara]

Hi Ram,

Did the save_data/get_data function worked for you in CPI DS as mentioned in the blog.

We are getting syntax error when using the post load/pre load script as-is in our task.

Regards,

Prasad K

[former_member620704]

Thanks Pravi Nellikkal,

This Blog helped me.

Regards,

Ram.

[former_member592043]

Please refer the below thread

https://blogs.sap.com/2019/10/17/automate-sap-hana-to-file-splitting-passing-variables-between-diffe...