ServiceNow ODBC Connection with Tableau SQL Query Issue

[Austin20]

Does anyone in here use Tableau to connect to their ServiceNow instance? If so, how do I go about joining tables? When I try to join them and pick the values that should be joined, they show up as two different tables, instead of being joined to show all data in one. I feel like I'm missing something. I even try to do a custom SQL query but that didn't work out for me either. I'm trying to show the tasks and incident tables together to create some visuals.

m on version 2020.4.1 on Tableau Desktop Professional Edition. So I thought it would be simple as just doing a custom query like "Select top 10 * from task". When I try that it throughs this message: An error occurred while communicating with the Other Databases (ODBC) data source 'ShowData'

Bad Connection: Tableau could not connect to the data source.

Error Code: B19090E0

[SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Cannot create schema.The table has not been found in the DB schema [tableName=TASKS]. The table might not exist in the database or the table ACLs prevent user access to it. Hop on the instance, navigate to Tables, find the requested table and if it is there check ACLs.[1050]

[SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Cannot create schema.The table has not been found in the DB schema [tableName=TASKS]. The table might not exist in the database or the table ACLs prevent user access to it. Hop on the instance, navigate to Tables, find the requested table and if it is there check ACLs.[1050]

Generic ODBC requires additional configuration. The driver and DSN (data source name) must be installed and configured to match the connection.

Unable to connect using the DSN named "ServiceNow". Check that the DSN exists and is a valid connection." However if I drag tables from the left hand side to the upper middle, data is returned at the bottom when I hit update now. When I drag another table I want to join on, it brings up the "How do relationships differ from joins?" I was thinking that I would want to put the item I want to join on. Ex. Assignment Group. 

I should note that I can run a query from the interactive SQL window when testing the connection. So I know querying works but not sure why it doesn't with Tableau.

Thank you for any taking the time to look at this and for your answers.

[Tsura Andreeva]

Humm that to me sounds like permissions issue if you read the error message because we know that task is a table in ServiceNow. I would check with your admin folks that something did not change on the task table and your access role to it. "or the table ACLs prevent user access to it."

[Austin20]

These are the three groups I'm in: admin, odbc, security admin. How would I go about check the ACL for permission issues?

[Tsura Andreeva]

I would reach out to your sys admin to find out but if you want to read up on it, this might be interesting: https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/contextual-security/concept/access-control-rules.html