Connect to Your Data

Before you can build a view and analyze your data, you must first connect Tableau to your data. Tableau supports connecting to a wide variety of data, stored in a variety of places. For example, your data might be stored on your computer in a spreadsheet or a text file, or in a big data, relational, or cube (multidimensional) database on a server in your enterprise. Or, you might connect to public domain data available on the web such as U.S. Census Bureau information, or to a cloud database source, such as Google Analytics, Amazon Redshift, or Salesforce.

Tableau Desktop

When you launch Tableau Desktop, the data connectors that are available to you are listed on the Connect pane, which is the left pane on the Start page. File types are listed first, then common server types, or servers that you've recently connected to. Click More to see the complete list of data connectors you can use.

For supported files and databases, Tableau provides built-in connectors that are built for and optimized for those types of data. If your file or database type is listed under Connect, use this named connector to connect to your data. If your file or database type is not listed, you might have the option of creating your own connection using Other Databases (ODBC) or Web Data Connector. Tableau provides limited support for connections that you create using either of these options.

The data connectors supported by your copy of Tableau Desktop are determined by the version you purchased. For more information, see the list of data connectors on the Tableau website. After you've connected to data, you can save the connections to have them show up under the Saved data sources section on the Connect pane.

You supply different information for each data connection that you want to make. For example, for most data connections, you’ll need to supply a server name and your sign-in information. With some data connections, you can Run Initial SQL statements, and SSL-enabled servers require that you select the Require SSL check box when you connect. The following sections discuss the specific information you need to provide for each type of data you want to connect to.

Tip: You can quickly create a data source in Tableau by copying and pasting data using the clipboard. For more information, see Create a Data Source or Add a New Connection with Clipboard Data .

Tableau Online and Tableau Server web authoring

When you sign into your Tableau site and select New Workbook, the data connectors that are available to you are shown when you're in the Connect to Data window. You can upload files using the Files tab, connect to server or cloud data sources with Connectors, or use published data sources with On this Site. If you're signed into Tableau Online, Dashboard Starters are also available. For more information, see Creators: Connect to data on the web.

The data connectors supported by your Tableau site are determined by your site's server and your license level. For more information, see What Can I Do with a Tableau Site? After you've connected to data, you can save the connections to have them show up in the Data Sources section of your site.

Request a new connector

If Tableau doesn't have a built-in connector for your data, consider requesting one on Tableau Community. Use Ideas on Community to search for your connector to see if it's been requested, and if it has been, vote for it. If it's not listed, add it. Tableau regularly reviews Ideas on Community to help determine what features should be added to the product.

Thanks for your feedback! There was an error submitting your feedback. Try again or send us a message.