One possible way of handling this is to install Tableau Desktop on the Tableau Server remote machine. Then make a connection and publish. Is this feasible?
Using Jeff's method, an admin can publish the data source separately on the server. We always install Tableau Desktop on our servers.
Afterwards developers should be able to use Tableau Desktop from any computer to connect with the published datasource or use WebEdit to create a workbook.
Thanks for your suggestion. Unfortunately installing Desktop on the same server as Tableau Server wouldn't be possible for us, because we're using Tableau Server on Linux and Tableau Desktop isn't available for Linux.
Our current idea is to set up a VPN for the three involved machines. I guess it's not ideal but it works for our specific case. Hope that in the future Tableau doesn't require a DB connection on the client side or that ODBC will become available through WebEdit.
There are two ways.
First way, we use tools like VPN which is the most common one.
Another way is to install desktop in server and we control server.
Bit of a long shot, but do you have a test database available to Desktop clients with the exact same schema/table/columns? If not....the below probably won't work.
But one hacky way to do this is to take advantage of is the fact that Tableau Desktop does not attempt to connect to the database, when publishing extracts and deselecting the option to enable refreshes.
So if you have a test instance which your Desktop client does have access to, you can make a dummy ODBC connection via Desktop to that, create an extract, save the workbook, and then search/replace the XML in the workbook to point to the correct database.
Once you re-open the workbook, it should now be pointing to the DB you want and you can publish it up to Server (make sure to select No when Desktop asks if you want to embed credentials). Then it's just a matter of updating the datasource credentials via the Portal to enable refreshes.
Having said all that....VPN is definitely the way to go if that's an option.
We're on a trial now, we started trialing about a week ago, so I guess it
would be one of the new subscription based models?
I don't see an option for ODBC connections on WebEdit.
On Thu, Aug 23, 2018, 15:56 Jeff Strauss <email@example.com>