How to read pdf file in talend?

Highlighted
Four Stars

How to read pdf file in talend?

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

Employee

Re: How to read pdf file in talend?

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


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)
Four Stars

Re: How to read pdf file in talend?

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

Four Stars

Re: How to read pdf file in talend?

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

Employee

Re: How to read pdf file in talend?

@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


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.