You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-08-01 15:51:25

brichey16
Member
2 posts

brichey16 said:

Using TFileoutputPDF to extract data from SQL server Temp Table

Tags: [mssql]

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

  1. I tried to simply connect TMSsqlinput component to the TFileoutputPDF component using a main link.

  2. I tried using a tmap between the TMSsqlinput and the TFileoutputPDF in case column mapping was the issue.

  3. 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

Offline

#2 2016-08-02 08:33:57

xdshi
Talend Team


xdshi said:

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

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


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2016-08-02 13:36:49

brichey16
Member
2 posts

brichey16 said:

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

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

Offline

#4 2016-08-03 10:59:34

xdshi
Talend Team


xdshi said:

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

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


What we can do is to make sure that Talend will be your best choice!

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy