2 of 2 people found this helpful
There are a couple of options along these lines:
- If you are using Tableau Server, you can publish a data connection and then reuse it in different workbooks. I'm guessing you are probably looking for a Desktop Option, so...
- In Tableau Desktop, select your data connection (right click or from the menu "Data" --> Your Connection , then select "Add to Saved Data Sources." The file you save (.tds -- Tableau Data Source) will contain all the metadata (field names, calculations, etc...) These saved connections will show up on the "Connect to Data" screen when you first open Tableau and you can reuse them.
Just remember, every new workbook is using its own copy of the connection, so any changes you make (new calculations, etc...) will need to be saved again (overwrite the .tds file) and any workbooks using the connections will need to be updated -- so a little more manual than the Tableau Server options.
Hope that helps!
Thanks so much Joshua! Someday we'll need to step up to Server. But for now, the saved .tds will work fine. Thanks again!
Glad to help, Alex! You're welcome!
Hi Joshua: In option 1, if I need to use different tables in different workbooks, then I need to keep creating unique data source for each unique table. All my tables in database are not related and hence can't be joined, they are independent.
I don't understand why a data source need to be associates with table ( or tables ) always. I thought Tableau would just need to save credentials in the connection and allow the users to drag whatever the tables they wanted and create workbooks.
No, for security reasons, Tableau does not save credentials (the only exceptions are options for embedding credentials when publishing to Server).
The basic paradigm is:
- to create a connection that includes the tables, joins, metadata, etc... that can be consumed by users. AND/OR
- to grant Creator licenses to individuals who will connect to data sources and use whatever tables they need for their analysis.
Hope that helps!