topic Re: Connect Alteryx to Download from Tableau Server Database in Alteryx Server Discussions

Connect Alteryx to Download from Tableau Server Database

stapuff — Tue, 03 Mar 2020 16:46:15 GMT

I am looking to retrieve a list of data sources, user information, workbooks, etc from Tableau. I am new to Tableau server so throwing the question out there.

Thanks,

Puff

Re: Connect Alteryx to Download from Tableau Server Database

AbhilashR — Tue, 03 Mar 2020 19:52:04 GMT

Hi @stapuff, take a look at the SQL's mentioned in the following Tableau community post, and use them in Alteryx's Input tool to fetch the data inside Alteryx for further analysis.

https://community.tableau.com/thread/238244

Please mark this post as solution accepted if it answers your query

Re: Connect Alteryx to Download from Tableau Server Database

stapuff — Tue, 03 Mar 2020 20:03:55 GMT

I appreciate the response back. I will take a look at it and let you know how I fair.

Thanks,

Puff

Re: Connect Alteryx to Download from Tableau Server Database

stapuff — Fri, 06 Mar 2020 09:38:35 GMT

I appreciate you posting that link. Extremely useful documents.

I did not use this suggestion though. Just ended up build a Rest API workflow to produce the results I was looking for.

Again Thank You for your post,

Puff

Re: Connect Alteryx to Download from Tableau Server Database

pablolarocca — Fri, 28 May 2021 19:25:24 GMT

Could you Share the Rest API, I have the same need

Re: Connect Alteryx to Download from Tableau Server Database

shalinipal23 — Thu, 26 Aug 2021 10:11:11 GMT

I have the same requirement. Could you please share the workflow.

Re: Connect Alteryx to Download from Tableau Server Database

stapuff — Mon, 30 Aug 2021 21:15:42 GMT

@shalinipal23

Sorry... just seeing this. Do you still need the example?

Puff

Re: Connect Alteryx to Download from Tableau Server Database

bakedsalmon333 — Thu, 02 Sep 2021 12:06:48 GMT

Hi I also need the workflow do you mind sharing? Here's mine but I got some 404 errors.

Re: Connect Alteryx to Download from Tableau Server Database

stapuff — Thu, 02 Sep 2021 14:02:36 GMT

@bakedsalmon333 @shalinipal23 @pablolarocca

I am going to describe what works for me.

1) I created a user in Tableau and gave the user Admin rights.

2) I took the url of our Tableau site, username and password created in step 1 and placed it into the input tool marked with red line.

3) I then placed the url of our Tableau site and placed it in the formula tool marked with red line.

*Note - the formula tool marked with red line is where you can change what api is getting call/returned. Look at the tail end of the url getting called. I have mine hardcoded to /users?pageSize=1000 ,but this can be dynamic

Re: Connect Alteryx to Download from Tableau Server Database

shalinipal23 — Thu, 30 Sep 2021 16:52:46 GMT

Thanks for the workflow. Apologies, for not replying any sooner.

One more query is this possible without the admin rights?

Re: Connect Alteryx to Download from Tableau Server Database

JakobJ — Tue, 15 Nov 2022 16:43:53 GMT

Yes, I would be interested in an example thank you!