Attachments through PI

[Former Member]

Hi Experts,

i have few questions on the transfer of attachments from PI.

1. can we transfer the Photos, word file or video files as attachments through XI ?

2. what is the size limit of the attachments that PI can handle ?

3. will there be any performance issue if the file size crosses more than 5 MB ?

4. can we able to fetch the attachments using the DB look-up's from Oracle DB ?

Regards,

Devi. D

[prateek]

1. Yes. Simple use of file adapter could do this without using any IR objects. But this depends upon the type of adapter you want to use.

2. SAP tested size is 1 GB and you technical limit is 2 GB. But hardware sizing and system configurations are important factors here.

3. Yes. The ideal size would be 5 MB. Larger size will certainly adversely affect the performance.

4. No.

Regards,

Prateek

[former_member200962]

If your requirement is just to pick a file from source directory and dump it into target directory (no processing) then you can transfer any file through XI/PI....it can be achieved by avoiding the use of Repository....method shown here:

/people/william.li/blog/2006/09/08/how-to-send-any-data-even-binary-through-xi-without-using-the-integration-repository

If you need to do some processing on the image (convert it to XML) then refer links mentioned here:

The file size of 5MB should not cause any issue while transferring (expecting that when this file is transferred then at that particular time other large volume transfers are not happening).

Regards,

Abhishek.

[rajasekhar_reddy14]

1. can we transfer the Photos, word file or video files as attachments through XI ?

Using Java apping we can transfer Image files,If you wnat to send as a atatchment,better to write module to handle this.

2. what is the size limit of the attachments that PI can handle ?

There is no size limitation i guess for an atatchment,

3. will there be any performance issue if the file size crosses more than 5 MB ?

5MB File there will be no performance issues,Performance issue its fully depend on Your server configuration.its not a right idea to transfer 5MB files..

4. can we able to fetch the attachments using the DB look-up's from Oracle DB ?

Beter to write one Java Map,use conection pooling mehcniasm to connect to Data Base,

Using java map we can retrive Clob DATA,so iguess we can retrieve the same using queries.

Regards,

Raj

[former_member187339]

Hi,

>>1. can we transfer the Photos, word file or video files as attachments through XI ?

yes, I did it once using method in this blog /people/suraj.sr/blog/2009/07/21/zip-multiple-files

>>2. what is the size limit of the attachments that PI can handle ? 3. will there be any performance issue if the file size crosses more than 5 MB ?

The attachment size depends on lot of factors like, hardware size, message frequency etc. So I canot say that this is the max size for messages but 5MB looks ok.

>>4. can we able to fetch the attachments using the DB look-up's from Oracle DB ?

Never tried this. But i guess it is not possible because they may be stored in binary formats in SAP PI

Regards

Suraj