topic Re: Publish to Tableau Server - Improvement/Optimization in Alteryx Designer Desktop Discussions

Publish to Tableau Server - Improvement/Optimization

AJ_Fournier — Tue, 08 Mar 2022 23:25:14 GMT

Hi Alteryx Community!

I'm looking for some ideas or recommendations on methods to potentially improve or optimize my use of the Publish to Tableau Server tool.

The problem I'm running into is that I have a couple of large datasets that I have to published on a regular basis to multiple Tableau servers/sites. Best I can tell, and how I've been using it so far, is that each one of these publishes requires its own instance of the tool. Now each tool as part of it's publish process writes the dataset to its own temp file, so I'm writing an exact copy of the same 1.5-2gb temp file for every iteration of the tool. Writing all of the temp files bogs down a process that could probably run considerably faster if it was just focused on the actual publishing.

Ideally I'm trying to find a way to streamline the process a bit by being able to use the same temp file for multiple publishes rather than re-writing it for each one. This could be accomplished either by using the same tool to publish to multiple servers/sites at once, or by setting multiple publish tools to point to an already existing temp file rather than writing its own each run.

I'm fairly competent and experienced with regular workflow tools and methodologies but am not very familiar with some of the tool building/user interface components. I've taken a look behind the scenes at the Publish tool and feel like I understand most of what's going on, but some pieces are still a little abstract to me.

Would any of you folks out there have any ideas for how I might go about accomplishing this, or be able to point me in a direction where I might find some more info to help me figure out how to tackle it on my own?

Thank you!

Re: Publish to Tableau Server - Improvement/Optimization

Aguisande — Fri, 25 Mar 2022 01:51:10 GMT

Hi @AJ_Fournier

Have you tried saving the dataset into a local .yxdb file, and then, from a new WF use the Tableau Output Tool?

I tried this, and it's faster than the Publish to Tableau Server Tool.

Re: Publish to Tableau Server - Improvement/Optimization

priyaarisetti — Wed, 30 Nov 2022 17:05:54 GMT

I see only publish to Tableau server tool. May i know what is this Tableau Output Tool.

Re: Publish to Tableau Server - Improvement/Optimization

Aguisande — Wed, 30 Nov 2022 17:17:28 GMT

@priyaarisetti

You can found it here: https://community.alteryx.com/t5/Community-Gallery/Tableau-Output-Tool/ta-p/877902

Re: Publish to Tableau Server - Improvement/Optimization

priyaarisetti — Wed, 30 Nov 2022 19:22:20 GMT

Thank You. I am testing it now.

I would like to append 5 yxdb file to the Published tableau Datasource. I am able to achieve this with "Publish to Tableau Server" Tool. But not able append Parallelly. how can achieve this? Any thoughts please.

Re: Publish to Tableau Server - Improvement/Optimization

Aguisande — Wed, 30 Nov 2022 19:51:33 GMT

Not really sure, but most likely you can't.

Just out of curiosity, why don't you Union the 5 files and make just only one append?

Re: Publish to Tableau Server - Improvement/Optimization

priyaarisetti — Wed, 30 Nov 2022 22:07:39 GMT

single file is never success because its huge. Around 30 million data.

Re: Publish to Tableau Server - Improvement/Optimization

Aguisande — Wed, 30 Nov 2022 23:17:50 GMT

It shouldn't... Maybe there are some infraestructure issues that avoid that single file update succeed.

What kind of problems are you facing trying to update from a single file?

Re: Publish to Tableau Server - Improvement/Optimization

priyaarisetti — Thu, 01 Dec 2022 03:40:37 GMT

please find the screenshot. After some time it will throw an error of timeout.

Re: Publish to Tableau Server - Improvement/Optimization

priyaarisetti — Thu, 01 Dec 2022 13:43:01 GMT

Re: Publish to Tableau Server - Improvement/Optimization

Aguisande — Thu, 01 Dec 2022 14:52:42 GMT

I can see that you workflow is failing @exactly 2 hours from starting, what makes me suspect that your Tableau Server auth token is expiring.

I'd recommend seeing this case with your IT people, since what I see here is a Timeout error, and can be caused by numerous things.

Re: Publish to Tableau Server - Improvement/Optimization

priyaarisetti — Thu, 01 Dec 2022 14:59:03 GMT

I have changes configuration on tableau Server to 300 which is 5 hrs.

tsm configuration set -k wgserver.session.idle_limit -v 300