If you want to connect to a Data source in Tableau there are many ways. In this session we will take a glance on Basic as well as advanced connection types.
To examine your tableau data, firstly you have to connect Tableau to one or more data sources. A Tableau data source can be as easy like an Excel workbook, or as elaborate as a SQL Server or Oracle data warehouse. After connecting, the data fields become presented in the Data window on the left side of the workbook. This connect to tableau data sources tutorial explains the kinds of data supported and how to build and maintain a basic connection.
Supported Data Sources
Tableau supports many tableau multiple data sources like multi-dimensional databases, SQL databases etc.
In this Connect to Data page, select the type of data you want to connect to and you will also select a saved data connection (TDS files) open a Tableau Server Data Source.
A data source specific dialog box opens that allows you to complete the connection process.
To connect to tableau data in another way you have to import from a workbook. A workbook have several worksheets, each of them can be attached to a different tableau multiple data sources. To import a connection from a workbook click the Import from Workbook button at the bottom of the Select Saved Connection tab in the Connect to Data dialog box.
Once the connection is set up the tableau data sources fields show on the left side of the workbook in the Data window.
Relational data sources you can connect to a specific query rather than the entire data source. This can be useful when you know correctly the information you require and understand how to write SQL queries.
Only the suitable fields show in the Tableau Data window, when you end with the connection.
If your SQL query indicates duplicate columns, you could get errors when you are trying to utilize one of the columns in Tableau. This will also happen even the query is valid.
Go through the Tableau online courses to make an informed decision now.
After connected to a tableau data source now we have to export the connection data as an alternate route which permits rapid connections without opening the connection dialog box.
If you frequently connect to the similar data source several times or if you have joined custom fields to the Data window like calculated fields, and binned fields or added joined tables. For following connections to that source, use the alternate route or shortcut so that you don’t have to re-establish the custom fields.
Note that: By saving the workbook or by creating a bookmark file you can also save custom fields.Previous Next
Download Interview Questions asked by top MNCs in 2019?