Tableau Bridge needs to be running on a computer (or server) within the network continuously if you're trying to access your data live from Tableau Online. As soon as you take your laptop outside of the network you're having the same problem Tableau Online is having in that you cannot make a direct connection to the SQL Server.
- Look at installing Bridge on a server or computer which always stays within the network. Note, you should discuss this with your Account Manager as I'm not sure of the license implications here as I believe Bridge needs desktop to be installed as well.
- Open up the ports on your firewall to the Microsoft SQL Server so Tableau Online can access it. A few things you can do here to minimize your security risk; change from the default port and also whitelist the Tableau Online IP addresses so only connections from those IP addreses would be allowed on the port. You can find those IP addresses here - Tableau Online: Keep Data Fresh
- If neither of those are an option, you could look into a process whereby you publish extracts onto your server instead of a live connection.
Thanks for this. I had already queried with Tableau the licensing side and as i understand it with Desktop you can install on 2 machines effectively so should be OK from that perspective.
Would desktop need to always be running on the server or could bridge only run as a service on the server continuously?
In order to then get bridge working on the server do you still need to open the port and firewall up? I thought the bridge was a push tool from internally so no need to open up ports etc as it would work in the same sort of way as desktop does when you push data from it to online?
Appreciate any insight you can give as more knowledge helps me better understand/question relevant parties.
Take a look at the documentation on Tableau Bridge, it answers most of your questions - Use Tableau Bridge to Expand Data Freshness Options
This will be of interest as well - Allow Publishers to Maintain Live Connections to On-Premises Data
> You can run Tableau Bridge / Sync Client as a service on the server, no need for Desktop to be open (although you'll need to open desktop once to launch the sync lcient)
> You may need to open up a firewall port in order to enable bridge, i'm not 100% certain on this though.