{"id":8035,"date":"2018-02-14T10:35:11","date_gmt":"2018-02-14T10:35:11","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=8035"},"modified":"2025-02-27T20:03:08","modified_gmt":"2025-02-27T14:33:08","slug":"tableau-data-sources","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/","title":{"rendered":"Types of Tableau Data Sources with Connection Establishment Process"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:2031,&quot;href&quot;:&quot;https:\\\/\\\/help.tableau.com\\\/current\\\/pro\\\/desktop\\\/en-us\\\/exampleconnections_overview.htm&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251004034333\\\/https:\\\/\\\/help.tableau.com\\\/current\\\/pro\\\/desktop\\\/en-us\\\/exampleconnections_overview.htm&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-10 22:26:38&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-14 03:11:02&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-17 10:54:45&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-03 05:51:57&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-14 01:49:26&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-21 15:33:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-24 17:09:52&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-29 09:00:16&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-02 00:01:00&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-05 03:44:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-10 04:04:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-17 05:26:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-21 12:59:19&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-26 15:34:41&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-02 23:29:21&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-12 17:13:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-16 20:08:43&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-20 14:52:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-24 14:29:51&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-31 15:08:47&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-08 02:40:39&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-13 07:31:06&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-20 01:09:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-23 18:56:19&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-29 16:47:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-06 06:28:50&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-26 14:29:46&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-03 11:31:21&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-03 11:31:21&quot;,&quot;http_code&quot;:206},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<p>In this tutorial, we are going to learn about data sources or data connections in Tableau. We will start with the basics and explore in detail how to make connections with different types of data sources in Tableau. So let\u2019s get started.<\/p>\n<h3>Data Sources in Tableau<\/h3>\n<p>To master any Business Intelligence tool, the most basic operation we need to learn is connectivity to a data source. Once we establish a successful connection with a data source, we can access all its data, bring some part of it in Tableau\u2019s repository (extract) and use it for our analysis. Tableau offers a myriad of data sources such as local text files, MS Excel, PDFs, JSON or databases and servers like Tableau Server, MySQL Server, Microsoft SQL Server, etc.<\/p>\n<p>Categorically, there are two types of data sources that you can connect to in Tableau; <strong>To a file<\/strong> and <strong>To a server<\/strong>.<\/p>\n<h3>Connecting to a File in Tableau<\/h3>\n<p>Tableau offers a variety of options to connect and get data from a file in your system. The connection to a file section has file options such as MS Excel, MS Access, JSON, text file, PDF file, spatial file, etc. In addition to this, with the help of the <strong>More<\/strong> option, you can access the data files residing in your system and connect them with Tableau.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/more-file-source.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-72711\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/more-file-source.png\" alt=\"more file source - tableau data sources\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/more-file-source.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/more-file-source-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/more-file-source-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/more-file-source-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/more-file-source-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/more-file-source-520x279.png 520w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>Ideally, Tableau redirects us to the Tableau repository where our previously saved Tableau workbooks are present. However, you can access other locations on your device to browse more files.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/tableau-repository.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-72712\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/tableau-repository.png\" alt=\"tableau repository - tableau data sources\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/tableau-repository.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/tableau-repository-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/tableau-repository-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/tableau-repository-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/tableau-repository-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/tableau-repository-520x279.png 520w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<h3>Connecting to a Server in Tableau<\/h3>\n<p>The connection to a server section has countless options for an online data source. Here you will find connectors to different kinds of online data sources like:<\/p>\n<p><strong>a. Server-based Relational Database:<\/strong> Tableau Server, Microsoft SQL Server, Oracle, MySQL, Salesforce, IBM DB, Mongo DB, PostgreSQL, Maria DB, etc.<\/p>\n<p><strong>b. Cloud-based Data Sources:<\/strong> Cloudera Hadoop, Google Cloud SQL, Amazon Aurora, etc.<\/p>\n<p><strong>c. Web-based Data Sources:<\/strong> Web Data Connector<\/p>\n<p><strong>d. Big Data Sources:<\/strong> Google BigQuery<\/p>\n<p><strong>e. In-memory Database: <em><span style=\"text-decoration: underline\"><a href=\"https:\/\/data-flair.training\/blogs\/sap-hana-tutorials-home\/\">SAP HANA<\/a><\/span><\/em><\/strong><\/p>\n<p><strong>f. ODBC and JDBC<\/strong> connections<\/p>\n<p>When you connect to such data sources, you need to provide some basic information such as server name, user name, password specific to that connection. Tableau gives you a range of data connectors based on your subscription and package. In the Connect pane of Tableau, click on <strong>More<\/strong> option to explore and use all the available server-based data sources in your Tableau version.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/server-data-sources.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-72713\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/server-data-sources.png\" alt=\"server data sources in tableau\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/server-data-sources.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/server-data-sources-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/server-data-sources-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/server-data-sources-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/server-data-sources-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/server-data-sources-520x279.png 520w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<h3>How to Establish a Connection?<\/h3>\n<p>Moving on, let us see how do we connect to a data source from Tableau Desktop. We will show you how to establish a connection to an MS Excel file and use its data for analysis in Tableau.<\/p>\n<p>Open <em>Tableau Desktop<\/em> in your system. As soon as it opens, you will get the Tableau welcome page. On this page, you will find a blue pane on the left with the heading <strong>Connect<\/strong>. In this pane, you will find a list of data connectors for file-based and server-based sources. You can click on the data connector name, select a file or establish a connection.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/welcome-page-source.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-72714\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/welcome-page-source.png\" alt=\"welcome page source - tableau data sources\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/welcome-page-source.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/welcome-page-source-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/welcome-page-source-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/welcome-page-source-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/welcome-page-source-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/welcome-page-source-520x279.png 520w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>To fetch a Microsoft Excel file, we click on the option <strong>Microsoft Excel<\/strong> from the list.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/Excel-connect.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-72715\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/Excel-connect.png\" alt=\"Excel connect - Tableau Data Sources\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/Excel-connect.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/Excel-connect-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/Excel-connect-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/Excel-connect-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/Excel-connect-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/Excel-connect-520x279.png 520w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>It will open a new dialog box from where you can access files from your system. We have a sample Excel file which we are going to select and click <strong>Open<\/strong>.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/select-Excel-file.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-72716\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/select-Excel-file.png\" alt=\"select Excel file - tableau data sources\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/select-Excel-file.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/select-Excel-file-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/select-Excel-file-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/select-Excel-file-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/select-Excel-file-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/select-Excel-file-520x279.png 520w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>This will open the contents of the Excel file in a <strong>Data Source<\/strong> tab in a Tableau workbook.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/file-uploaded.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-72718\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/file-uploaded.png\" alt=\"file uploaded - tableau data sources\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/file-uploaded.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/file-uploaded-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/file-uploaded-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/file-uploaded-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/file-uploaded-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/file-uploaded-520x279.png 520w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>This tab has a Connections pane at its left which shows the name of the data source and its contents; that is, the number of sheets in the case of an Excel file.<\/p>\n<p>We can manage and view the contents of a data source by dragging and dropping sheets to the central pane. It will display the entire table with proper rows and columns of the respective sheet.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-sheets.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-72719\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-sheets.png\" alt=\"add sheets - tableau data sources\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-sheets.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-sheets-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-sheets-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-sheets-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-sheets-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-sheets-520x279.png 520w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>In addition to this, you can also add a new data source here by clicking on the <strong>Add<\/strong> option and then selecting the data file or connector of your choice.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/new-data-source.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-72720\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/new-data-source.png\" alt=\"new data source in Tableau\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/new-data-source.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/new-data-source-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/new-data-source-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/new-data-source-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/new-data-source-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/new-data-source-520x279.png 520w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>Or, by clicking on the Data tab present on the top-left bar and then selecting <strong>New Data Source<\/strong> option from there.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-data-source.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-72721\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-data-source.png\" alt=\"add data source - tableau data sources\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-data-source.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-data-source-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-data-source-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-data-source-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-data-source-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/add-data-source-520x279.png 520w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>From here, we can sort fields and manage metadata where you can see the names of all the columns present in their concerning tables. In this way, we can also manage multiple linked data sources.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/list-view.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-72723\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/list-view.png\" alt=\"list view - tableau data sources\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/list-view.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/list-view-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/list-view-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/list-view-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/list-view-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/list-view-520x279.png 520w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>Once we load our data source, we can move on to create a worksheet in Tableau. Open the tab called <strong>Sheet1<\/strong> just next to the <strong>Data Source<\/strong> tab and you will find a list of available data sources and fields within it.<\/p>\n<p>On the left, there is an organized list of available dimensions and measures from where you can select and use them to create charts and graphs. Just drag and drop dimensions and measures to the <em>Columns<\/em> and <em>Rows<\/em> section to start making visualizations.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/sheets.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-72725\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/sheets.png\" alt=\"sheets - tableau data sources\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/sheets.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/sheets-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/sheets-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/sheets-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/sheets-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/sheets-520x279.png 520w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>Every data source, especially server-based sources have different steps to follow in order to establish a connection with. Follow the steps, provide the necessary information and start working with your data in Tableau to carry out the analysis.<\/p>\n<p>Refer to the link given below to check the information requirements for each type of supported data connector given in Tableau.<\/p>\n<p><a href=\"https:\/\/help.tableau.com\/current\/pro\/desktop\/en-us\/exampleconnections_overview.htm\">Supported Connectors &#8211; Tableau<\/a><\/p>\n<h3>Summary<\/h3>\n<p>This was all about the Tableau data sources. Here, we learned about the two categories of data sources i.e. file-based and server-based. Also, we learned how to connect to a data source by connecting to a sample Excel file. You can try connecting to different data sources in your system.<\/p>\n<p>Hope you enjoyed learning from this tutorial. Do share your feedback in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, we are going to learn about data sources or data connections in Tableau. We will start with the basics and explore in detail how to make connections with different types of&#46;&#46;&#46;<\/p>\n","protected":false},"author":5,"featured_media":72876,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[21448,21449,3464,14232,21438],"class_list":["post-8035","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau","tag-connecting-to-a-file","tag-connecting-to-a-server","tag-data-sources-in-tableau","tag-tableau-data-sources","tag-tableau-data-sources-best-practices"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Types of Tableau Data Sources with Connection Establishment Process - DataFlair<\/title>\n<meta name=\"description\" content=\"Check the types of data sources in Tableau that you can connect to and establishing a connection to a data source from Tableau Desktop.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Types of Tableau Data Sources with Connection Establishment Process - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Check the types of data sources in Tableau that you can connect to and establishing a connection to a data source from Tableau Desktop.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-14T10:35:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-27T14:33:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/tableau-data-sources.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Types of Tableau Data Sources with Connection Establishment Process - DataFlair","description":"Check the types of data sources in Tableau that you can connect to and establishing a connection to a data source from Tableau Desktop.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/","og_locale":"en_US","og_type":"article","og_title":"Types of Tableau Data Sources with Connection Establishment Process - DataFlair","og_description":"Check the types of data sources in Tableau that you can connect to and establishing a connection to a data source from Tableau Desktop.","og_url":"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-02-14T10:35:11+00:00","article_modified_time":"2025-02-27T14:33:08+00:00","og_image":[{"width":802,"height":420,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/tableau-data-sources.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Types of Tableau Data Sources with Connection Establishment Process","datePublished":"2018-02-14T10:35:11+00:00","dateModified":"2025-02-27T14:33:08+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/"},"wordCount":953,"commentCount":2,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/tableau-data-sources.jpg","keywords":["connecting to a file","connecting to a server","Data Sources in Tableau","Tableau Data Sources","tableau data sources best practices"],"articleSection":["Tableau Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/tableau-data-sources\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/","url":"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/","name":"Types of Tableau Data Sources with Connection Establishment Process - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/tableau-data-sources.jpg","datePublished":"2018-02-14T10:35:11+00:00","dateModified":"2025-02-27T14:33:08+00:00","description":"Check the types of data sources in Tableau that you can connect to and establishing a connection to a data source from Tableau Desktop.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/tableau-data-sources\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/tableau-data-sources.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/11\/tableau-data-sources.jpg","width":802,"height":420,"caption":"tableau data sources"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/tableau-data-sources\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Tableau Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/tableau\/"},{"@type":"ListItem","position":3,"name":"Types of Tableau Data Sources with Connection Establishment Process"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/8035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=8035"}],"version-history":[{"count":8,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/8035\/revisions"}],"predecessor-version":[{"id":144279,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/8035\/revisions\/144279"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/72876"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=8035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=8035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=8035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}