Replacing Data Source from one Server to Another

0 votes

We are deploying Tableau for a bank.
We had created 6 test dashboards using dummy data on a staging data base using sql connection and lets say has an ip 10.10.10.10.

Now we need to use the same view we had used with the dummy data on Live data but using a different connection which is again an sql engine & IP lets say as 20.20.20.20. All the variable names and other properties are the same, not difference is that the Live data would not have calculated fields which we can deploy on the Live environment.

The challenge is: the LIVE data being of a bank is highly confidential and cannot be used from outside operations site rather we need to deploy it from an ODC [restricted environment]. Hence we simply cannot do a replace data source.
Hence we are planning to move twbx files and data extracts for each of these views using a shared folder to the ODC. 
Then the process would be like below:

  1. As the LIVE sql data base is different from the dummy sql we will get error
  2. We will select edit data connection
  3. Will select tableau data extract for each sheet and dashboard
  4. Will then select the option of replace data source and select LIVE SQL database
  5. Will extract the new data
  6. The visualization should work fine

Earlier we had just moved TWBX files hence it failed. Is there a different approach to it? Thanks in advance.

Sep 19, 2018 in Tableau by Nitish
• 630 points
44 views

1 answer to this question.

0 votes

I did something similar to it For that, you must have

  1. same schema as of Live database and dummy database

  2. do not change name of any source table or column

  3. create your viz

  4. send it in the .tbw form which is editable HTML format

  5. Now the hard part- open your tbw in notepad and replace all connection details to new one

  6. save and open in the tableau

There is also a Python library called the Tableau Document API that you can use for step 5. Posted on Tableau’s github.com site
Hope this works!

answered Sep 19, 2018 by Naruto
• 710 points

Related Questions In Tableau

0 votes
1 answer

How to get past N months date from data source?

Hi, this is a one solution to your ...READ MORE

answered Mar 1 in Tableau by Cherukuri
• 31,840 points
72 views
0 votes
1 answer

Create global filter from single/multiple data source to multiple data sources on dashboard.

Hi Sindhu, You can use filters from worksheets in ...READ MORE

answered Mar 11 in Tableau by Cherukuri
• 31,840 points
76 views
0 votes
1 answer

Go from one sheet to another on any selection on chart.

Hi Nithin, Follow these steps to make the ...READ MORE

answered Mar 29 in Tableau by Cherukuri
• 31,840 points
23 views
0 votes
1 answer

How to divide one measure by another?

Yes it is possible, Option 1: Create a calculated ...READ MORE

answered Apr 10, 2018 in Tableau by Atul
• 5,530 points
31 views
+2 votes
1 answer
0 votes
1 answer

Tableau Desktop- Tableau Server

No, you don't necessarily need to purchase ...READ MORE

answered Apr 3, 2018 in Tableau by QueenBee
• 1,810 points
59 views
0 votes
1 answer

Tableau Desktop or Tableau server?

A clear introduction to what both of ...READ MORE

answered Apr 6, 2018 in Tableau by QueenBee
• 1,810 points
87 views
0 votes
1 answer

How to get Tableau results in python?

Well even I was looking for the ...READ MORE

answered Apr 9, 2018 in Tableau by Atul
• 5,530 points
81 views
0 votes
1 answer

How to refresh the extracted data source automatically in Tableau Desktop?

Hi AwesomeSauce, This comes up every so often!  Tableau ...READ MORE

answered Aug 13, 2018 in Tableau by Naruto
• 710 points
1,328 views
0 votes
1 answer