Question Re: How to post image's from FileServer to SQL Database. in Technology Q&A

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

Former Member — Fri, 20 Jul 2012 15:09:28 GMT

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.

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

baskar_gopalakrishnan2 — Fri, 20 Jul 2012 15:19:47 GMT

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.

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

Former Member — Fri, 20 Jul 2012 18:17:11 GMT

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

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

baskar_gopalakrishnan2 — Fri, 20 Jul 2012 18:42:13 GMT

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.

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

former_member181985 — Fri, 20 Jul 2012 19:26:29 GMT

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-pdfs-etc-in-the-database-blobs-using-jdbc-adapter