Reading PDF document

das_nirmalya · Post by **das_nirmalya** » Wed Jun 03, 2015 12:05 am

We have a requirement to read the pdf which is embedded in XML document.
We need to parse the XML document to read the PDF content using Datastage 9.1.

Please let me know the wayout.

chulett · Post by **chulett** » Wed Jun 03, 2015 10:12 am

Okay... while you should be able to parse the XML using DataStage and perhaps even retrieve the pdf document in some fashion, we'd need more details to provide cogent help. How is it stored in the XML? And what specifically do you mean by "read the PDF content" in an ETL context?

ozgurgul · Post by **ozgurgul** » Thu Jun 25, 2015 9:36 am

Hi - After pulling out PDF document from XML, then you may to convert the file to text using one of PDF2TEXT and then read the text and filter the content as you like.

Hope this will help you out in high level.

Regards,
Ozgur

ozgurgul · Post by **ozgurgul** » Thu Jun 25, 2015 9:50 am

Alternatively,

Re: Extract an embedded pdf file from xml

1) load the xml files into db
2) extract the clob data from xml and store them in a clob
3) convert the clob data from base64 to binary and store result in blob
4) write the blob data to o/s file using UTL_FILE writing in raw mode
5) use java,phyton,pdf2txt etc to convert the pdf file to text and filter what you're seeking

https://community.oracle.com/thread/1114383

Regards,
Ozgur

ray.wurlod · Post by **ray.wurlod** » Thu Jun 25, 2015 4:02 pm

Why must you do this "using DataStage"?