[resolved] Talend to Tableau Data Extract

One Star

[resolved] Talend to Tableau Data Extract

Hi, I need help regarding a new component/palette creation,
I already made the palette for Tableau BI, but after running it, it gave me a connection or link error.
What may have cause the problem? And what should I do?
Please see the below image for your reference of the error occurred.

Thanks in advance! Smiley Happy

Lester

Accepted Solutions
One Star

Re: [resolved] Talend to Tableau Data Extract

I just uploaded the updated version that works with Tableau 10.x SDK to TalendForge and github: https://github.com/tfoldi/talend-tableau-extract

All Replies
Moderator

Re: [resolved] Talend to Tableau Data Extract

Hi,
Here is a reference about Installing a custom component. Did you install the custom component as the article said?
In addition, the custom component tTableauExtractOutput is developed by community user. I think you'd better contact with the component author tfoldi.

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] Talend to Tableau Data Extract

The problem is that Talend cannot access Tableau's native libraries. You can download it from Tableausoftware.com.
Extract the contents of the tableau extract API libraries \bin directory into Talend's root folder C:\TOS\TOS_DI-Win32-r99271-V5.2.2\ (so put dataextract.dll, tdeserver.exe etc. in the same directory where your TOS_DI-win-x86_64.exe is located).
Then copy Java\dataextract.jar Java\jna.jar files into C:\TOS\TOS_DI-Win32-r99271-V5.2.2\lib\java AND C:\TOS\TOS_DI-Win32-r99271-V5.2.2\plugins\org.talend.designer.components.localprovider_5.2.2.r99271\components\tTableauExtractOutput. That's the safest thing.
Please make sure that you run the same architecture for both TDE and Talend, like both are 32bit or both are 64bit.
Let me know if it works for you. If not, I can help you with some screen sharing, it would not take than 2-3 mins
One Star

Re: [resolved] Talend to Tableau Data Extract

Okay. will be doing what you said Smiley Happy be there after 10 mins ! Thanks a lot guys! Smiley Happy
One Star

Re: [resolved] Talend to Tableau Data Extract

HI,
I already did what you said, but running the talend gives me an error looking for 'log4j-1.2.15.jar'
then I downloaded 'log4j-1.2.15.jar' but where do i put it?
Thanks! Smiley Happy
One Star

Re: [resolved] Talend to Tableau Data Extract

Hmm, this is something new, for me it does not required that jar file. Put in the same directories where you copied dataextract.jar
One Star

Re: [resolved] Talend to Tableau Data Extract

Okay now, I resolved the 'log4j-1.2.15.jar' issue..
Now, the error is 'com.talend cannot be resolved to a type'
what can be the cause? Smiley Sad
thanks,
Lester
One Star

Re: [resolved] Talend to Tableau Data Extract

Could you send the whole log output + the version of your Talend + version of your Tableau libs?
One Star

Re: [resolved] Talend to Tableau Data Extract

sure! Smiley Happy will be sending you a screenshot in a while!
One Star

Re: [resolved] Talend to Tableau Data Extract

Hi,
my current version for talend is all 5.2.2.r99271,
I edited my 1st post for the next image. Please see the 2nd image for your reference. Smiley Happy
One Star

Re: [resolved] Talend to Tableau Data Extract

Strange, I will have a look on this. Can you send also the generated java code from the job?
One Star

Re: [resolved] Talend to Tableau Data Extract

Sent you an email Smiley Happy
One Star

Re: [resolved] Talend to Tableau Data Extract

Topic resolved. Thanks guys! Smiley Very Happy
One Star

Re: [resolved] Talend to Tableau Data Extract

Hi everybody.
May I ask you, tFoldi:
I have developed a Job using tTableauExtractOutput and I want to export this job in order to run it on a device where Talend is not installed.
However, I think it does not work because the Job requires the Tableau Extract API.
So my question is, to which location should I paste which files of the TDE-API on a device without a Talend installation in order to execute a job developed in Talend that consists the tTableauExtractOutput component.
Thanks in advance for your support.
Best, Sikario
One Star

Re: [resolved] Talend to Tableau Data Extract

Hi, Guys help... i need a help regarding of executing the filedelimited to ttableauextractoutput.
this is the output.
--Exception in component tTableauExtractOutput_1
com.tableausoftware.TableauException: duplicate table name
at com.tableausoftware.DataExtract.Extract.addTable(Unknown Source)
at sampler.nope_0_1.nope.tFileInputDelimited_1Process(nope.java:1229)
at sampler.nope_0_1.nope.runJobInTOS(nope.java:2132)
at sampler.nope_0_1.nope.main(nope.java:1984)
disconnected
disconnected
Thanks,

Re: [resolved] Talend to Tableau Data Extract

Strange, I will have a look on this. Can you send also the generated java code from the job?

There is one more error.
connecting to socket on port 3965
connected
Exception in thread "main" java.lang.UnsatisfiedLinkError: Unable to load library 'DataExtract': The specified module could not be found.

    at com.sun.jna.NativeLibrary.loadLibrary(NativeLibrary.java:194)
    at com.sun.jna.NativeLibrary.getInstance(NativeLibrary.java:283)
    at com.sun.jna.NativeLibrary.getInstance(NativeLibrary.java:244)
    at com.sun.jna.Native.register(Native.java:1065)
    at com.tableausoftware.DataExtract.Extract.<clinit>(Unknown Source)
    at scp_logfile.readlogfile_0_1.readLogFile.tFileInputRegex_1Process(readLogFile.java:2298)
    at scp_logfile.readlogfile_0_1.readLogFile.runJobInTOS(readLogFile.java:4767)
    at scp_logfile.readlogfile_0_1.readLogFile.main(readLogFile.java:4626)
disconnected

For more details you can visit ""
One Star

Re: [resolved] Talend to Tableau Data Extract

Hi, Guys help... i need a help regarding of executing the filedelimited to ttableauextractoutput.
this is the output.
--Exception in component tTableauExtractOutput_1
com.tableausoftware.TableauException: duplicate table name
at com.tableausoftware.DataExtract.Extract.addTable(Unknown Source)
at sampler.nope_0_1.nope.tFileInputDelimited_1Process(nope.java:1229)
at sampler.nope_0_1.nope.runJobInTOS(nope.java:2132)
at sampler.nope_0_1.nope.main(nope.java:1984)
disconnected
disconnected


@Mike
Try to rename the output name of the extract. I had the same issue, when I ran the job 2 times, and it would generate the extract with the same name into the same library (it cant overwrite it).
One Star

Re: [resolved] Talend to Tableau Data Extract

Good morning
I am having the same problem that .
I ve followed the next steps:
- Extract the contents of the tableau extract API libraries \bin directory into Talend's root folder C:\TOS\TOS_DI-Win32-r99271-V5.2.2\ (so put dataextract.dll, tdeserver.exe etc. in the same directory where your TOS_DI-win-x86_64.exe is located).Done
Then copy Java\dataextract.jar Java\jna.jar files into C:\TOS\TOS_DI-Win32-r99271-V5.2.2\lib\java. In my case i dont find this directory and i copy them into C:\TOS\TOS_BD-20150702_1326-V6.0.0\WORKSPACE\.Java\lib
-And into C:\TOS\TOS_DI-Win32-r99271-V5.2.2\plugins\org.talend.designer.components.localprovider_5.2.2.r99271\components\tTableauExtractOutput. I do not find this directory so I copy them in the file I created to put the component tTableauExtractOutput --> C\component_Talend\tTableauExtractOutput.
After running, the errors are the following:

Could you please help me with that?
Thanks
One Star

Re: [resolved] Talend to Tableau Data Extract

Sorry. The image is:
One Star

Re: [resolved] Talend to Tableau Data Extract

i want to load a tableau extract (.tde)  into a database ;is there any way to do it using talend??
One Star

Re: [resolved] Talend to Tableau Data Extract

i am trying a create a .tde from mssql server and i am getting this error msg. Help please
Exception in component tTableauExtractOutput_1
com.tableausoftware.TableauException: Invalid Extract handle
at com.tableausoftware.DataExtract.Extract.addTable(Unknown Source)
at bi.bi_test_0_1.BI_Test.tMSSqlInput_1Process(BI_Test.java:4951)
at bi.bi_test_0_1.BI_Test.runJobInTOS(BI_Test.java:10891)
at bi.bi_test_0_1.BI_Test.main(BI_Test.java:10748)
One Star

Re: [resolved] Talend to Tableau Data Extract

i want to load a tableau extract (.tde)  into a database ;is there any way to do it using talend??

you can use tabcmd on windows and linux as well (see tableau forum on how to use tabcmd on linux) to upload your tde file to the server.
tabcmd publish is your friend
One Star

Re: [resolved] Talend to Tableau Data Extract

Hi There,
I tried for several hours now getting this component running but it seems that the latest data extract api provided by Tableau is no more compatible.
If I use the Python package (64.bit) there is as dataextract.dll included but throws an error:
Exception in thread "main" java.lang.UnsatisfiedLinkError: Error looking up function 'TabExtractOpenTable':
If I use the Java SDK there is no more an dataextract.dll available at all.
Exception in thread "main" java.lang.UnsatisfiedLinkError: Unable to load library 'DataExtract'
Anybody faced this issue alerady as well and might get me some hint?
Thanks a lot in advance.
bg Manuel
One Star

Re: [resolved] Talend to Tableau Data Extract

It still works for me. Did you check your API installation itself? Does your JAVA example work without Talend? If yes, please make sure that java api jars are on the classpath while the dlls are in the path.
One Star

Re: [resolved] Talend to Tableau Data Extract

I had the same problem.  It seems they made a few changes when they moved the DataExtract API in with the Tableau SDK. DataExtract.jar is now called tableauextract.jar and the reference has changed to com.tableausoftware.extract.*  Also, the Type and Collation classes have been moved into tableaucommon.jar  
Once I made those updates in the component code, I was able to get it working.
One Star

Re: [resolved] Talend to Tableau Data Extract

Hi Guys,
         I came  across the problem highlighted below. Has anyone encountered something like this???  Also attached is the screenshot.
connecting to socket on port 3458
connected
Exception in component tTableauExtractOutput_1
com.tableausoftware.TableauException: table name must be "Extract"
at com.tableausoftware.DataExtract.Extract.<init>(Unknown Source)
at tvg.testtableauextract_0_1.TestTableauExtract.tFileInputDelimited_1Process(TestTableauExtract.java:639)
at tvg.testtableauextract_0_1.TestTableauExtract.runJobInTOS(TestTableauExtract.java:3755)
at tvg.testtableauextract_0_1.TestTableauExtract.main(TestTableauExtract.java:3569)
: tvg.testtableauextract_0_1.TestTableauExtract - tTableauExtractOutput_1 table name must be "Extract"
disconnected
One Star

Re: [resolved] Talend to Tableau Data Extract

I just uploaded the updated version that works with Tableau 10.x SDK to TalendForge and github: https://github.com/tfoldi/talend-tableau-extract
One Star

Re: [resolved] Talend to Tableau Data Extract

I just updated the component to work with Tableau 10.x and newer APIs. Code is here https://github.com/tfoldi/talend-tableau-extract and on talendforge 

Re: [resolved] Talend to Tableau Data Extract

Hi there,

I'm wondering if you created an update to this component to create hyper extracts using the Extract API 2.0.

I've been able to successfully create a .tde with your component, but now looking to go to the next step.

 

Thanks,

Stephanie