Tableau is the fastest growing BI tool that is used for data visualization and data integration. This tool helps to simplify the massive amount of data that is generated daily in an organization. The analyzed and manipulated data is produced in a simplified form of charts, worksheets, and dashboards. In this Tableau Server Tutorial, we get the insights of Tableau Server Architecture, Installation, and the Configuration process.
Want to be part of Tableau Environment? Learn Tableau from Mindmajix's "Tableau Certification Training"
Tableau tool is user-friendly, and even a non-technical user can able to create dashboards. It doesn’t require any programming or technical skills to operate the Tableau tool. The Tableau suite includes the following products:
Q1) What is the Tableau Server?
Ans: The Tableau Server is part of the Tableau tool that is used to hold or share the worksheets and data visualizations that are created in the Tableau Desktop application across the organization. Once the data is updated in the server, it can be accessed only for licensed users. This way, the Tableau server ensure the data is secure from hackers.
The Tableau Server provides high security, and thus, it is best suited for easy and effective data sharing in an organization. The admin of the organization will handle the control over the server. The organization maintains the software and hardware.
Q2) How is Tableau Server different from Tableau Desktop?
Ans: The Tableau Desktop offers the ability to create interactive dashboards and workbooks. The Tableau Server allows the user to share, publish, and administrate the Tableau Desktop. Let’s see the differences between Tableau Server and Tableau Desktop.
|Tableau Server||Tableau Desktop|
|Tableau Server is used to publish and share the worksheets, dashboards, and stories that are created using Tableau Desktop.||Tableau Desktop is used to create worksheets, stories, dashboards connecting to the data sources that can be the files or servers.|
|It is best suitable for developers to create reports that provide insights to decision-makers.||It is best suitable for decision-makers to analyze their results.|
|Once the worksheet is uploaded into the server, the recipient doesn’t require to install Tableau Server. All they need is Login credentials provided by the admin.||One can share their work locally by sharing the workbook. However, it is required to know that the recipient is having Tableau Server or Tableau Desktop in their PC.|
|Tableau Servers are used as high-performance data repositories for Desktop users.||Tableau Desktop users can use the server for a high-performance data repositories.|
|It is a great tool to generate reports without any frightening BI suites execution.||It is easy to use and quite helpful for the Sales team.|
|It provides limited editing options.||It offers numerous editing options.|
|It deals with medium and large scale businesses.||It deals with small and medium businesses.|
|It allows users to perform easy to use analytics based on the browser.||It enables the users to use drag and drop feature for analysing the data.|
|Dashboards that are created are shared with others using Tableau Server.||Dashboards are published to Tableau Server from Tableau Desktop.|
|It is a standalone and on-premise, cloud saas software.||It is an add-on and on-premise software.|
Tableau Server Architecture
Tableau Server Architecture includes various components as in the following diagram.
#1 .Data Server
The Data Server manages the connections to Tableau Server data sources. These data sources can be on-premise and can connect to excel file, database, and a web application at a time. Configure one or more data server processes to run on multiple nodes of the cluster, that helps to various data sources.
Tableau Server is not dependent on Data Server to function. But, without running Data Server, workbooks on the server lose the ability to query or to connect to published data sources. Queries running through the Data server process will fail, when the Data Server process fails, resulting in a failed view rendering, alert, or extract refresh. Subsequent requests, consisting a retry of the process should work as long as the Data Server is available to accept rerouted requests.
#2. Data Connectors
The Data Connectors provide an interface to connect external data sources to the Tableau Data Server. It can connect to any databases without using their native connector. Based on the usage, the user can choose both live connection data and Extracted data.
- Live connection data: Tableau can connect to data by linking to the external database directly. It utilizes the infrastructure of the existing database system by redirecting dynamic Multidimensional Expressions (MDX) and SQL statements. It can link to live data using Tableau instead of importing data.
Extracted data: Tableau allows extracting the data from external data sources. It can extract millions of records in the Tableau data engine with a single click. Extracted data improves performance, mainly while working on massive datasets. Extracted allows the user to visualize the data offline, without connecting to the data source.
[Explore Tableau Interview Questions -Beginner & Advance Guide]
Tableau Server Components
#1. Application Server
The Application Server (VizPortal) handles the web application and REST API calls. It also supports searching and browsing. When a user opens a view in a client device, that user begins a session on Tableau Server. Then the Application Server thread begins and verifies the permissions for that user and that view.
#2. VizQL Server
The VizQL Server loads and renders views computes and executes queries. It is used to convert the queries from the data source into visualization. When the client request is redirected to the VizQL server, it sends queries to the data source directly. It recovers information in the form of images or visualization that is presented to the user.
The Tableau Server gateway process is an Apache web server component and is used to handle requests to the server from all the clients- Tableau Desktop, proxy, mobile devices, a load balancer, etc. The server runs a single instance of the gateway process, so the user can not run more than one gateway per machine. For multiple server configuration, one physical system works as a primary server while others are used as worker servers.
The gateway process is required on any node with an instance of VizQL Server or VizPortal. When the external load balancer lacks, the gateway acts as the load balancer.
#4. Data Engine
The data engine is one of the essential components that hold the processes associated with the Tableau Data Extract(TDE). It enables only when the query appears, that involves data from TDE. The data engine stores various TDEs and can run on multiple servers. It also attends several requests parallelly at a time. The Data engine hosts the data in-memory extracted from the TDE upon getting a request from the user.
#5. Search and license
The other two significant components are the Search and License. The search component organizes the search index for data in the repository. While the License component manages the licensing and configuration of the Tableau Server. These two components run on the primary server of the Tableau server cluster.
Tableau Server Installation
Download the version and open it. Now, run the downloaded file and accept the agreement and install the Tableau Server.
Subscribe to our youtube channel to get new updates..!
Then it redirects to Tableau Server Manager. Enter sign credentials and complete the below four-step process.
1. Activation- If you have the product key, then Enter the key. Or click ‘Try it free for 14 days’ for trial version.
2. Register- Enter the required registration detail and click ‘Register’.
[ Related Page: Best Way to Build Dashboard ]
3. Setup- Enable the required setup details and click ‘Initialize’.
4. Initialization- It takes some time for the initialization and notifies to create a Tableau Server Administrator account. Click ‘Continue’.
5. After initialization, it redirects you to the Tableau page to create a New Administrator account. If you have the Administrator account, you can enter the credentials.
Now, the Tableau Server is ready to work.
Adding Local users
Tableau server allows you to add individual user information and then import several users from a CSV file. You can also include attributes like site role and the ability to publish in the CSV file, to apply the users, and to import them. To add local users, do the following:
Log on to the Tableau Server using the credentials.
Click Users in the Administration area.
Add User- It allows you to add users by giving Username and password at a time.
Add Users from CSV File- It allows you to add multiple users from a CSV file.
Click Add User. Enter the details of the users in the Required User information.
Click Add User. Then the user details have been added successfully.
Configuring a Three-node HA cluster
A multi-node High availability installation of Tableau Server can help to improve the efficiency and availability of Tableau Server. After installing the Tableau Server on an initial node, you have a system that is running everything it needs to function. The server topology looks like the below diagram:
To configure three-node HA Tableau Server with two repositories and two file data engine instances, do the following steps:
Install and configure the Tableau Server with an initial node.
Go to the configuration tab and click ‘Download Bootstrap File’ to download the file.
The bootstrap file is downloaded and stored in your PC.
Now, install the Tableau Server using Bootstrap. You will get a ‘Node Configuration’ window.
Browse the downloaded bootstrap file and enter the Username and Password and click ‘Next’.
Next, redirects you to the sign-in page as a Tableau Services Manager.
A new node is detected, as shown in the figure.
Now, go to the Configuration tab, where the node2 Added window appears. Click ‘Continue’.
Do you know: Top Free Data Visualization Tools
You can see the node2. Click ‘Pending Changes’ and then click ‘Apply Changes and Restart’.
A confirmation window opens for the Restart, Click ‘Confirm’.
All the changes are applied successfully.
Repeat the above steps with the second repository using the same bootstrap file.
You get three nodes in the server, as shown in the figure.
So, the Three-nodes are generated.
Configure each additional node with the processes that you want to run on it.
In the Configuration tab, give the following values to the node2 and node3.
Set Application server as 2
Set Interactive Microservices as 1
Set VizSQL Server as 2
Set Cache Server as 2
Enable Search and Browser
Set Background as 2
Set Non-Interactive Microservices as 1
Set Data Server as 2
Enable File Store
Enable Repository for node2 only
After adding all the requirements to the nodes, click on ‘Pending Changes’ and then click ‘Apply Changes and Restart’.
A confirmation window opens for the changes and restart, click ‘Confirm’.
All the nodes are updated in the Configuration and Status as well.
For confirmation, you can check the status of the server.
So the Three-node HA has been installed and configured successfully.
On ending up this tutorial, we have gone through the Basics of Tableau Server, Architecture and Components of Tableau Server, Installation, and Configuration process of Three-node HA clusters. To dig deep into the Tableau Server, get Tableau Server Training. Hope you find relevant information.