NEW! FREE 30 Minutes MS Excel - Working with Dates Course  Watch now 


Tableau Data Sources

2 Mins read
Tableau data sources

A Data Source is a connection to a database or a place where the data is generally stored. Users are able to create workbooks that point to a data source. The data source can be extracted or shared on Tableau Server generally. Let us first lean into understanding different connection types of Tableau data sources

Tableau Data Source Connection Types

  1. Live
  2. Extract

1) Live Data Source Connection

In this type of connection, the data source provides real-time data to Tableau and hence the name. Tableau makes queries directly to the data source and the reply of queries can be directly used as a data source.

2) Extract Data Source Connection Types

In this type of connection, an extract is created from a static source of data. This data created can be like an Excel Spreadsheet. It contains the data in the field from a relational database or from cloud-based data.

Must Check: Different Tableau Data Types

Tableau Data Sources

Tableau can be connected to the popular Data Sources such as Excel, Databases, and Websites. It can connect to almost all the data sources such as Files, Relational, Cloud, and other sources.

The following are the different types of Data Sources in Tableau:

  • Files
  • Databases
  • Websites
  • Tableau Server

1) File

Tableau can be connected to various Data Files like Text files, Excel files, PDF files, etc. To connect to the text file, go to the connect feature and click on the Text file. For connecting Microsoft Excel file repeat the same step but select Microsoft Excel. In file data sources other files are JSON, Microsoft Access, PDF file, Spatial file, Statistical file, etc.

2) Database

Tableau can be connected to various databases. To connect to any database, you need to go to the connect tab and select any database under To a Server section. The database sources available are Tableau Server, Microsoft SQL Server, MySQL, Oracle, Amazon Redshift, etc.

3) Websites

Tableau can be connected to different websites. To connect to websites, go to the connect tab, and click on more options, a long list of data sources gets opened. Here click on Web Data Connector to connect.  In this Web Data Connector, you need to enter details.

4) Tableau Server

Unlike the other Data Sources, Tableau can be connected to Tableau Server for the Data. To get data from the Tableau Server, open Tableau Desktop and click on Connect. Under Connect Pane select Tableau Server. To connect to Tableau Server write the name of the server you want to connect and finally click on the Connect tab.

Thus, in this blog, we discussed the type of data sources in Tableau, different types of Data Sources in Tableau, and where they could be found to get connected in Tableau. Tableau has a large number of data sources and it can be connected to all the data sources available.

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…