Connecting to the Tableau Repository Database

[AmandaMS]

I would like some help with creating a connection in Alteryx so that I can extract data from the Tableau repository database to process in an Alteryx workflow.

We are using Tableau 10.1.2. I notice that the Postgres repository version has been upgraded since the last version of Tableau that we had. It is now PostgreSQl 9.5.3.

I'm able to create an ODBC connection on my desktop and connect successfully to the Tableau repository using the standard readonly account. However in Alteryx I'm not able to see the tables and views that this account has access to. Are there database permissions that need to be granted on the database to enable Alteryx to "see" the tables and views?

I'm hoping that someone out there is already doing this successfully.

[AmandaMS · Accepted solution]

My colleague has found a solution to our problem.

The resolution was that we have to tick the ‘Use Declare/Fetch’ box on Page 1 of Datasource options in ODBC manager. This makes the tables and views visible in Alteryx.