How to post image's from FileServer to SQL Database.

[Former Member]

Hi Experts,

    How to post Images from Fileserver to Database using File Adatper ar sender and Receiver adapter as JDBC. Can you please help me out how to pick the images from source file server to insert into Database.

Thanks

Kiran.

[baskar_gopalakrishnan2]

You can follow this design.  Create file to jdbc scenario.

A) Take help from DBA. Create a column in db table as type BLOB. This blob column can store the image as binary object.

B) Use UDF  in PI to read the image from file and pass it to blob column in mapping.

C) You can use insert jdbc statement structure in the target and reference the UDF output to the blob column.

This should help.

[Former Member]

Hi baskar,

  Thanks for the information. how file adapter reads the image from file server. Do i need to take care any extra setting in file adapter.

thanks

kiran

[baskar_gopalakrishnan2]

You have to write it using java mapping or simple UDF to do this. Are you getting this in payload xml structure? Search online java coding for reading the image data.

[former_member181985]

Read image in binary mode using File Adapter. XI interface can carry any message in general

Refer my blog for your requirement: http://scn.sap.com/community/pi-and-soa-middleware/blog/2010/03/28/sap-xipi-storing-binaries-images-...