I found the solution of this. Below worked just fine with me on my Tableau server 2018.3
Copy paste the html file (WebDataConnector.html) to server installation folder - <Installation Folder>\Tableau\Tableau Server\data\tabsvc\httpd\htdocs
Re-start the server.
Above will allow you to use URL: http://<Server Name>/WebDataConnector.html
You can use it on a chrome browser to validate that it shows up. IE browser has some issues and does not works properly with WDCs.
Next, use below command to add it as web data connector
tsm data-access add -n "Name of your WDC" --url http://<Server Name>/WebDataConnector.html
tsm pending-changes apply - this will apply the changes and re-start the server too.
Once server is started you can use the URL - http://<Server Name>/WebDataConnector.html to configure in the workbooks and it will work fine.
Thanks, our environment is on Windows.
I have tried the below as you have mentioned after placing the html file in this path'D:\Tableau Server\data\tabsvc\httpd\htdocs\webdataconnectors' and I keep getting the 'Unrecognized option: -n'
D:\Tableau Server\packages\bin.20183.18.1019.1426>tsm data-access web-data-connectors --name "excel.png" --url http://server:80/webdataconnectors/excel.png
Unrecognized option: --name
Any idea why it's complaining about the -n ?
I tried similar command at my end and got the same error as you are getting.
Please try using -n instead of -name. It worked for me once I used -n in place of -name.
Try it and see if it helps.
I have tried same and got the same error:
Unrecognized option: -n
Did you try browsing the URL to see if it is working?
Below is the exact command I am executing. We too have windows 2012R2 machine
tsm data-access web-data-connectors add -n "NAME.png" --url http://bidtbldev001/TableauAutoRefresh.html
I am using windows and can not find this folder path.
<Installation Folder>\Tableau\Tableau Server\data\tabsvc\httpd\htdocs
I have added the web connector url to secure list and also allowed refresh.
The data is not refreshing.
The error saying not whitelisted.