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 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:
- Tableau Server
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.
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.
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.