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

3 Answers

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
I realise this is an old question, but for a simpler option, albeit something which needs set on every data source you create, when you are specifying the database, you can suffix it with a question mark, and then add userAgent=Tableau, like so... ``` vdb_name?userAgent=Tableau ``` you can also add things like an extended query timeout like so ``` vdb_name?userAgent=Tableau&queryTimeout=3600000 ``` It would be far better being able to set this at a Tableau Platform level though. I am unsure if there are options which allow you to set this in the ODBC config on Tableau. If I find out I'll post back.
user
27-10-2021 03:21:03 -0400
Hi, In order to specify the userAgent parameter in the Tableau preferably latest version, you could perform the following steps: * Establish a connection between Tableau and Denodo Platform by specifying the values such as hostname, port and authentication method. * Specify the database name that you want to connect in the “Database” field along with that, add the parameter **userAgent** as follows: `<DATABASE_NAME>?userAgent=<user_agent>` * Then, click on “Sign In” By performing the above steps, you could able to connect to the mentioned database successfully. Additionally, you could specify the queryTimeout parameter in the “Database” field as: `<DATABASE_NAME>?userAgent=<user_agent>&queryTimeout=100000.` Please refer to the [How to connect to Denodo from Tableau Desktop](https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Denodo%20from%20Tableau%20Desktop?category=Northbound+Connections) Knowledge Base article for more information. Hope this helps!
Denodo Team
05-11-2021 06:41:08 -0400
You must sign in to add an answer. If you do not have an account, you can register here