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

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

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

Download