cancel
Showing results for 
Search instead for 
Did you mean: 

PDF File upload in SQL Server as it is.

Former Member
0 Kudos

Hi Expertts,

We have a bussiness requirement, where we have to pick up a PDF file from a file system and insert that file as it in the SQL Server table which has field as image.

Please tell me how it is possible to do.

with regards,

Ravi Siddam

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi Mickael,

Thanks for the nice reply. The solution what you suggested, is the same thing we have proposed to application team. But they want to upload the PDF file in database so that it will be available there for long time it seems and they are very perticular about the requirement.

I think there should be someway to handle this using XI, isn't it...like doing some JAVA mapping or module development. I am on the way to explore, please give me some hints.

with regards,

Ravi Siddam

Former Member
0 Kudos

Dear Chirag/Sampath,

I am aware of Conversion Agent by Itemfield, but the requirement is different here.

We want to upload the PDF file itself in SQL Server. It will be stored in database table which has got the field as image.

I don't want to make PDF to XML.....

The PDF file has to be shown to the users from the Database as the PDF file only using Front End(which is in .NET) is the end purpose of the application team.

Thanks and Regards,

Ravi Siddam

Former Member
0 Kudos

Hi Ravi,

According to me, in a table you can write only data... and NOT to write a physical PDF file in a Table.

But you can put this file somewhere in this Server or in another server...

Usually, here what we do (it's the case with document in ECC):

1. Put the file somewhere in the server. So you know the path and file.

For that, read blog 4383 as providen by SDNer.

2. Add this "path/file" name to your data which have to be put into the Table thanks to your mapping.

(just a link, not a physical file !)

3. As I'm sure your users do not have a direct access to the table of your Database... that means you have certainly a tool (like Entreprise Portal) to see the content of this table in a nice screen... So in this tool, when user want to see the file associated to his data, he click certainly a button and here you have to use an option like "open my PDF file", as you have exactly the path/file name.

That's all.... and I did not another solution than a link !

Mickael

Former Member
0 Kudos

Hi,

These links are not related to the subject as it is.

Any help please

Ravi

Former Member
0 Kudos

Hi Ravi,

yes it is possible with tool called Conversion agent

using this we can convert the .pdf file to xml from xml to SQl database

pls chk this link

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b0c63b84-19e5-2910-fc81-f4387165...

https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_all&query=conversion+agent&adv=false&sortby=c...

thanx

Sampath

Former Member
0 Kudos

Hi Ravi,

based on the information I have provided u the links.

This wat u have given as information:

I want the PDF file to be picked up and insert into Database table of SQL Server.

Wat I understood is u need to pick the PDF file and inster the PDF file data into SQL datasbase.

So for picking up the pdf file u need to write the java module and call that java module for PDF to XML conversion.

Can you tell me what exactly is ur scenario.

chirag.

Former Member
0 Kudos

Hi,

This dosen't solve purpose, it is just transfer of File from one place to another. I want the PDF file to be picked up and insert into Database table of SQL Server. The field is image field which will contain this PDF file.

regards,

Ravi Siddam

Former Member
0 Kudos

Hi,

Check out this may be this will help u.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/9913a954-0d01-0010-8391-8a3...

U need to write the java module in adapter which will read the PDF file.

chirag

Former Member
0 Kudos

Go through this.

How to send any data from XI, without using IR.