You can translate the question and the replies:

Get data from Tableau to Denoda. Is it possible?

I need to import tableau crm data to denodo. Is that any way to import tableau data to denodo vritualiation tool.
user
22-05-2021 01:39:43 -0400

1 Answer

Hi, For this scenario, Tableau offers a [REST API](https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api.htm) to consume data from Tableau Server and Tableau Online. Using this API you can configure Tableau as a data source in Denodo Platform by making use of our [XML](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/xml_sources/xml_sources) or [JSON](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/json_sources/json_sources) data sources using HTTP Client as the 'Data route' and joining those results to construct data views. Further, I would consider the following points on how to use this REST API as follows: * **Authentication** - Tableau's API offers only one means of authentication which is a token retrieved by a POST request passing the credentials (username/password or [Personal Access Token](https://help.tableau.com/v2019.4/server/en-us/security_personal_access_tokens.htm)) in the body of the request. The way to handle this from Denodo Platform is to create a view over an XML source that retrieves this token. Once this view is working, it can be used to [feed other views with the necessary authentication token ](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/path_types_in_virtual_dataport#paths-and-other-values-with-interpolation-variables)in the header X-Tableau-Auth. This will also retrieve the Site ID necessary for all calls. * [Data query](https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_view_data) - The GET method linked might be the most suitable for the task of creating a view. It is important to note that it returns values as CSV so the appropriate data source here will be a [Delimited File](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources). You could refer to Tableau's [API Reference](https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm) to see all the methods you can use to consume data from Tableau Server. Hope this helps!
Denodo Team
24-05-2021 06:43:56 -0400
You must sign in to add an answer. If you do not have an account, you can register here