I have 70 workbooks where all the worksheets are connected to oracle data source. My team is going to migrate the exact same data on Amazon RDS. So now I want to repoint all the Tableau worksheets to the mysql. Is this possible without recreating anything? If so, is there a way to do it for all the worksheets as opposed to just one at a time? I tried with all the methods mentioned on Jawon Apr 30, 2009 3:16 PM posts:- Repointing existing workbook to a new datasource , but nothing worked for me. Is there any way where I can find the mapping of oracle connection for example:- name='oracle.41528.731775173612' in the .twb file to tables and schemas?
1 Answers
1
votes
It's not easy or pretty but it can be done. It involves hacking the XML of the twb file. These steps give you a general idea and there are ways to streamline the process. Before starting this process, I strongly encourage you to make a backup copy of your twb files. If this goes wrong and you don't have a backup, there's no recovery.
- Make a copy of your twb file.
- Open the copy. Create a new data source pointing to the new location. Build out that data source. Save your workbook.
- Run a diff between the original and new twb files. Look for the connection information that is different.
- Using a text editor or other program that can make changes to multiple text files, do a search and replace. I use Notepad++ for this. There are plenty of options out there.
Essentially what you are doing is finding what changed in the connection info when you modified the first file. Then you apply that change to all the other files.
Things get complicated if you have schema name changes or any other types of changes to table name or columns. For that reason, it may be advisable to change the files one at a time, opening each one in Tableau to correct any problems as you find them.
