5 Replies Latest reply on Jul 26, 2018 12:16 AM by vijay reddy

Web data connector in tableau server

vijay reddy Apr 6, 2018 7:43 AM

Hello All,

I have developed a web data connector for tableau. It works fine with tableau desktop.

I have issues using it on tableau server.

case 1:

1. I connect to web data connector, create a sheet and add visualization

2. Publish the workbook. so the connection is also published.

3. Create a new tableau document, use the published connection, things work fine

4. open the workbook in tableau server and things work fine.

case 2 :

1. I connect to web data connector

2. publish the connector alone

3. create a new tableau document, use the published connection. Now i see the Live connection option is enabled. Now with the Live connection, if i try to create a visualization, it throws up an error "No such function SUM that takes arguments of type (real)", if i use a measure in the chart. If i use a dimension then things work fine

4. create a new workbook in tableau server and I get the same error.

Is live connection not supported in this case? is there a way to get this working?

Any help here is appreciated.

PS : I have done the basic things like white listing the url etc.

I also tried to convert the data type using float(), still get the same issue.

Thanks

Vijay Reddy.

1. Re: Web data connector in tableau server

Amber Loranger Apr 19, 2018 12:16 PM (in response to vijay reddy)

Hello Vijay,
If you have done everything here Web Data Connectors in Tableau Server it might be time to submit a case to Technical Support: Support Case | Tableau Software
I wasn't able to find any past record of this exact issue.
Like Show 0 Likes(0)

Actions
2. Re: Web data connector in tableau server

Daniel Stanish Apr 19, 2018 12:30 PM (in response to vijay reddy)

Have you tried creating a calculation of the troublesome field, say converting it to a number, then using that calculated field instead of the original?
Like Show 0 Likes(0)

Actions
3. Re: Web data connector in tableau server

vijay reddy Apr 24, 2018 7:53 AM (in response to Daniel Stanish)

Hi Daniel,

I tried converting it to float. I still get a similar error.

Thanks
Like Show 0 Likes(0)

Actions
4. Re: Web data connector in tableau server

Sunil Tikar Jun 26, 2018 10:31 AM (in response to vijay reddy)

Hi vijay reddy

I am also looking for some help. I am tableau server administrator and my desktop users asking for web data connectors. I know its all on local machine where they will develop their web connectors.

I want to know is there anything needs to be done at Tableau server end in order to allow workbook rendering those are based on web data connectors?

Any help would be much appreciated.

Regards,
Sunil
Like Show 0 Likes(0)

Actions
5. Re: Web data connector in tableau server

vijay reddy Jul 26, 2018 12:16 AM (in response to Sunil Tikar)

Hello Sunil,

If the requirement is to publish the tableau documents created using webdata connector to the server and be able to refresh/schedule them then yes there are certain things that needs to be done on the tableau server

1. you will need to whitelist the web data connector urls
     tabadmin whitelist_webdataconnector -a https://example.com/myconnector.html
     tabadmin whitelist_webdataconnector -s https://example.com/myconnector.html https://myFirstAPI.com/getData,http://mySecondAPI.com:80/(.*),data:image/(.*)
     more information can be found at tabadmin commands
2. For refreshing the extract in tableau server, you need to make sure the password is embedded in the tableau document while publishing.
     depending on the authentication type of the web data connector, the developer would need to store either the user name and password(for basic authentication ) or accesstoken(for oauth)
     more details at WDC Authentication

Thanks
Vijay R.
Like Show 0 Likes(0)

Actions