You can translate the question and the replies:

Setting user agent with Denodo connector in Tableau

The reference manuals [describe](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/monitoring_the_virtual_dataport_server/monitoring_with_a_java_management_extensions_jmx_agent/setting_the_user_agent_of_an_application#setting-the-user-agent-of-an-application) the option to set the user agent for a JDBC, ODBC and JMS connection. It also states that "*The user agent is not configurable for other types of clients*". The native Denodo connector for Tableau does not have an option to set the user agent. What it does have, is an option to set the Initial SQL: "*a SQL command to run at the beginning of every connection*". Is there any way to set the user agent using a SQL statement? If not, are there any plans to expand the configuration options of the native Denodo connector to include the user agent option? Thanks!
user
14-02-2018 06:34:23 -0500

1 Answer

Hi, In order to pass the user-agent information from Tableau to Denodo Platform using the Initial SQL option, I would do the following steps: 1. Create an empty table with a field of type 'varchar' on any database (for eg: Oracle) and utilize this table by a creating a base view in the Virtual DataPort Administration Tool. 1. In the Tableau, click on "Initial SQL" option to insert the data into the view by using insert query and select the parameter [TableauServerUser] from the "Insert dropdown" as the value. * For example: insert into <view name> values([TableauServerUser]) 2. Click 'Ok' to execute. By executing this view in Virtual DataPort, I can able to find the user agent information. The TableauServerUser parameter in Tableau will return the username of the current server user. Hope this helps!
Denodo Team
15-02-2018 08:17:16 -0500
You must sign in to add an answer. If you do not have an account, you can register here