we are having difficulties to keep the connection from Tableau to Denodo alive when we put a load balancer in place. When we directly connect to a Denodo server through the special Denodo connector included in Tableau we don't have difficulties.
We followed these instructions:
This works perfectly without load balancer in between.
When we add the load balancer, after a couple of minutes idle time in the browser, the user gets an error that the connection to the datasource has failed: "Unable to connect to the data source" - "no connection to the server"
We also found this article on connecting through JDBC through a load balancer to Denodo, which seems to introduce some extra parameters, however I cannot find these parameters in the Denodo connector settings in Tableau?
2. Could it be that the Tableau - Denodo connector is not suitable to work with a load balancer, but only directly connected to a Denodo server?