1 of 1 people found this helpful
No, Jane will get asked for connection credentials to the live ODBC connection. Unless she knows those credentials, she will not be able to connect to the underlying data.
For an Extract, Bob would have the option to embed the connection credentials in the data source so that Tableau Server can manage the refresh activity. In that case, Jane would be able to use the data source without being prompted for connection credentials, provided she had sufficient permissions to the Tableau data source itself.
Thanks - how does this change if credentials are embedded in the Live ODBC connection?
I’m not sure that you get that option. You do for an extract by Tableau usually won’t let you do that for a live connection. I don’t have immediate access to an environment where i can test it.
Sorry Michael - it's a property of Tableau Server. Here's the documentation on it:
"We should note that there are scenarios where embedded credentials can inadvertently provide access for users who shouldn't see the data. Therefore, for organizations that require user-level authentication to databases, we recommend disabling embedded credentials. Users are then prompted for credentials when they open a workbook, data connection, view, or dashboard that gets its data from a source that requires authentication."
I'm trying to figure out the limitations of this one.