Tableau Server Architecture

Tableau Server has a high scalable architecture that many users can connect and receive service at the same time

With the Tableau Desktop application, a wide variety of rich views (reports and dashboards) can be prepared. Views prepared in Tableau Desktop application are uploaded to Tableau Server and made available to users. Actually, Tableau Server works like a Web Application Server.

Due to the modular architecture of the Tableau server application, many different services and processes can work together at the same time. The server architecture is as follows:

Gateway: is the Apache Web Server component (httpd.exe). It handles requests from all clients (browsers, mobile applications etc.) trying to connect to the server.

VizPortal: The application server is a web application that supports REST plugin functions and search functions.

VizQL Server: It runs queries, performs calculations, and allows views to be produced and loaded.

Data Server: Manages connections with data sources on the Tableau server.

Ask Data: is the module that enables the creation of various analyzes and visuals with the natural speaking language on the Tableau server.

Metadata Services: provides indexing of analysis, reports and dashboards on the server. In this way, it enables fast searching and easy access to the contents.

Data Engine: enables fast retrieval of data fed by reports and executes of complex data processing. Joining data from different databases, creating an extract, renewing the extract, etc. It performs important data loading operations.

 

Backgrounder,Prep Conductor: enables the creation of various flows on the Tableau server and the preparation of data outputs as a result of this flow. In addition, alarms can be set up on these outputs. In this way, it can send notifications to users when certain critical values are reached or the specified conditions are met. Timers can also be set up, such as periodic generation of data output.

 

Elastic Search, Cache Server, SOLR: Supply indexing the data enables fast and complex searches on the data and caching frequently used data.

 

Cluster Controller, Agent, Coordination Service: It is the service that provides management of clusters on the server, performing scheduled tasks and coordination of services on the server (disk, memory etc.).

 

Repository, File Store: It is the database used for the server’s own management. It is the data field where users, groups, projects, data sources and permissions defined on the server are stored. In addition, extract data etc. kept on the server with File Store. management and storage of such data is provided.

 

So, after all this theoretical knowledge, how can we check if these services on the server are working properly?

For this, we need to log in to the server management panel running on the server with the setup of the tableau server.

The name of this service is Tableau Server Management (TSM) and a web-based interface. To login to this interface, we connect to the TSM web interface in the browser as below. It can be accessed by entering https://localhost: 8850 or https://127.0.0.1:8850 in the address bar here. In addition, the server can be logged in with a defined Computer Name.

In the login screen opened in the browser, we will enter a user information defined on that server and have Administrator privileges. After entering this information, the working status of the services on the server as below will be displayed.

The green color indicates that the related service is working properly on the server. The red color indicates that the related service is not working or has received a warning or error.

The number of boxes next to the services varies as can be seen. For example, there is only one box next to the Gateway service, while there are 4 boxes next to the VizQL Server service. It shows how much resource is allocated for the relevant service on this server. In fact, it specifies the number of processes allocated for the relevant service. These resources can be configured according to the hardware of the server and the purpose of the server. However, extreme care must be taken when configuring this resource. For configuration operations, the Configuration tab in the upper tab is selected. A configuration screen like below will appear.

 22,230 views last month,  21 views today

About Mehmet Emin Paça

I am a Datawarehouse & Reporting expert having 4+ years experience in Oracle Business Intelligence 12c, Oracle Data Integrator 12c and Tableau. Also PL / SQL is my favorite language which I code it as my daily routine. Previously , I worked as a Senior Java Software Developer having 5 years experience. I am pleased to share my knowledge and experience so I am here

Leave a Reply

Do NOT follow this link or you will be banned from the site!