Skip to Content
author's profile photo Former Member
Former Member

Attachments through PI

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Oct 03, 2009 at 07:44 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 03, 2009 at 07:51 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 03, 2009 at 08:10 AM

    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:

    transfer-of-image-file-using-xi

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 03, 2009 at 07:43 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.