Tableau Platform Architecture

 Explanation of Tableau Platform Architecture:

Tips on Tableau Architecture.:(Gateway/ Load Balancer)

1-Gateway is a kind of web-server that helps clients communicate to the server via HTTP or https.
2-The server receives incoming client requests and directs them to the appropriate server for action.
3-A gateway handles processes such as load balancing, traffic routing, URL rewriting, serving static files to clients, serving multi-thread processes etc. The gateway server used by Tableau is Apache Tomcat.
4-Gateway will work as a load balancer and share the requests with the procedures. In a single-server configuration.
5-Tableau Server always uses only one machine as the primary server.
# #data #sql #analytics #tableaudesktop#Tableau Architecture#

 

Tips on Tableau Architecture.:(Application server)

1- Application server deals with login processes, domain authentication, data authorization, user or group permission management, content searches.

2-Deals with user interface requests.

3-The application server takes all the user requests coming from Tableau Desktop, mobile or browser for accessing the visualization. 

4-It processes the requests and detects the type of request, checks user authorization and grants access accordingly.

 

Tips on Tableau Architecture (VizQL server)

1-VizQL stands of Visualization Query language
2-Usually the client sends a request to the VizQL process (vizqlserver.exe). 
3-The VizQL process then sends queries directly to the data source.
4-Each VizQL Server has its own cache that can be shared across multiple users.
5-VizQL has first converted the client request into an SQL statement and sent it down to the data sources via respective data source drivers.
# #data #sql #analytics #tableaudesktop#Tableau Architecture#

 

Data Server

Tableau Data Server allows you centrally control and store Tableau data sources. It also manages metadata from Tableau Desktop, like calculations, definitions, and groups.

The data server helps in centralizing metadata management, driver deployment, and extract management. It also contributes to access control and serves as a proxy to the data sources. It hosts user queries and requests to prevent users from directly accessing the data source.

 

Data server uses external data sources to handle and store data. It is a central system for the management of data. Moreover, provides the metadata management requirements, data security, data storage, data connection, and driver. Then it stores the relevant data set information including metadata, computed fields, sets, classes, and parameters. Thus, the source of the data could also collect data and make live links to external data sources.

 The published data source can be founded on:

·        A Tableau Data Engine extract

·        A live connection to a relational database (cubes are not supported)

Tips on Tableau Architecture.:( Repository)

 1-The repository in Tableau Server stores server metadata related to users, permissions, assignments, groups, and projects.

2-Metadata stores visualizations in flat files (TWS, TDS), and performance data for auditing

3- metadata also provided from the repository.

4-It active directory to provide useful information to the app server for login verification processes.

# #data #sql #analytics #tableaudesktop#Tableau Architecture#

Tips on Tableau Architecture.:(Data Connectors)

1-Consists of a number of optimized data connectors for databases. like ODBC connectors designed for any systems without a native connector

2- It offers two modes in support of interacting with data: Live connection or In-memory. Clients can switch between a live and in-memory connection as they desire.

3-The customer data layer contains all sorts of data sources available for a Tableau user like data warehouses, data marts, flat files, and multi-dimensional cubes, relational databases

# #data #sql #analytics #tableaudesktop#Tableau Architecture#

 Tips on Tableau Architecture.:(DATA CONNECTOR)

1-Data connectors layers which consist of a data engine, repository, SQL Connector, and MDX Connector.
2-The Data engine processes the data requested by the user and assigns the data type, decides whether it is a measure or a dimension, and creates TDEs (data extracts)
3-Background of the data, engine runs an SQL Connector which creates an SQL query for all the user requests and interacts to the data sources. 
4-The SQL Connector primarily deals with data marts and flat files.
5-MDX Connector deals with the multi-dimensional cubes.