Hi
I have a development and production environment that are separate each with their own Oracle database. My Tableau server will be installed in the production network. I want to publish a workbook which reads live data from the Oracle database to convert them into graphs.
I read that it is possible to publish a dashboard to the server offline through tabcmd. However, when I create a workbook that connects to the development Oracle database and publish it to the server, it cannot retrieve data as the datasource points to the development environment. How can I modify the data connection of the published workbook in the Tableau server to point to the production Oracle database? The table structure and fields in both the environments are the same. The only restriction is that I cannot connect my development laptop with the Tableau desktop to the production network.
Any help is much appreciated. Thanks
You don't need to use tabcmd, you can do the following:
- Publish the workbook to the live server using the connection to the development database.
- Open the Tableau Server Home page on a web browser
- Click the Admin tab and select Data Connections (see screenshot)
- Click the Connection Name you require and select Modify
- Change to login details to the production environment
- Check the your workbook works correctly against the production Oracle environment
