8 Replies Latest reply on Oct 28, 2015 12:53 PM by Raj Garimilla

Saving DB Connection as Configuration File in Tableau

Raj Garimilla Oct 5, 2015 11:50 AM

Hello all,

We have live db connections in our Tableau Server. For disaster recovery, we have copy of database.

How do we switch the database connections in each work book to point to new database if the main database goes down?

It works if we changes the database connections in Desktop and republish the work books. But this is not possible when we have 100 workbooks.

Is there a way to save the db connection properties in a config file in Tableau ? Did any one had issue ?

Thanks,

Raj

1. Re: Saving DB Connection as Configuration File in Tableau

Jeff Strauss Oct 27, 2015 2:11 PM (in response to Raj Garimilla)

database connections can be updated in bulk via the server interface. The attached screenshot is from our server 9.0.5 deployment. Click on data sources, then select the database type you want (i.e. GP). Then select all sources (via select all). Then edit connection which brings up a dialog.
Like Show 0 Likes(0)

Actions
2. Re: Saving DB Connection as Configuration File in Tableau

Raj Garimilla Oct 28, 2015 11:11 AM (in response to Jeff Strauss)

Thanks Jeff.
Every time I want to publish a workbook from Dev to Production, I have to change the Server name and database details. And each department has their own site within the production tableau server.
If I have 10 sites, I have to publish 10 times from desktop for each site seperately. And the problem multiplies for more number of workbooks. This is taking a lot of time and causes confusion.
I tried to do this using tabcmd , but it is not respecting the userthumb nail option.
Is there an easy way to do this ?

Thanks,
Raj
Like Show 0 Likes(0)

Actions
3. Re: Saving DB Connection as Configuration File in Tableau

Jeff Strauss Oct 28, 2015 11:39 AM (in response to Raj Garimilla)

I haven't had to deal with the user thumbnail option, but may I ask why each department has their own site? I am not a big fan of sites from an overhead administration perspective, and much rather prefer using the project deliminator to split content by permissions.
Like Show 0 Likes(0)

Actions
4. Re: Saving DB Connection as Configuration File in Tableau

Raj Garimilla Oct 28, 2015 11:48 AM (in response to Jeff Strauss)

We have implemented multi tenancy using sites for mutiple clients. Users have the option of developing their own dashboards and saving in their respective sites. We see problem when we develop content that is common for all clients and publishing them to all sites.
Like Show 0 Likes(0)

Actions
5. Re: Saving DB Connection as Configuration File in Tableau

Jeff Strauss Oct 28, 2015 12:00 PM (in response to Raj Garimilla)

yeah, it's going to continue to be a persistent maintenance nightmare if you have the need to deploy a common dashboard to all sites. Are your clients all internal (e.g. separate departments)? If so, may I suggest allowing the analysts to publish to projects that they have permissions for and then common dashboard can be published once to the "all users" group.

My 2 cents. The only benefit to sites that I can see is clear deliniation by way of storage quotas and development of usage metrics.
Like Show 0 Likes(0)

Actions
6. Re: Saving DB Connection as Configuration File in Tableau

Raj Garimilla Oct 28, 2015 12:06 PM (in response to Jeff Strauss)

They all are external companies.
Like Show 0 Likes(0)

Actions
7. Re: Saving DB Connection as Configuration File in Tableau

Jeff Strauss Oct 28, 2015 12:49 PM (in response to Raj Garimilla)

you may want to check out Interworks EDT to see if this helps. https://powertoolsfortableau.com/tools/edt/
Like Show 0 Likes(0)

Actions
8. Re: Saving DB Connection as Configuration File in Tableau

Raj Garimilla Oct 28, 2015 12:53 PM (in response to Jeff Strauss)

Thanks Jeff. will reach out to them.
Like Show 0 Likes(0)

Actions