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,
Could you please refer below link which is using custom code to process a PDF file.
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.
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!
Below link can help you to understand how to create a Talend user routine to perform custom java codes in repeatable fashion.
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?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how and why companies are moving to the Cloud
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.