Using Vertica 7's Native Load Balancing with Tableau 8

I am not exactly sure how talend manages connection metadata, but for Microstrategy adding LoadBalanced=1 in the connection properties in odbc.ini does the trick. I assume similar parameters file exists for Talend, and adding the LoadBalanced property should do.

/Sajan

Thanks Sajan, I tried setting both
LoadBalanced=1
and
ConnectionLoadBalance=1
in my C:/Windows/ODBC.INI file
But it didn't make any difference.

The only method I've found that works is to edit the Tableau workbook as follows:
<connection class='vertica' dbname='zen' odbc-connect-string-extras='ConnectionLoadBalance=1'...
This forces Tableau to connect using load balancing (from tabprotosrv.txt)
ConnectString: DRIVER={Vertica};READONLY=0;DATABASE=zen;SERVER=192.168.1.231;PORT=5433;UID=dbadmin;PWD=********;ConnectionLoadBalance=1

Got it, I followed the example in this link and it's now enabled for my Tableau Desktop workbooks containing vertica datasource connections.