At any time while connected to a data source, you can export the connection information as a shortcut that allows you quickly connect without opening the connection dialog box. You might want to do this if you often connect to the same data source multiple times or if you’ve added custom fields to the Data window such as groups, sets, calculated fields, and binned fields or added joined tables. For subsequent connections to that source, use the shortcut so that you don’t have to recreate the custom fields. Note that you can also save custom fields by saving the workbook or by creating a bookmark file.
The connection is saved as a TDS (Tableau data source) file and is available on the Connect to Data page. Each TDS file references one data source, and stores information about the data source type and location, and any custom fields you have created. TDS files do not store data, workbooks, or worksheets.
TDS files are stored in the Data sources folder of the Tableau Repository. They have the .tds extension and can be identified by the data source icon . If you move the TDS file to another location, you cannot access the file with the Connect to Data dialog box. However, you can access the file by selectingand navigating to the file. You can also connect by dragging the TDS file onto Tableau’s desktop icon or onto the running application.
If you move the data source referenced by the TDS file, you will not be able to complete the connection. In this case, Tableau will ask you to replace the original data source with another one. Note that the replacement data source must be of the same type (Excel, MySQL, and so on) as the original.
- Select a data source on the Data menu and then select Add to Saved Data Sources.
- Complete the Export Data Source dialog box by specifying a file name.
As shown below, the new TDS file is displayed on the Connect to Data page.