You can connect to data from either Tableau Desktop or a web browser by using Tableau Server or Tableau Cloud. The process differs slightly for each.
Starting in 2019.3, Tableau Catalogue is available with Data Management in Tableau Server and Tableau Cloud. When Tableau Catalogue is enabled in your environment, in addition to connecting to published data sources from Tableau Server or Tableau Cloud, you can connect to databases and tables from the Search for Data results on Tableau Desktop. For more information about Tableau Catalogue, see "About Tableau Catalog" in the Tableau Server or Tableau Cloud Help. Starting in 2021.4, Data Management includes virtual connections, a central access point to data. For more information, see "About Virtual Connections and Data Policies" in the Tableau Server(Link opens in a new window) or Tableau Cloud(Link opens in a new window) help.
Tableau Prep Builder can connect to published data sources and you can use them as an input data source for your flow starting in version 2019.3.1. If you have the Data Management with Tableau Catalogue enabled, starting in version 2020.2.2, you can also connect to databases and tables from the Search for Data results, just like Tableau Desktop. For more information, see Connecting to published data sources(Link opens in a new window) in the Tableau Prep Builder help.
Connect from Tableau Desktop
Note: Starting 2019.3, on the Connect pane, Tableau Server has moved to the top of the pane under Search for Data. Select this option to connect to Tableau Server or Tableau Cloud from Tableau Desktop.
- Start Tableau Desktop and on the Connect pane, under Search for Data, select Tableau Server.
- To connect to Tableau Server, enter the name of the server and then select Connect.
To connect to Tableau Cloud, select Tableau Cloud under Quick Connect.
Tip: If you don't sign out, Tableau Desktop saves your server connection, so you can skip step 3. You can also skip it if Kerberos is enabled on Tableau Server and your computer has valid credentials. For more information, see Automatically keep Tableau Desktop connected to Tableau Server or Online.
- To sign in:
- For Tableau Server, enter your username and password.
- For Tableau Cloud, enter your email address and password.
Select a data source from the list of published data sources. (Data that you don't have Connect permissions for is greyed out.)
Note: If you select a cube (multidimensional) data source, the Create Local Copy dialog box appears, and you must create a local copy of the data before you can start your analysis.
Search for data by using the Search box. Or you can sort the list by selecting the column headers. Column headers that support sorting are underlined when you hover over the header. You can also select the filter icon to filter data by Connection Type and by Certified.
In addition to connecting to data sources, when you have a Data Management licence, you can connect to data using a virtual connection. When Tableau Catalogue is enabled, you can also connect to databases, files and tables.
- You can select from Data Sources, Virtual Connections, Databases and Files, or Tables to search for data.
- You can filter assets by several options including Tag, Data Quality Warning, Certified and more.
Note: From the Search for Data results, you can make a connection with a subset of the data connectors that Tableau Desktop supports. If a data source, database, file or table is greyed out, you can't connect from Tableau Server or Tableau Cloud. You can, however, connect from the Tableau Desktop Connect pane, if you have the correct permissions.
- After you select the data you want to connect to, click Connect.
- Select the sheet tab to start your analysis.
Data sources published to Tableau Server or Tableau Cloud are shown in the Data pane with a Tableau icon.
You might want to download a local copy of the data source so that you can, for example, work offline or make changes to a data source without modifying the original. To download a local copy, on the Data menu, select the data source, and then select Create Local Copy. A duplicate of the data source is added to the Data pane.
Sign in on a Mac
If you use Tableau Desktop on a Mac, when you enter the server name to connect, use a fully qualified domain name, such as mydb.test.ourdomain.lan, instead of a relative domain name, such as mydb or mydb.test.
Alternatively, you can add the domain to the list of Search Domains for the Mac computer so that when you connect, you need to provide only the server name. To update the list of Search Domains, go to System Preferences > Network > Advanced, and then open the DNS tab.
Connect to published data sources while web authoring
Tableau Desktop users who create and customise data connections for Tableau use can publish their data sources to Tableau Server or Tableau Cloud. Publishing enables sharing data among colleagues, including those who don't use Tableau Desktop, but have permission to edit workbooks in the web editing environment.
If you have permission to edit workbooks in a browser, follow these steps to connect to published data sources when you’re signed in to Tableau Server or Tableau Cloud. For more information see Edit Tableau Views on the Web and Using Tableau on the Web.
Note: To connect to data, you need permission to create and edit views.
Add more data to an existing view
- On a Tableau Server or Tableau Cloud site, select a view to edit.
- In editing mode, click the New Data Source icon
.
- In the Connect to Data page, the options you can see and select from depend on your permissions:
- On this site. Select a published data source from the list, and then select Add data source.
When Tableau Catalogue is enabled in your environment, you can select Data Sources, Databases and Files, or Tables from the Content Type drop-down list. Then select the data you want to connect to and click Connect.
- Files. Drag and drop a file or upload one from your computer.
- Connectors. Connect to your data using one of the connectors listed.
- On this site. Select a published data source from the list, and then select Add data source.
Create a workbook with a published data source
You can also connect to a published data source when creating a new workbook:
- On a Tableau Server or Tableau Cloud site, navigate to the Explore page, and select All Data Sources from the drop-down list.
- In the list, select the tick box next to the data you want to use.
- At the top of the page, from the Actions drop-down menu, select New Workbook.
For information about connecting to data when you're authoring on the web, see Creators: Connect to Data on the Web.