Question
How to query the User (sys_user) table when using the ServiceNow connector
Last Modified Date: 16 Aug 2023
Environment
- Tableau Desktop
- ServiceNow
Answer
The User (sys_user) table is exposed as 'system_user' when using the ServiceNow connector.Additional Information
When using the Cdata JDBC driver for ServiceNow, the tables are exposed using the Internal Table Names by default, instead of the ServiceNow GUI Display Names.If you prefer to use the ServiceNow GUI Display Names with the ServiceNow connector (for example, the sys_user table would appear as 'User' in the table list), customize the connection using a cdata_servicenow.properties file that contains the following key-value pair:
UseDisplayTableNames=true
For more information about the UseDisplayTableNames connection property, see UseDisplayTableNames.
For more information about customizing JDBC connections using a properties file, see:
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials