[resolved] Talend to Tableau Data Extract

[Anonymous]

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!

Lester

[Anonymous]

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)

[Anonymous]

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

[_AnonymousUser]

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

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

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 

[stephanie_scott]

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

[Anonymous]

Hi, is there any update on creating a .hyper output format for tableau?