topic Re: Using TFileoutputPDF to extract data from SQL server Temp Table in Talend Studio

Using TFileoutputPDF to extract data from SQL server Temp Table

Anonymous — Mon, 01 Aug 2016 15:51:25 GMT

Hello,
I am trying to extract a Temp Table from SQL Server and convert into PDF format. I have tried three approaches:

I tried to simply connect TMSsqlinput component to the TFileoutputPDF component using a main link.
I tried using a tmap between the TMSsqlinput and the TFileoutputPDF in case column mapping was the issue.
I tried to write from TMSsqlinput -> tmap -> TFileoutputExcel (A Process which I have a tested and know works correctly) and then connect to PDF.
None of these processes work, and I get the same error everytime:
"arithmeticexception: / by 0"

I have not coded anything to divide by 0. I'm relatively new to Talend, so maybe I am missing something basic, but I can't seem to figure this out. Any Help would be greatly appreciated!
Thanks

Re: Using TFileoutputPDF to extract data from SQL server Temp Table

Anonymous — Tue, 02 Aug 2016 08:33:57 GMT

Hi,
Can you get the expected output result without using tFileoutputPDF component?
The tFileoutputPDF component is written by talend community user and shared on talend exchange portal.
Feel free to contact the author directly.
Best regards
Sabrina

Re: Using TFileoutputPDF to extract data from SQL server Temp Table

Anonymous — Tue, 02 Aug 2016 13:36:49 GMT

Well I can get it as an excel file output, if that's what you mean, but unless there is a built in Talend component that I haven't found which will allow for conversion to a PDF, then no, I can't get it in the correct format.
I will try to contact the author.
Thanks

Re: Using TFileoutputPDF to extract data from SQL server Temp Table

Anonymous — Wed, 03 Aug 2016 10:59:34 GMT

Hi,
So far, there is no specific component for PDF file in talend.
Best regards
Sabrina