topic How to read pdf file in talend? in Data Quality

How to read pdf file in talend?

Anonymous — Sat, 16 Nov 2024 07:45:47 GMT

Hi all,

I saw the other topic posted. Unfortunately the solution does not fit my needs. I have a pdf file that contains information regarding payslips of employees, so each page a different employee.

Is there a way I could extract info from each page to export a database with all the employees? What I could do so far is to import the pdf file and get 1 huge line of characters from the file. And there's not much I can do with it.

There is an example pdf file attached, having 2 employees' info (2 pages).

Thank you very much,

Anca

Re: How to read pdf file in talend?

Anonymous — Wed, 29 Aug 2018 20:29:23 GMT

Hi,

Could you please refer below link which is using custom code to process a PDF file.

https://community.talend.com/t5/Design-and-Development/How-to-read-pdf-file-in-talend/m-p/99998

The recommendation will be not to use the PDF file for processing important data like payslips as the data will not be in a format directly expected by target database. It will be a good idea to go to the corresponding source system and create a new data flow from that source to your new target database.

If the data is provided by third party, then you will have to create an agreed interface in the form of a file or web request payload to send the data so that it can be processed by Talend easily.

Warm Regards,

Nikhil Thampi

Re: How to read pdf file in talend?

Anonymous — Fri, 31 Aug 2018 09:15:06 GMT

Thanks for this thread. I also had this same question. Thanks for the cutom way around. Helped a lot.

Re: How to read pdf file in talend?

Anonymous — Thu, 06 Dec 2018 10:07:07 GMT

Hi Nikhil,

I found a way to read the PDF and export it in txt using Talend. Now I process the txt file in Java(eclipse) and right now I am struggling to implement the script in Talend.

I have two java classes written, one with the getters/setters and the main one that reads the pdf and exports it in Excel.

Do you know what components and how should I set them up in Talend?

Thank you for your support!

Anca

Re: How to read pdf file in talend?

Anonymous — Fri, 07 Dec 2018 06:53:50 GMT

@ancamaracu,

Below link can help you to understand how to create a Talend user routine to perform custom java codes in repeatable fashion.

https://help.talend.com/reader/BnnM0hh3643D9Vq15udPtA/ptUkG0B_wbN2IR4iYnXJ3g

Hope this has helped you to resolve the query. Could you please post the method you have employed to convert the PDF file so that it will benefit other Talend community members?

Warm Regards,

Nikhil Thampi