Thank you for looking into this. Still waiting to get a reply for the same.
1 of 1 people found this helpful
What if you write an ODBC connection customization file
(named say vertica.tdc ) in the 'Datasources' directory?
The XML code in the file would be like this:
<?xml version='1.0' encoding='utf-8' ?>
<connection-customization class='vertica' enabled='true' version='18.1'>
<vendor name='vertica' />
<driver name='vertica' />
<customization name='odbc-connect-string-extras' value='ConnectionLoadBalance=1' />
The 'Datasources' directory would be (on the Tableau Server for Linux):
The Tableau Server restart may be required (though i'm not sure).
You can also check if the customization works for you
by using the same TDC file with Tableau Desktop --
put it in My Tableau Repository/Datasources folder and check
if it actually enables Load Balancing on your Vertica cluster
(in TD make several connections simultaneously to test it).
Thanks for looking in to this. I have use the above & found that it works as expected with Tableau Desktop. But from Tableau server the vertica load balancing doesnt seem to work. I raised this with Tableau support and they said that "We do not test & support TDC file".
In that case is there any other way we can achieve vertica load balancing for requests coming from tableau server.
Could you please walk through the following steps:
1) Remove the vertica.TDC file from your computer with Tableau Desktop
(from C:\Users\%USERNAME%\My Tableau Repository\Datasources folder).
2) Make a brand-new workbook (and the datasource in it) using a connection to Vertica.
3) Publish the workbook (with at least one simple view) -- or the Datasource itself --
to the Tableau Server. The server should have the vertica.TDC file in place
(in the /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Datasources directory).
4) Test if the published workbook (view) -- or a new workbook created in Web Edit mode
from the published datasource right on the server -- could use the Vertica Load Balancer.
I followed your steps & ended up getting error that "tableau desktop & tableau server TDC file should match".
Please do the last try:
Publish a new workbook while the vertica.TDC file is active in Tableau Desktop,
and have the same vertica.TDC file available on the Server, too.
Do it as if guided by a common sense :-)
PS Yet another option would be to copy the <customization> section
from the vertica.TDC file and paste it right into the XML code
of the datasource (TDS) / workbook (TWB), and publish it to the server.
There is no need in TDC file on server in this case.
I have tried all possible combinations including yours, but still not been able to get any success. Even i tried DNS round robin setup on Tableau server which also dint work.
Anyways i would like to personally thank you for your regular assistance on this issue.